linux 系统中系统关机后，mysql启动失败报错：ERROR 2002 (HY000): Can't connect to local MySQL server through socket '

最新推荐文章于 2024-07-23 15:53:03 发布

永恒的微笑

最新推荐文章于 2024-07-23 15:53:03 发布

阅读量798

点赞数

分类专栏： mysql 文章标签： mysql报错

本文链接：https://blog.csdn.net/ycj1982/article/details/82703361

版权

mysql 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

自己在阿里云服务器上安装好运行环境后，mysql都是正常使用的，昨天强制关闭服务器后，重新启动服务器，发现数据库无法启动报错：ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

通过查看mysqld.log（日志路径/var/log/）日志如下：

180914 10:57:33 [Note] Plugin 'FEDERATED' is disabled.
180914 10:57:33 InnoDB: The InnoDB memory heap is disabled
180914 10:57:33 InnoDB: Mutexes and rw_locks use GCC atomic builtins
180914 10:57:33 InnoDB: Compressed tables use zlib 1.2.3
180914 10:57:33 InnoDB: Using Linux native AIO
180914 10:57:33 InnoDB: Initializing buffer pool, size = 128.0M
180914 10:57:33 InnoDB: Completed initialization of buffer pool
180914 10:57:33 InnoDB: highest supported file format is Barracuda.
180914 10:57:33 InnoDB: Waiting for the background threads to start
180914 10:57:34 InnoDB: 5.5.61 started; log sequence number 2129689
180914 10:57:34 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
180914 10:57:34 [Note] - '0.0.0.0' resolves to '0.0.0.0';
180914 10:57:34 [Note] Server socket created on IP: '0.0.0.0'.
180914 10:57:34 [ERROR] Can't start server: can't check PID filepath: No such file or directory

最后网络搜索解决方案是：

1、在以下目录中（/run/）创建mysqld文件夹：mkdir /run/mysqld

2、给mysqld权限：chown -R mysql:mysql /run/mysqld

3、执行启动：/etc/init.d/mysqld start

service mysqld status 启动成功