MySQL错误处理，启动失败：Starting MySQL../usr/local/mysql-5.6.51/bin/mysqld_safe: line 183: 117628 Killed

MySQL错误处理，启动失败：Starting MySQL…/usr/local/mysql-5.6.51/bin/mysqld_safe: line 183: 117628 Killed

本文主要解决的问题

重启MySQL,启动service mysql start

然后报错：Starting MySQL../usr/local/mysql-5.6.51/bin/mysqld_safe: line 183: 117628 Killed al/mysql-5.6.51/data --plugin-dir=/usr/local/mysql-5.6.51/lib/plugin --user=mysql --log-e .The server quit without updating PID file (/usr/local/mysq[FAILED]/data/shawn.pid).

反正无论怎么启动MySQL都报这个错误。

解决问题

👙编辑配置文件
[root@shawn /usr/local] # vim /etc/my.cnf

👙加入配置
key_buffer=16K
table_open_cache=4
query_cache_limit=256K
query_cache_size=4M
max_allowed_packet=1M
sort_buffer_size=64K
read_buffer_size=256K
thread_stack=64K
innodb_buffer_pool_size = 56M

然后保存，重新启动MySQL

service mysql start

再查看MySQL状态：service mysql status

参考资料

• 博客园：https://www.cnblogs.com/yehuisir/p/10345020.html