#2002 - 服务器没有响应(或者本地 MySQL 服务器的套接字没有正确配置)

2022-01-05 00:00:00 sockets xampp php mysql phpmyadmin

我无法访问 PHPMyAdmin.当我想去那里时,我收到了这个错误:

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

#2002 - 服务器没有响应(或者本地 MySQL 服务器的套接字没有正确配置)

#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

mysql 运行时有两个端口是打开的.

two ports are open when mysql is running.

我想在我的本地主机中访问 PHPMyAdmin.我正在使用 Ubuntu 操作系统

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

推荐答案

在 Ubuntu 中,默认情况下 mysql 不侦听 TCP/IP 连接.它只使用本地套接字.

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

当前本地套接字在 /etc/mysql/my.cnf 中配置.如果你打开这个文件,你应该会发现类似于:

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

您应该做的只是打开PHPMyAdmin 的配置文件(config.inc.php)并更改套接字地址.也许您的 PHPMyAdmin 上没有本地套接字配置,或者可能不同.该文件应包含如下一行(当然,请根据您在 my.cnf 上找到的地址调整地址):

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

相关文章