WampServer

Alright basically I visit phpmyadmin and I get this error:

(I've read all the latest posts regarding phpmyadmin in the title and search doesn't/can't find any topics regarding my question)


--ERROR--
Error
MySQL said:

Cannot connect: invalid settings.
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
--ERROR--

My php pages work and what not (All my apps that i created works fine even with the database), something is just wrong with phpmyadmin connecting with mysql.

Alright I found a fix. Latest version of Wampserver had the incorrect settings.


IN: C:\wamp\apps\phpmyadminVERSION\config.inc.php

Find:

$cfg['Servers'][$i]['AllowNoPasswordRoot'] = true;

Replace:
$cfg['Servers'][$i]['AllowNoPassword'] = true;

Fixes the problem.

My error is now,

Error
MySQL said:

#1045 - Access denied for user 'root'@'localhost' (using password: YES) ITS WAS NO NOW ITS YES ?????

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

Alright now your username could be incorrect. Download [downloads.jlbn.net] resetmysql and read the readme.

download resetmysql here
[downloads.jlbn.net]

to setup password, follow this
[blog.jlbn.net]

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

I solved my problem using the following help.

Thanks for all.

Re: PHPMYADMIN - Cannot connect: invalid settings. Latest WAMPServer Build (2i) new
Posted by: Lamonte (---.dsl.stlsmo.sbcglobal.net)
Date: July 27, 2009 09:03AM

Alright I found a fix. Latest version of Wampserver had the incorrect settings.


IN: C:\wamp\apps\phpmyadminVERSION\config.inc.php

Find:

$cfg['Servers'][$i]['AllowNoPasswordRoot'] = true;

Replace:
$cfg['Servers'][$i]['AllowNoPassword'] = true;

Fixes the problem.



Excellent Help!