Drupal/MySQL command line dbuser setup

This is another one of those things I always forget and need to trace down docs to remember: setting up a MySQL user for Drupal from the CLI.

mysqladmin -u [username] -p create [databasename]

mysql -u [username] -p [databasename]

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, INDEX, 
DROP, CREATE TEMPORARY TABLES, LOCK TABLES
ON databasename.* 
TO 'newusername'@'localhost' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;

freetags:

Add new comment