lnmp安装完之后正常数据库重启之后mysql启动错误

raksasa

安装之后没问题重启了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[5165]: Starting MySQL
4月 21 10:40:10 raspberrypi mysql[5165]: ..The server quit without updating PID file (/var/run/mysqld/mysqld....iled!
4月 21 10:40:10 raspberrypi systemd[1]: mysql.service: control process exited, code=exited status=1
4月 21 10:40:10 raspberrypi systemd[1]: Failed to start LSB: start and stop MySQL.
4月 21 10:40:10 raspberrypi systemd[1]: Unit mysql.service entered failed state.
Hint: Some lines were ellipsized, use -l to show in full.

raksasa

160421 10:04:05 mysqld_safe mysqld from pid file /usr/local/mysql/var/raspberrypi.pid ended
160421 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:58  InnoDB: Waiting for the background threads to start
160421 10:04:59 InnoDB: 5.5.42 started; log sequence number 1595675
160421 10:04:59 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
160421 10:04:59 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
160421 10:04:59 [Note] Server socket created on IP: '0.0.0.0'.
160421 10:04:59 [Note] Event Scheduler: Loaded 0 events
160421 10:04:59 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.42-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
160421 10:06:44 [Warning] IP address '192.192.12.44' could not be resolved: Temporary failure in name resolution
160421 10:06:54 [Warning] IP address '192.192.12.44' could not be resolved: Temporary failure in name resolution
160421 10:07:08 [Warning] IP address '192.192.12.44' could not be resolved: Temporary failure in name resolution
160421 10:07:10 [Warning] IP address '192.192.12.44' could not be resolved: Temporary failure in name resolution
160421 10:18:47 [Warning] IP address '192.192.12.44' could not be resolved: Temporary failure in name resolution
160421 10:18:48 [Warning] IP address '192.192.12.44' could not be resolved: Temporary failure in name resolution
160421 10:24:41 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown

160421 10:24:41 [Note] Event Scheduler: Purging the queue. 0 events
160421 10:24:43 [Warning] /usr/local/mysql/bin/mysqld: Forcing close of thread 12  user: 'stockcat'

160421 10:24:43 [Warning] /usr/local/mysql/bin/mysqld: Forcing close of thread 11  user: 'stockcat'

160421 10:24:43 [Warning] /usr/local/mysql/bin/mysqld: Forcing close of thread 8  user: 'stockcat'

160421 10:24:43 [Warning] /usr/local/mysql/bin/mysqld: Forcing close of thread 7  user: 'stockcat'

160421 10:24:45  InnoDB: Starting shutdown...
160421 10:24:51  InnoDB: Shutdown completed; log sequence number 1706477
160421 10:24:51 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

160421 10:24:51 mysqld_safe mysqld from pid file /usr/local/mysql/var/raspberrypi.pid ended

raksasa

-- 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[6571]: ..The server quit without updating PID file (/var/run/mysqld/mysqld.pid). ... failed!
4月 21 11:20:22 raspberrypi systemd[1]: mysql.service: control process exited, code=exited status=1
4月 21 11:20:22 raspberrypi systemd[1]: Failed to start LSB: start and stop MySQL.

licess

可能是通过apt或yum安装上mysql-client之类的包了
可以rpm -qa|grep mysql 或 dpkg -l|grep mysql 进行查看

raksasa

pi@raspberrypi:/usr/local$ sudo  dpkg -l|grep mysql
ii  libmysqlclient18:armhf               5.5.44-0+deb8u1                   armhf        MySQL database client library
ii  mysql-common                         5.5.44-0+deb8u1                   all          MySQL database common files, e.g. /etc/mysql/my.cnf
ii  python-mysqldb                       1.2.3-2.1                         armhf        Python interface to MySQL

raksasa

这个会有影响吗。。

licess

这些包会影响mysql的运行，可以直接删掉/etc/mysql/my.cnf试试，但可能还会有其他影响，最好是直接卸载掉