Report this

What is the reason for this report?

Apparmor error MySQL failure to start

Posted on August 21, 2017

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



This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

I am experiencing the same expect issue.

The developer cloud

Scale up as you grow — whether you're running one virtual machine or ten thousand.

Get started for free

Sign up and get $200 in credit for your first 60 days with DigitalOcean.*

*This promotional offer applies to new accounts only.