introduction screenshots faq forum blog modules components download
Please use the search function and/or read the FAQ first.
-->

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



Posted by: Pete
September 06, 2010 02:51PM
I changed the password for 'root' in via phpMyAdmin

I could no longer use phpMyAdmin and receive this message - #1045 - Access denied for user 'root'@'localhost' (using password: NO)

I edited config.inc.php with the proper password for root and set AllowNoPassword - False.

When I view MySql parameters in EasyPHP, it shows no password - not matching the changed made in phpMyAdmin.

I still receive the access denied message.
Posted by: Amour
September 06, 2010 05:23PM
Are you sure you changed right config.inc.php ?

If it said "Access denied for user 'root'@'localhost' (using password: NO) " it seems there is no password specified into config.inc.php
Posted by: Tomd
September 30, 2010 11:24PM
I encounter the exact same problem, even after I uninstalled and install the package again! I guess the mysql config info saved in Windows folder somewhere? (I'm using win 7)

This is a real bummer, the admin function should work smarter. XAMPP gets it right, not only it works no problem after changing root password, it actually pushes you to do so at the first place.
Posted by: Thierry
October 01, 2010 09:56PM
in most uses, you dont need to change mysql password,
Posted by: Sander
September 18, 2010 02:10PM
On Windows 7? If so probably due to the fact that with ipv6 on, localhost is translated into [::1] by the DNS service.
Solution: Remove in c:\windows\system32\drivers\etc\host the "#" sign in front of the line: # 127.0.0.1 localhost
Posted by: Thierry
September 20, 2010 10:27AM
Not the problem, because MySQL respond.
October 07, 2010 09:41PM
Hi, I have the same problem on a vista pro.

I stop Apache and mysql services, I uninstall easyphp, I delete the directory in Program files, I clean the registry, I reinstall easyPhp and ... it's magic, MySQL prompt Access denied for user 'root'@'localhost' (using password: NO) because it ask for the old password, more than that, the structure and the datas of the database are again here.
I need to reinstall completely easyPHP because the mySQL database does not work well anymore. How could I delete completely the old installation.

Best Regards.

Another Thierry
Posted by: Amour
October 07, 2010 10:04PM
For tests purposes, can you try to disable Vista UAC ?
Posted by: Thierry
October 12, 2010 10:12AM
Remove any config_inc.php file from

%USERPROFILE%\Local\VirtualStore\Program Files (x86)\EasyPHP-5.3.3\

and edit config file from your installation path.