Monday, January 14, 2008

MySQL Access Denied Error

Before dumping a list of databases between different MySQL servers, be sure to exclude the MySQL database.

Assuming you are importing the dump from Server A to Server B, the database imports the password from Server A onto B. There could be a few other settings that could be messed up too in the MySQL db if the versions are different.

To resolve this issue, set the MySQL password /etc/my.cnf on Server B to the one that was set on Server A. Restart the MySQL daemon.

To prevent this issue from occurring, specify the --databases parameter and explicitly mention the database names to be included before the process is executed.

No comments: