mysql sock golang_MySQL Study之--MySQL启动错误“/var/lib/mysql/mysql.sock”-Go语言中文社区...-CSDN博客

本文链接：https://blog.csdn.net/weixin_39601511/article/details/113275446

本文介绍了如何检查和解决MySQL启动时遇到的'/var/lib/mysql/mysql.sock'错误。通过查看系统信息和日志，可以发现MySQL已创建了sock文件，但可能由于权限或配置问题导致服务无法正常启动。解决方案可能包括调整权限设置或检查相关配置文件。

摘要由CSDN通过智能技术生成

查看系统信息：

[root@rh64 ~]# ls -l /var/lib/mysql

total 110620

-rw-rw----. 1 mysql mysql 56 Sep 6 18:08 auto.cnf

-rw-rw----. 1 mysql mysql 12582912 Sep 8 16:18 ibdata1

-rw-rw----. 1 mysql mysql 50331648 Sep 8 16:18 ib_logfile0

-rw-rw----. 1 mysql mysql 50331648 Sep 6 18:06 ib_logfile1

drwx------. 2 mysql mysql 4096 Sep 6 18:06 mysql

srwxrwxrwx. 1 mysql mysql 0 Sep 8 16:18 mysql.sock

drwx------. 2 mysql mysql 4096 Sep 6 18:06 performance_schema

-rw-rw----. 1 mysql mysql 5 Sep 8 16:18 rh64.pid

-rw-r--r--. 1 root root 293 Sep 6 18:07 RPM_UPGRADE_HISTORY

-rw-r--r--. 1 mysql mysql 293 Sep 6 18:07 RPM_UPGRADE_MARKER-LAST

drwx------. 2 mysql mysql 4096 Sep 6 18:06 test

查看系统日志：

[root@rh64 ~]# tail /var/log/mysqld.log

2015-09-08 16:18:10 2370 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.25-73.1 started; log sequence number 1626017

2015-09-08 16:18:10 2370 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work.

2015-09-08 16:18:10 2370 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work.

2015-09-08 16:18:10 2370 [Note] Server hostname (bind-address): '*'; port: 3306

2015-09-08 16:18:10 2370 [Note] IPv6 is available.

2015-09-08 16:18:10 2370 [Note] - '::' resolves to '::';

2015-09-08 16:18:10 2370 [Note] Server socket created on IP: '::'.

2015-09-08 16:18:10 2370 [Note] Event Scheduler: Loaded 0 events

2015-09-08 16:18:10 2370 [Note] /usr/sbin/mysqld: ready for connections.

Version: '5.6.25-73.1' socket: '/var/lib/mysql/mysql.sock' port: 3306 Percona Server (GPL), Release 73.1, Revision 07b797f