linux下mysql启动报错记录总结！ Starting MySQL.. ERROR! The server quit without updating PID file ...

今天在启动mysql时发现启动不了

[root@localhost local]# service mysql start Starting MySQL.. ERROR! The server quit without updating PID file (/var/lib/mysql/localhost.localdomain.pid).

 

 

 

接下来进入/var/lib/mysql ，查看localhost.localdomain.err文件

[root@localhost local]# cd /var/lib/mysql [root@localhost mysql]# ls -l 总用量 28692 -rw-rw----. 1 mysql mysql 18874368 12月 28 11:54 ibdata1 -rw-rw----. 1 mysql mysql  5242880 12月 28 12:07 ib_logfile0 -rw-rw----. 1 mysql mysql  5242880 12月 28 11:54 ib_logfile1 -rw-r-----. 1 mysql mysql    10502 12月 28 12:07 localhost.localdomain.err drwx--x--x. 2 mysql mysql        6 12月 22 18:48 mysql -rw-r--r--. 1 mysql mysql      583 12月 28 11:47 RPM_UPGRADE_HISTORY -rw-r--r--. 1 mysql mysql      453 12月 28 11:47 RPM_UPGRADE_MARKER-LAST drwxr-xr-x. 2 mysql mysql        6 12月 22 18:48 test [root@localhost mysql]# vim localhost.localdomain.err

 

 

 

 

 

 

 

发现 localhost.localdomain.err文件中有一句：Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist  这里报错

这是因为安装的时候数据目录不一致导致的

执行：[root@localhost mysql]#  /usr/bin/mysql_install_db --user=mysql --datadir=/var/lib/mysql/

Installing MySQL system tables... 191228 12:13:58 [Note] /usr/sbin/mysqld (mysqld 5.5.48) starting as process 3915 ... OK Filling help tables... 191228 12:13:58 [Note] /usr/sbin/mysqld (mysqld 5.5.48) starting as process 3922 ... OK To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands: /usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h localhost.localdomain password 'new-password' Alternatively you can run: /usr/bin/mysql_secure_installation which will also give you the option of removing the test databases and anonymous user created by default.  This is strongly recommended for production servers. See the manual for more instructions. You can start the MySQL daemon with: cd /usr ; /usr/bin/mysqld_safe & You can test the MySQL daemon with mysql-test-run.pl cd /usr/mysql-test ; perl mysql-test-run.pl Please report any problems at http://bugs.mysql.com/

 

 

 

 

 

 

 

 

 

 

 

 

 

 

此时重新启动mysql

[root@localhost mysql]# service mysql start Starting MySQL.. SUCCESS!  [root@localhost mysql]# ps -ef|grep mysql root      3967     1  0 12:14 ?        00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/localhost.localdomain.pid mysql     4058  3967  0 12:14 ?        00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/localhost.localdomain.err --pid-file=/var/lib/mysql/localhost.localdomain.pid root      4103  1592  0 12:14 pts/1    00:00:00 grep --color=auto mysql

 

 

 

 

 

 

 

发现已经ok了，这里记录一下。