#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)

Question

I can't access to PHPMyAdmin. when i want to go there, i got this error:

#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)

I googled this error but it don't clear.

I try to know that which port is open by this code :

pgrep mysql

two ports are open when mysql is running.

I want to access to PHPMyAdmin in my localhost. I am using Ubuntu OS

Answer 1

In Ubuntu, by default mysql is not listening to TCP/IP connections. It just uses a local socket.

The current local socket is configured in /etc/mysql/my.cnf . If you open this file, you should find something similar to:

[client]
port            = 3306
socket          = /var/run/mysqld/mysqld.sock

What you should do is just to open PHPMyAdmin's config file (config.inc.php) and change the socket address. Maybe there's no local socket configuration on your PHPMyAdmin, or maybe it is different. This file should contain a line like (of course, adapt the address to what you found on my.cnf):

$cfg['Servers'][$i]['socket'] = '/var/run/mysqld/mysqld.sock';