mysql 暂停job,无法启动mysql – mysql respawning太快,停了

今天我重新安装了ubuntu 12.04并开始设置我的本地开发环境.我安装了mysql并编辑了/etc/mysql/my.cnf以优化InnoDB,但是当我尝试重新启动mysql时,它失败并出现错误：

[20:53][tom@Pochama:/var/www/website] (master) $sudo service mysql restart

start: Job failed to start

syslog显示init脚本存在问题：

> tail -f /var/log/syslog

Apr 28 21:17:46 Pochama kernel: [11840.884524] type=1400 audit(1335644266.033:184): apparmor="STATUS" operation="profile_replace" name="/usr/sbin/mysqld" pid=760 comm="apparmor_parser"

Apr 28 21:17:47 Pochama kernel: [11842.603773] init: mysql main process (764) terminated with status 7

Apr 28 21:17:47 Pochama kernel: [11842.603841] init: mysql main process ended, respawning

Apr 28 21:17:48 Pochama kernel: [11842.932462] init: mysql post-start process (765) terminated with status 1

Apr 28 21:17:48 Pochama kernel: [11842.950393] type=1400 audit(1335644268.101:185): apparmor="STATUS" operation="profile_replace" name="/usr/sbin/mysqld" pid=811 comm="apparmor_parser"

Apr 28 21:17:49 Pochama kernel: [11844.656598] init: mysql main process (815) terminated with status 7

Apr 28 21:17:49 Pochama kernel: [11844.656665] init: mysql main process ended, respawning

Apr 28 21:17:50 Pochama kernel: [11845.004435] init: mysql post-start process (816) terminated with status 1

Apr 28 21:17:50 Pochama kernel: [11845.021777] type=1400 audit(1335644270.173:186): apparmor="STATUS" operation="profile_replace" name="/usr/sbin/mysqld" pid=865 comm="apparmor_parser"

Apr 28 21:17:51 Pochama kernel: [11846.721982] init: mysql main process (871) terminated with status 7

Apr 28 21:17:51 Pochama kernel: [11846.722001] init: mysql respawning too fast, stopped

有任何想法吗？

我尝试过的事情：

sudo apt-get install apparmor-utils

sudo aa-complain /usr/sbin/mysqld

sudo /etc/init.d/apparmor reload

但它没有帮助.我还是无法启动mysql.

我还认为问题可能是因为InnoDB日志文件的大小与mysql所期望的大小不同.我在重新启动之前删除了innodb日志文件：sudo mv / var / lib / mysql / ib_logfile * / tmp.虽然没有运气.

解决方法：我重新安装了12.04,确保不要以任何方式触及/etc/mysql/my.cnf. Mysql正在工作,所以我可以继续我需要做的事情.但是我需要在某个时候编辑它 – 希望我已经找到了解决方案,或者这个问题已经得到了回答……

解决方法:

我终于找到了问题.基本上,某些参数的定义已从先前版本的mysql中删除,并已被替换为不同的名称.要修复,请在/etc/mysql/my.cnf中替换：

# Tom Added to ensure the server character set is set to utf8

default-character-set = utf8

default-collation = utf8_general_ci

有：

# Tom Added to ensure the server character set is set to utf8

character_set_server = utf8

collation_server = utf8_general_ci

或轻松运行：

# Miraz added dpkg-reconfigure

dpkg-reconfigure mysql-server-5.5

但请确保没有安装旧的mysql版本安装,如果有,请删除：

# Miraz quick mysql package check

dpkg -l *mysql*

标签：init-d,mysql,apparmor

来源： https://codeday.me/bug/20190807/1610365.html