Home PageArchiveContact UsAbout Us
If you are hopelessly addicted to drupal;
if bringing yourself to bed is allways a strugle;
if your main source of entertainement
is watching lullabot videos; then you belog
here.

Installing MySQL

Video: 
See video

How to install MySQL on Linux. How to setup an AMP. How to install phpMyAdmin on CentOS.

 

The URL to download the MySQL configuration file is as follows:

https://github.com/Lullabot/lullabot-drupal-performance-scalabilty-files/blob/master/04-Prepping-MySQL/my.cnf

 

The SQL Query mentioned in the video is as follows:

CREATE USER 'pma'@'localhost' IDENTIFIED BY 'my_difficult_password';

GRANT USAGE ON mysql.* TO 'pma'@'localhost' IDENTIFIED BY 'my_difficult_password';

GRANT SELECT (
  Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv,
  Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv,
  File_priv, Grant_priv, References_priv, Index_priv, Alter_priv,
  Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv,
  Execute_priv, Repl_slave_priv, Repl_client_priv
) ON mysql.user TO 'pma'@'localhost';

GRANT SELECT ON mysql.db TO 'pma'@'localhost';

GRANT SELECT ON mysql.host TO 'pma'@'localhost';

GRANT SELECT (
  Host, Db, User, Table_name, Table_priv, Column_priv
) ON mysql.tables_priv TO 'pma'@'localhost';

GRANT SELECT, INSERT, UPDATE, DELETE ON phpmyadmin.* TO 'pma'@'localhost';

Average: 5 (1 vote)
Linux
Apache
PHP
MySQL

document listing steps

Hello, wasn't there some documents on your site to show the steps for the various installs? This along with the video? The steps would be a vailable reference and save some time when we need to look something up quickly. thanks