View Single Post
  #41  
Old 06-20-2003, 09:55 AM
mamba666
Sarnak
 
Join Date: Apr 2003
Posts: 41
Default 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.
Reply With Quote