Apparmor error MySQL failure to start

August 21, 2017 965 views
MySQL Ubuntu 16.04

Hi guys, I have just upgraded from ubuntu14.04 to 16.04. I'm trying to get MySQL running but I keep seeing these errors in the logs

service mysql start
Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
root@loghost:~# service mysql status
● mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
   Active: activating (start-post) (Result: exit-code) since Mon 2017-08-21 12:45:53 EAT; 11s ago
  Process: 1866 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE)
  Process: 1857 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
 Main PID: 1866 (code=exited, status=1/FAILURE);         : 1867 (mysql-systemd-s)
   CGroup: /system.slice/mysql.service
           └─control
             ├─1867 /bin/bash /usr/share/mysql/mysql-systemd-start post
             └─1943 sleep 1

Aug 21 12:45:53 loghost systemd[1]: Starting MySQL Community Server...
Aug 21 12:45:55 loghost systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

tail -f /var/log/syslog | grep apparmor
Aug 21 12:46:24 loghost kernel: [ 7613.698235] audit: type=1400 audit(1503308783.999:507): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/2000/status" pid=2000 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=110 ouid=110
Aug 21 12:46:24 loghost kernel: [ 7613.698285] audit: type=1400 audit(1503308783.999:508): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=2000 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=110 ouid=0
Aug 21 12:46:24 loghost kernel: [ 7613.698381] audit: type=1400 audit(1503308783.999:509): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/2000/status" pid=2000 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=110 ouid=110
Aug 21 12:46:54 loghost kernel: [ 7644.197482] audit: type=1400 audit(1503308814.500:510): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/2111/status" pid=2111 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=110 ouid=110
Aug 21 12:46:54 loghost kernel: [ 7644.197540] audit: type=1400 audit(1503308814.500:511): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=2111 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=110 ouid=0
Aug 21 12:46:54 loghost kernel: [ 7644.197629] audit: type=1400 audit(1503308814.500:512): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/2111/status" pid=2111 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=110 ouid=110

service mysql start
Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
root@loghost:~# tail -f /var/log/mysql/error.log
2017-08-21T09:49:28.833709Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2017-08-21T09:49:28.833737Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2017-08-21T09:49:28.833837Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2017-08-21T09:49:28.833846Z 0 [Note] Shutting down plugin 'MyISAM'
2017-08-21T09:49:28.833882Z 0 [Note] Shutting down plugin 'MEMORY'
2017-08-21T09:49:28.833891Z 0 [Note] Shutting down plugin 'sha256_password'
2017-08-21T09:49:28.833898Z 0 [Note] Shutting down plugin 'mysql_native_password'
2017-08-21T09:49:28.834166Z 0 [Note] Shutting down plugin 'binlog'
2017-08-21T09:49:28.834411Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

Please advise or point me in the right direction

Be the first one to answer this question.