报错:MySQL Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
2023-09-11 14:14:33 时间
报错背景
进入mysql的时候报错
报错现象
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
报错原因
/var/lib/mysql 的访问权限问题。
报错解决
配置权限 # chown -R mysql:mysql /var/lib/mysql 重启mysql # systemctl restart mysqld
相关文章
- PHP连接MySQL报错:SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket 'MySQL' (2)
- 【Mysql安装】Mac下安装mysql
- 【异常】ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock
- linux - mysql - 卸载:RPM包安装方式的MySQL卸载
- MySQL按照汉字的拼音排序,mysql汉字排序
- XtraBackup出现 Can't connect to local MySQL server through socket '/tmp/mysql.sock'
- SQL SERVER全面优化-------Expert for SQL Server 诊断系列
- Starting MySQL. ERROR! The server quit without updating PID file
- Can’t connect to local MySQL server through socket
- CentOS下httpd下php 连接mysql 本机可以,外网报错Could not connect: Can't connect to MySQL server on '127.0.0.1' (13)2003 原因解析
- mysql 有报错 ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists
- mysql启动时报错:Starting MySQL... ERROR! The server quit without updating PID file (/opt/mysql/data/mysql.pid) 的解决方法
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
- [转]2006 MySQL server has gone away错误,最大值溢出解决办法 mysql max_allowed_packet 查询和修改
- Python MySQL - mysql-connector 驱动
- mysql_server下载安装
- Mysql连接报错:1130-host ... is not allowed to connect to this MySql server如何处理
- Python:mysql-connector-python模块对MySQL数据库进行增删改查
- MYSQL导入数据报错|MYSQL导入超大文件报错|MYSQL导入大数据库报错:2006 - MySQL server has gone away
- file /usr/share/mysql/charsets/README from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
- 网络安全攻防之Mysql数据库3306端口加固
- [MySQL] 解决办法: Error: Transaction test error: file /etc/my.cnf from install of mysql-community-server
- 如何实现MySQL表数据随机读取?从mysql表中读取随机数据
- [MySQL] 解决办法: Error: Transaction test error: file /etc/my.cnf from install of mysql-community-server