Re: ERROR 1045: Access denied for user: '@localhost' (Using password: NO)

[Mohamed Mansour]

I do it like this.. copied from the manual of mysql...
I create the user and add his priveleges to that database...

Database : myDatabaseName
User: myUsername
Usershost: localhost
Users password: MyPassword

GRANT ALL PRIVILEGES ON `myDatabaseName`.`*` TO `myUsername`@`localhost` IDENTIFIED BY 'MyPassword';

AND!! Root already has all the priveleges needed.
So if your logged on root you could do this:

CREATE DATABASE newdatabase;
SHOW DATABASES;


hope it helped

Mohamed Mansour
Software Engineer
Microsoft Student Partner Alumni