MySQL ：error The server quit without updating PID file (/usr/local/mysql/data/mysql.pid)
MySQL ：error The server quit without updating PID file (/usr/local/mysql/data/mysql.pid)
首先检查磁盘是否满了。
[root@iZ25o0ipjpmZ /]# df Filesystem 1K-blocks Used Available Use% Mounted on /dev/xvda1 41282880 34458604 4727228 88% / tmpfs 960368 0 960368 0% /dev/shm
检查mysql data文件权限。
drwxr-xr-x 5 mysql mysql 4096 Mar 2 15:47 mysql
mysql:mysql 正确权限。
不是的话，修改正确权限
chowm -R mysql:mysql mysql [root@iZ286290rd2Z note.topc.cc]# service mysqld start Starting MySQL [ OK ]
在启动selinux 的时候可能会影响到MySQL进程，可以尝试关闭重启：
vim /etc/selinux/config #设置 SELINUX=disabled reboot #重启
如果还不行的话，就只能去查看错误日志：
打印出来的错误日志：
170112 17:47:14 [Note] Event Scheduler: Purging the queue. 0 events 170112 17:47:14 InnoDB: Starting shutdown... 170112 17:47:15 InnoDB: Shutdown completed; log sequence number 2378628 170112 17:47:15 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 170112 17:49:32 [Note] Plugin 'FEDERATED' is disabled. 170112 17:49:33 InnoDB: The InnoDB memory heap is disabled 170112 17:49:33 InnoDB: Mutexes and rw_locks use GCC atomic builtins 170112 17:49:33 InnoDB: Compressed tables use zlib 1.2.3 170112 17:49:33 InnoDB: Using Linux native AIO 170112 17:49:33 InnoDB: Initializing buffer pool, size = 128.0M 170112 17:49:33 InnoDB: Completed initialization of buffer pool 170112 17:49:33 InnoDB: highest supported file format is Barracuda. 170112 17:49:33 InnoDB: Waiting for the background threads to start 170112 17:49:34 InnoDB: 5.5.54 started; log sequence number 2378628 170112 17:49:34 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 170112 17:49:34 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 170112 17:49:34 [Note] Server socket created on IP: '0.0.0.0'. 170112 17:49:34 [Note] Event Scheduler: Loaded 0 events 170112 17:49:34 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.5.54-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL) 170117 18:12:20 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown
之前第一次安装的过程中磁盘100%导致数据库中有的系统表没写入到mysql database中。
我只能备份好数据重装之后正常使用了。
[root@iZ286290rd2Z mysql]# ps auxww | grep 'mysql' root 8856 0.0 0.0 110188 624 pts/1 D+ 16:06 0:00 grep --color mysql root 24659 0.0 0.0 11764 1596 ? S Jan17 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/data/mysql --pid-file=/data/mysql/mysql.pid mysql 25477 0.1 5.6 534288 106916 ? Sl Jan17 95:46 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/data/mysql --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/data/mysql/mysql-error.log --open-files-limit=65535 --pid-file=/data/mysql/mysql.pid --socket=/tmp/mysql.sock --port=3306
