lnmp安装完之后正常数据库重启之后mysql启动错误
安装之后没问题重启了2次就数据库报错了。。sudo /bin/lnmp status
+-------------------------------------------+
| Manager for LNMP, Written by Licess |
+-------------------------------------------+
| http://lnmp.org |
+-------------------------------------------+
nginx (pid 4427 4425 4424 4423 4422) is running...
php-fpm is runing!
● mysql.service - LSB: start and stop MySQL
Loaded: loaded (/etc/init.d/mysql)
Active: failed (Result: exit-code) since 四 2016-04-21 10:40:10 CST; 12s ago
Process: 5165 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)
4月 21 10:40:08 raspberrypi mysql: Starting MySQL
4月 21 10:40:10 raspberrypi mysql: ..The server quit without updating PID file (/var/run/mysqld/mysqld....iled!
4月 21 10:40:10 raspberrypi systemd: mysql.service: control process exited, code=exited status=1
4月 21 10:40:10 raspberrypi systemd: Failed to start LSB: start and stop MySQL.
4月 21 10:40:10 raspberrypi systemd: Unit mysql.service entered failed state.
Hint: Some lines were ellipsized, use -l to show in full.
日志
160421 10:04:05 mysqld_safe mysqld from pid file /usr/local/mysql/var/raspberrypi.pid ended160421 10:04:13 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
160421 10:04:14 InnoDB: The InnoDB memory heap is disabled
160421 10:04:14 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160421 10:04:14 InnoDB: Compressed tables use zlib 1.2.8
160421 10:04:14 InnoDB: Initializing buffer pool, size = 16.0M
160421 10:04:14 InnoDB: Completed initialization of buffer pool
160421 10:04:14 InnoDB: highest supported file format is Barracuda.
160421 10:04:58InnoDB: Waiting for the background threads to start
160421 10:04:59 InnoDB: 5.5.42 started; log sequence number 1595675
160421 10:04:59 Server hostname (bind-address): '0.0.0.0'; port: 3306
160421 10:04:59 - '0.0.0.0' resolves to '0.0.0.0';
160421 10:04:59 Server socket created on IP: '0.0.0.0'.
160421 10:04:59 Event Scheduler: Loaded 0 events
160421 10:04:59 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.42-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
160421 10:06:44 IP address '192.192.12.44' could not be resolved: Temporary failure in name resolution
160421 10:06:54 IP address '192.192.12.44' could not be resolved: Temporary failure in name resolution
160421 10:07:08 IP address '192.192.12.44' could not be resolved: Temporary failure in name resolution
160421 10:07:10 IP address '192.192.12.44' could not be resolved: Temporary failure in name resolution
160421 10:18:47 IP address '192.192.12.44' could not be resolved: Temporary failure in name resolution
160421 10:18:48 IP address '192.192.12.44' could not be resolved: Temporary failure in name resolution
160421 10:24:41 /usr/local/mysql/bin/mysqld: Normal shutdown
160421 10:24:41 Event Scheduler: Purging the queue. 0 events
160421 10:24:43 /usr/local/mysql/bin/mysqld: Forcing close of thread 12user: 'stockcat'
160421 10:24:43 /usr/local/mysql/bin/mysqld: Forcing close of thread 11user: 'stockcat'
160421 10:24:43 /usr/local/mysql/bin/mysqld: Forcing close of thread 8user: 'stockcat'
160421 10:24:43 /usr/local/mysql/bin/mysqld: Forcing close of thread 7user: 'stockcat'
160421 10:24:45InnoDB: Starting shutdown...
160421 10:24:51InnoDB: Shutdown completed; log sequence number 1706477
160421 10:24:51 /usr/local/mysql/bin/mysqld: Shutdown complete
160421 10:24:51 mysqld_safe mysqld from pid file /usr/local/mysql/var/raspberrypi.pid ended -- Logs begin at 四 2016-04-21 11:11:14 CST, end at 四 2016-04-21 11:21:05 CST. --
4月 21 11:20:22 raspberrypi mysql: ..The server quit without updating PID file (/var/run/mysqld/mysqld.pid). ... failed!
4月 21 11:20:22 raspberrypi systemd: mysql.service: control process exited, code=exited status=1
4月 21 11:20:22 raspberrypi systemd: Failed to start LSB: start and stop MySQL. 可能是通过apt或yum安装上mysql-client之类的包了
可以rpm -qa|grep mysql 或 dpkg -l|grep mysql 进行查看 pi@raspberrypi:/usr/local$ sudodpkg -l|grep mysql
iilibmysqlclient18:armhf 5.5.44-0+deb8u1 armhf MySQL database client library
iimysql-common 5.5.44-0+deb8u1 all MySQL database common files, e.g. /etc/mysql/my.cnf
iipython-mysqldb 1.2.3-2.1 armhf Python interface to MySQL 这个会有影响吗。。
回复 5# 的帖子
这些包会影响mysql的运行，可以直接删掉/etc/mysql/my.cnf试试，但可能还会有其他影响，最好是直接卸载掉
页:
[1]