EasyPHP
EN FR
>download >components >modules >blog >forum >faq >screenshots >introduction

For Windows Vista/Seven issues, please read the FAQ or leave a detailed message

Go to Topic: PreviousNext
Go to: Message ListNew TopicSearchLog InPrint View

#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.

Options: ReplyQuote
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

Options: ReplyQuote
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.

Options: ReplyQuote
Posted by: Thierry
October 01, 2010 09:56PM
in most uses, you dont need to change mysql password,

Options: ReplyQuote
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

Options: ReplyQuote
Posted by: Thierry
September 20, 2010 10:27AM
Not the problem, because MySQL respond.

Options: ReplyQuote
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

Options: ReplyQuote
Posted by: Amour
October 07, 2010 10:04PM
For tests purposes, can you try to disable Vista UAC ?

Options: ReplyQuote
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.

Options: ReplyQuote


Go to: Message ListSearchLog In
Your Name: 
Your Email: 
Subject: 
Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.