问题原文
原帖链接 · 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!
摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。
