Wednesday, July 27, 2011

#2002 cannot log in to the MYSQL server

I opened phpMyAdmin and tried to log into it , even though i typed in the correct username and password i got the following error message

#2002 cannot log in to the MYSQL server

I installed mysql server on port 3305. The default port that it installs to is 3306 and that is the same port phpMyAdmin would try.

Solution :-

open config.inc.php. Found under the phpMyAdmin folder
locate the following line

$cfg['Servers'][$i]['port'] = 'x';

x = port that mysql listens

Make x the value mysql is set to run on. If you cannot remember the port that it runs on then goto -> http://scriptche.blogspot.com/2011/07/find-out-what-port-mysql-is-using.html

No comments:

Post a Comment