> 技术文档 > 【MySQL安装】—报错“Can‘t connect to local MySQL server through socket ‘varlibmysqlmysql.sock‘”_can\'t connect to local mysql server

【MySQL安装】—报错“Can‘t connect to local MySQL server through socket ‘varlibmysqlmysql.sock‘”_can\'t connect to local mysql server


项目场景:

执行 “mysql -uroot -p” 命令,进入MySQL数据库。

【MySQL安装】—报错“Can‘t connect to local MySQL server through socket ‘varlibmysqlmysql.sock‘”_can\'t connect to local mysql server


问题描述:

报错 Can\'t connect to local MySQL server through socket \'/var/lib/mysql/mysql.sock\'


原因分析:

/var/lib/mysql路径下缺少mysql.sock文件。

【MySQL安装】—报错“Can‘t connect to local MySQL server through socket ‘varlibmysqlmysql.sock‘”_can\'t connect to local mysql server


解决方案:

执行以下语句:
systemctl status mysqld #查看mysql的服务状态
systemctl restart mysqld #重启mysql服务

【MySQL安装】—报错“Can‘t connect to local MySQL server through socket ‘varlibmysqlmysql.sock‘”_can\'t connect to local mysql server

【MySQL安装】—报错“Can‘t connect to local MySQL server through socket ‘varlibmysqlmysql.sock‘”_can\'t connect to local mysql server

【MySQL安装】—报错“Can‘t connect to local MySQL server through socket ‘varlibmysqlmysql.sock‘”_can\'t connect to local mysql server

注意: 一定要root用户下执行命令,atwqf用户是没有权限,执行\"systemctl restart mysqld\"命令重启mysql服务会报错。

【MySQL安装】—报错“Can‘t connect to local MySQL server through socket ‘varlibmysqlmysql.sock‘”_can\'t connect to local mysql server
【MySQL安装】—报错“Can‘t connect to local MySQL server through socket ‘varlibmysqlmysql.sock‘”_can\'t connect to local mysql server

执行 \"sudo cat /var/log/mysqld.log\"命令,查看mysql运行日志,看错误原因。

【MySQL安装】—报错“Can‘t connect to local MySQL server through socket ‘varlibmysqlmysql.sock‘”_can\'t connect to local mysql server


参考文章:

详细解决linux安装mysql后登录报错:Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘ (2)