Archive for the ‘MySQL’ Category

Assigning privileges to a user on MySQL DB

Tuesday, February 3rd, 2009

Quick and dirty commands from commandline: mysql -u <user> -p<password> mysql> CREATE DATABASE wordpress; mysql> GRANT ALL PRIVILEGES ON wordpress.* TO 'wpuser'@'localhost' IDENTIFIED BY 'dbpassword'; ...