DBI Connect Failed:Access denied for user ''@'localhost' to database <database> error

kaplan71 · 06-04-2009, 05:22 PM

Hi there --

I am trying to run a mysql 5.0.56 distribution, and whenever I try to either change the root password, or create a database, the following error message appears:

Quote:

DBI Connect Failed:Access denied for user ''@'localhost' to database <database>

The database was installed via yum onto a CentOS 5.3 server. I tried removing, and then reinstalling the database via yum, but the results were the same. What do I need to do in order to correct this problem?

irishbitte · 06-04-2009, 06:35 PM

Put these commands in exactly as I describe them, one line after another. Don't forget the semi-colon:

Code:

mysql -u root
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyPW');
exit

obviously changing MyPW to something you are happy with.

kaplan71 · 06-04-2009, 06:48 PM

Hi there --

Thanks for your reply. I went through the commands that you listed, but the error message I got was the following:

Quote:

ERROR 1133 (42000): Can't find any matching row in the user table

What is the next move to make? Thanks.

irishbitte · 06-05-2009, 12:39 PM

Hmmm. Took a quick google search of your last error message, and found this: http://ircarchive.info/mysql/2007/4/13/15.html. See if that helps. I reckon you're typing ROOT instead of root, am I correct?