Wednesday, October 20, 2010

Phpmyadmin login problem

I have started my MySQL server. I can successfully login using the command line. ie..,

mysql> mysql -u root -p password
However, I couldnot login in phpmyadmin with the same username and password.


The solution to above problem is ...

1. Open the hosts.allow file in /etc directory.
$sudo vim /etc/hosts.allow

2. Add the following line in it.
mysqld: 127.0.0.1: ALLOW

Then, u can successfully login in phpmyadmin.

Thanks.