MySQL报错解决：ERROR! The server quit without updating

字数统计: 307字   |   阅读时长≈ 1分

至此已解决问题，如果数据库中的数据非常重要的话，请不要参考网上那些初始化数据库。

报错：

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
[root@test leo]# lnmp restart   
+-------------------------------------------+
|    Manager for LNMP, Written by Licess    |
+-------------------------------------------+
|              https://lnmp.org             |
+-------------------------------------------+
Stoping LNMP...
Stoping nginx...  done
ERROR! MySQL server PID file could not be found!
Gracefully shutting down php-fpm . done
Starting LNMP...
Starting nginx...  done
Starting MySQL.. ERROR! The server quit without updating PID file (/tmp/mysql/mysql.pid).    ##启动数据库的时候报错，PID文件丢失，并不能创建成功。
Starting php-fpm  done
[root@test leo]# ps aux |grep mysql
root      17903  0.0  0.0 103324   852 pts/0    S+   10:30   0:00 grep mysql

解决：

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
[root@test leo]# vim /etc/my.cnf    #修改MySQL的配置文件
[mysqld]
pid-file = /tmp/mysql/mysql.pid     #添加这一行
[root@test leo]# mkdir -p /tmp/mysql
[root@test leo]# chown mysql.mysql  /tmp/mysql    #设置目录的权限给mysql这个用户
[root@zuitu leo]# lnmp restart
+-------------------------------------------+
|    Manager for LNMP, Written by Licess    |
+-------------------------------------------+
|              https://lnmp.org             |
+-------------------------------------------+
Stoping LNMP...
Stoping nginx...  done
ERROR! MySQL server PID file could not be found!   ##关闭MySQL服务失败，因为MySQL服务根本没有启动
Gracefully shutting down php-fpm . done 
Starting LNMP...
Starting nginx...  done
Starting MySQL.. SUCCESS!  ##启动MySQL服务成功
Starting php-fpm  done
[root@test leo]# netstat -tunlp  |grep mysql
tcp        0      0 0.0.0.0:3306                0.0.0.0:*                   LISTEN      21188/mysqld        
[root@test leo]#

扫一扫，分享到微信

tag:

    缺失模块。
    1、请确保node版本大于6.2
    2、在博客根目录（注意不是yilia-plus根目录）执行以下命令：
    npm i hexo-generator-json-content --save

    3、在根目录_config.yml里添加配置： 

      jsonContent:
    meta: false
    pages: false
    posts:
      title: true
      date: true
      path: true
      text: false
      raw: false
      content: false
      slug: false
      updated: false
      comments: false
      link: false
      permalink: false
      excerpt: false
      categories: false
      tags: true

比别人优秀不重要，重要的是比昨天的自己更优秀。