By missakiiki
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!
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
Full documentation for every DigitalOcean product.
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
Stay up to date by signing up for DigitalOcean’s Infrastructure as a Newsletter.
New accounts only. By submitting your email you agree to our Privacy Policy
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.