连接Mysql 报错ERROR 2002 (HY000)

新手上路,请多包涵

1.Mysql 已经装好了,DB driver 也已经安装成功,在尝试连接数据库时候失败

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

已经尝试:

mysql start

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

mysql -uroot

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

mysql -h localhost

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

mysql -h 127.0.0.1

ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
然后去temp文件夹下面根本没有目标文件

/tmp/mysql.sock

使用查找命令:

find / -name mysql.sock

都是:

Permission denied

网上找了好多都失败~求助,谢谢

阅读 2.8k
1 个回答

vi /etc/mysql.cnf

看下 [mysqld] 和 [mysql] 标签下 socket 配置的路径是否一致

修改后重启mysql

撰写回答
你尚未登录,登录后可以
  • 和开发者交流问题的细节
  • 关注并接收问题和回答的更新提醒
  • 参与内容的编辑和改进,让解决方法与时俱进
推荐问题