mysql服务器无响应时间,＃2002-服务器没有响应（或本地MySQL服务器的套接字未正确配置）...

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

解决方案

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';