(create a page to keep track of things I learned) |
(No difference)
|
Revision as of 17:41, 28 November 2009
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.