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;
Add new comment