MySQL重启后出现无法找到PID错误

silentstage

救命啊！！我是linux小白，用一键包搭了个小博客，一直运行很好今天修改了下nginx的配置，用lnmp restart了下，结果mysql就启动不起来了！！
我发誓一点mysql的东西都没有动过环境是debian8.8，lnmp1.4，mysql是默认选项，应该是5.5版本

这是启动时的错误：

Oct 16 16:15:06 debian-8-8 mysql[24954]: ...The server quit without updating PID file (/var/run/mysqld/mysqld.pid). ... failed!
Oct 16 16:15:06 debian-8-8 systemd[1]: mysql.service: control process exited, code=exited status=1
Oct 16 16:15:06 debian-8-8 systemd[1]: Failed to start LSB: start and stop MySQL.
Oct 16 16:15:06 debian-8-8 systemd[1]: Unit mysql.service entered failed state.


之前启动还有一个Log文件错误和mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.
我手动按错误提示建了目录和空文件，没有了

这是/usr/local/mysql/var/debian-8-8.err最后的日志，完全没有错误提示
171015  0:07:19 [Warning] IP address '123.249.12.230' could not be resolved: Temporary failure in name resolution
171015  3:26:56 [Warning] IP address '125.77.21.113' could not be resolved: Name or service not known
171015  4:45:44 [Warning] IP address '123.249.79.179' could not be resolved: Name or service not known
171015  5:53:14 [Warning] IP address '118.89.107.132' could not be resolved: Name or service not known
171015 19:02:43 [Warning] IP address '142.252.248.191' could not be resolved: Name or service not known
171015 22:28:48 [Warning] IP address '183.61.166.115' could not be resolved: Name or service not known
171016 14:14:29 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown

171016 14:14:29 [Note] Event Scheduler: Purging the queue. 0 events
171016 14:14:29  InnoDB: Starting shutdown...
171016 14:14:30  InnoDB: Shutdown completed; log sequence number 7370778775
171016 14:14:30 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete


之前这个问题在我另外个网盘机器也出过一次，不过数据不重要最后重装解决了。
现在是一头雾水！！
不知道解决错误的方向
google都翻烂了，都没解决
非常着急，在线等，请各位大大提点意见，万分感谢！！！如果数据库恢复不了，有没有办法备份出来？？
我查了下上次snapshot是7月份~~~~>_<~~~~~

[ 本帖最后由 silentstage 于 2017-10-16 16:31 编辑 ]

silentstage

这是my.cnf的配置
[client]
#password       = your_password
port            = 3306
socket          = /tmp/mysql.sock


[mysqld]
port            = 3306
socket          = /tmp/mysql.sock

datadir = /usr/local/mysql/var

skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
thread_cache_size = 8
query_cache_size = 8M
tmp_table_size = 16M

#skip-networking
max_connections = 500
max_connect_errors = 100
open_files_limit = 65535

log-bin=mysql-bin
binlog_format=mixed
server-id       = 1
expire_logs_days = 10

default_storage_engine = InnoDB
innodb_file_per_table = 1
innodb_data_home_dir = /usr/local/mysql/var
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /usr/local/mysql/var
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

licess

按1楼错误信息看可能有其他mysql包，参考：https://bbs.vpser.net/thread-15119-1-1.html

silentstage

dpkg -l|grep mysql

ii  libdbd-mysql-perl                 4.028-2+deb8u2                     amd64        Perl5 database interface to the MySQL database
ii  libmysqlclient18:amd64            5.5.57-0+deb8u1                    amd64        MySQL database client library
ii  mysql-common                      5.5.57-0+deb8u1                    all          MySQL database common files, e.g. /etc/mysql/my.cnf


这样该怎么解决呢？

zengyuhua

我跟你一样的问题我跟你一样的问题

licess

卸载就可以了