Apache Friends Support Forum

Hi everyone, I had phpMyAdmin working for some time and then I did the latest upgrade. I now am getting a #1045 error. Here is the error:

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

I also cannot make a connection through dreamweaver. Any help and advise would be great. I am pretty new to this so please be patient with me.

Thanks,
Robert

Did you change the MySQL root password previously?

I have not change anything from the time that it was working. This is what is so confusing to me.

And assuming that you never have set a password for the root user... there's a resetroot.bat file in c:\xampp\mysql\. Try that one. It should reset the root password back to nothing.

I ran the file and I am still getting the same error.

Please verify that this file actually removes the password
(does it contain:)
blablabla 'localhost','root', '', blablabla (the empty set of '' matter)

Then manually run the mysql.exe client:

C:\xampp\mysql\bin\mysql.exe -u root

Do you get in that way? If not, you're probably not running the xampp mysql database...

Here is the full message that I am getting:

[ERROR] Error message file 'C:\xampp mysql\share\english\errmsg.sys had only 472 error messages, but it should contain at least 475 error messages. Check that the above file is the right version for this program! 080514 10:34:00 [ERROR] Aborting

Passwords for user "root" and "pma" were deleted.


Does this give you any more information?

Well, there's something definitely wrong with your mysql installation. Are you sure your upgrade completed? Maybe a fresh xampp install wouldn't be a bad idea...

I will try that now and let you know as soon as it completes.

Success, I finally got it work. After uninstalling and reinstalling 3 times I finally had to clear 4 leftover registry entries that I guess were causing the problem. After I did that I reinstalled and everything works again. Thanks for your help.

Cool!