phpMyAdmin is giving error
#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)
Probably there are two mysql running. Open the terminal and run
Now restart lampp and try to open phpMyAdmin.
Make sure you have following code in your /opt/lampp/phpmyadmin/config.inc.php
If you are still facing the problem. Add this line in your config.inc.php too.
If you are still facing the problem, Make following changes in your config.inc.php
change #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)
Probably there are two mysql running. Open the terminal and run
$ service mysql stop or $ service mysqld stop(according to your Linux distribution)
Now restart lampp and try to open phpMyAdmin.
Make sure you have following code in your /opt/lampp/phpmyadmin/config.inc.php
$cfg['Servers'][$i]['connect_type'] = 'tcp';
If not, add above line in config.inc.php and Restart mysql.If you are still facing the problem. Add this line in your config.inc.php too.
$cfg['Servers'][$i]['socket'] = '/var/run/mysql/mysql.sock';
and Restart mysql.If you are still facing the problem, Make following changes in your config.inc.php
$cfg['Servers'][$i]['host'] = 'localhost';
to
$cfg['Servers'][$i]['host'] = '127.0.0.1';Now restart mysql and open phpmyadmin.
If you are still facing the problem, check permission of the file /opt/lampp/phpmyadmin/config.inc.php, it should not be less than 755.
Set it to 755.
Run following command.
$ sudo chmod 755 /opt/lampp/phpmyadmin/config.inc.php
Now restart LAMPP and try to open phpmyadmin again.http://localhost/phpmyadmin
Thank you veru much :D
ReplyDeleteThis comment has been removed by a blog administrator.
ReplyDeleteThank you! It works for me! =D
ReplyDeletehelped me to overcome the error.
ReplyDeleteExcellent items from you, man. I've be mindful
ReplyDeleteyour stuff previous to and you are just too great.
I actually like what you have obtained right
here, certainly like what you are stating and the
way in which during which you are saying it. You are making it entertaining and you still
care for to keep it smart. I cant wait to learn far more
from you. That is really a tremendous website.
Also visit my weblog: massage virginia beach (https://Plus.google.com)
greetings from me :) i have some problem, can't connect my db, maybe can you help me? mysql is error and many db is urgent... i can't kill mysql, i will try of all step but nothing work, mysql already running, i don't know what am i do, maybe you can help me bro... :) thanks before....
ReplyDelete