Mika/Notes
From WikiDotMako
Computer Stuff
=MySQL
mysql> create database newdatabase;
ERROR 1044 (42000): Access denied for user 'user'@'localhost'...
Solution:
1. Check grants for 'user'@'localhost' in mysql:
mysql> show grants for 'user'@'localhost';
2. Log into mysql as root (has all privileges) and change grants for a specific user:
mysql> grant all privileges on *.* to 'user'@'localhost';
Query OK, 0 rows affected (0.00 sec)
3. Log back into mysql as user (now has all privileges) and try creating a new database again.