WampServer

I am getting this:
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.
Error
MySQL said: Documentation
#1045 - Access denied for user 'root'@'localhost' (using password: NO)

This is a new event after working flawlessly for months. I probably caused my own problem. I created new database using phpMyAdmin and installed the software that will access dB. Then I deleted 'root' from privileges in phpMyAdmin.

My config.inc.php has for $cfg['Servers'][$i]:
['host'] = 'localhost';
['controluser'] = 'root';
['controlpass'] = '';
['auth_type'] = 'config';
['user'] = '';
['password'] = '';

How do I get back into phpMyAdmin?

Thank you
John D

Hi John

The solution is actually really simple .
you must been change the password for mysql database
now i hope that you remember what it is
you need to get into phpmyadmin directory (which located in wamp root directory) and edit the config.inc with notepad . (for example c:\wamp\phpmyadmin\conf.inc)
find those lines and type your password in " $cfg['Servers'][$i]['password'] ='your password'; "

$cfg['Servers'][$i]['user'] = 'root'; // MySQL user (defult)
$cfg['Servers'][$i]['password'] ='your password'; // MySQL password

save and exit . thats all !!

Alex

you put the right values in the wrong places. change:
['host'] = 'localhost';
['controluser'] = 'root';
['controlpass'] = '';
['auth_type'] = 'config';
['user'] = '';
['password'] = '';

to
['host'] = 'localhost';
['controluser'] = '';
['controlpass'] = '';
['auth_type'] = 'config';
['user'] = 'root';
['password'] = '';



CyberSpatium
----------------------
WAMP English Forum Admin

Need help? Check out my WAMP User Manual/Guide here!


Cellular Phone Deals - The Best on the Net! - FREE PHONES! Take your pick from our featured cellular phone deals by Cingular, Verizon, T-Mobile, Sprint PCS, Nextel, and more! Most of our cellular phone offers include a FREE cellular phone with FREE shipping!


Web Development for Newbie's Blog - Check out my new blog. It is for web developers, and especially tailored for the web development newbie. If you are not fluent in “geek speak”, then this incredible resource is just you. And even if you are a web development pro, this is a great resource to check out some of the latest web development tips, news, tutorials, codes and more.


Clarify Loans
Mortgage and Home Loan Advice


LaxGo Web Directory
Powerful human edited web directory of quality, spam-free sites organized via a comprehensive category structure.