首页 > 数据库技术 > 详细

连接mysql出现错误:Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.soc

时间:2020-05-13 18:06:56      阅读:52      评论:0      收藏:0      [点我收藏+]

1、先通过:service  mysqld  status  查看mysql是否启动

      (没装mysql service 也可通过 /etc/rc.d/init.d/mysqld status查看)

      若没启动,则启动mysql:service  mysqld  start

2、方法: 修改/etc/my.conf:
[mysqld]
datadir=/usr/local/mysql/data

socket=/var/lib/mysql/mysql.sock

[mysql.server]
user=mysql
basedir=/usr/local/mysql

If there is not currently a section called [client], add one at the bottom of the file and copy the socket= line under the [mysqld] section such as:

[client]
socket=/var/lib/mysql/mysql.sock
(注意:红色标记部分文件路径必须相同)

发现依旧如此,运行/etc/init.d/mysql start报错:Starting MySQLCouldn‘t find MySQL manager or server
是mysqld服务没启,运行/usr/local/mysql/bin/mysqld_safe &

连接mysql出现错误:Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.soc

原文:https://www.cnblogs.com/zhuyeshen/p/12883430.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!