大网数据广告活动
服务器运维问答

Why is MySQL connecting through socket even though I'm specifying host and port?

· 52CE 我爱测

When trying to connect to a MySQL database running on port 3306 on localhost (using the command line tool mysql ), I'm getting the error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2…

问题原文

原帖链接 · qff · CC BY-SA 3.0

When trying to connect to a MySQL database running on port 3306 on localhost (using the command line tool mysql), I'm getting the error:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Here's the command I'm using:

> mysql -h localhost -P 3306
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Specifying user and password also doesn't work:

> mysql -h localhost -P 3306 -u dbuser -p
Password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Why is it trying to use a UNIX socket file (as it seems to be doing here) when I'm specifying host and port?

已采纳解答

原帖链接 · qff · CC BY-SA 3.0

You need to use 127.0.0.1 instead of localhost:

> mysql -h 127.0.0.1 -P 3306
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8347701
Server version: 5.6.35-80.0-log Percona Server (GPL), Release 80.0, 
Revision f113994f31
...

You're in!

摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。

资料来源与适用范围

资料来源
Server Fault
适用范围
以原帖系统、软件版本与发布日期为准(2017-04-12)
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY-SA 3.0

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。