stuff to buy!!

Monday, December 15, 2008

ERROR 1044 (42000): Access denied for user 'user'@'localhost' to database 'testing'

I' am getting this error when trying to create a test db or any db for that matter through ssh.

ERROR 1044 (42000): Access denied for user 'user'@'localhost' to database 'testdb'


still working on the fix.. will update once found :)

UPDATE: 12:26:08

It looks like this was an issue with permissions for the database. Ensim did not change the permissions for the database and they must be changed via ssh.

GRANT ALL PRIVILEGES ON *.* TO 'user'@'localhost' ;

Depending on the perms you want to give you may or may not want to grant all. That's all up to you!

No comments:

Buy more Stuff!!!