Error: #1045: Access denied for user
Hi,
For this specific error you must do the Grant All Privileges command.
Specifically grant the permission for the user that you use to connect to the MYSQL database.
Here is the command that I used. My username is "mysql" that I access my mysql database with.
GRANT ALL PRIVILEGES ON *.* TO 'mysql'@127.0.0.1 IDENTIFIED BY 'mysql' WITH GRANT OPTION;
This eliminated that acess denied error.
When I did the generic command :
GRANT ALL PRIVILEGES ON *.* TO '%'@127.0.0.1 IDENTIFIED BY '%' WITH GRANT OPTION;
This did not work for me.
I hope this gets you going.
|