Setting up a Drupal server

I go through the process of manually configuring mysql for a new drupal site often enough that I thought I'd document the process so I won't have to look it up every time! I don't do it often enough to commit the process to memory.

After setting up an SQL database with the mysql utility, you must grant it permissions for the drupal user you set up. This is the command to do so:

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