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

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.

×
1 answer

I am experiencing the same expect issue.

Submit an Answer