0

I am on ubuntu 16.04 and my mysql connection to local database suddenly stopped working one day, I then tried various things to fix it, but then came to trying to completely remove and reinstall it but when I do it errors out

Systemctl status mysql.service

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 2019-01-07 10:26:11 GMT; 15s ago
  Process: 14346 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE)
  Process: 14339 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
 Main PID: 14346 (code=exited, status=1/FAILURE);         : 14347 (mysql-systemd-s)
   CGroup: /system.slice/mysql.service
           └─control
             ├─14347 /bin/bash /usr/share/mysql/mysql-systemd-start post
             └─14403 sleep 1

Journalctl -xe

Jan 07 10:26:11 np161-Vostro-3268 audit[14346]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/14346/status" pid=14346 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=
Jan 07 10:26:11 np161-Vostro-3268 audit[14346]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=14346 comm="mysqld" requested_mask="r" denied_mask="r"
Jan 07 10:26:11 np161-Vostro-3268 audit[14346]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/14346/status" pid=14346 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=
Jan 07 10:26:11 np161-Vostro-3268 kernel: audit: type=1400 audit(1546856771.110:25227): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/14346/status" pid=14346 comm="mysqld" reque
Jan 07 10:26:11 np161-Vostro-3268 kernel: audit: type=1400 audit(1546856771.110:25228): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=14346 comm="mysqld
Jan 07 10:26:11 np161-Vostro-3268 kernel: audit: type=1400 audit(1546856771.110:25229): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/14346/status" pid=14346 comm="mysqld" reque
Jan 07 10:26:13 np161-Vostro-3268 systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Jan 07 10:26:14 np161-Vostro-3268 sudo[13239]: pam_unix(sudo:session): session closed for user root
Jan 07 10:26:42 np161-Vostro-3268 systemd[1]: Failed to start MySQL Community Server.

migrated from stackoverflow.com Jan 9 at 4:23

This question came from our site for professional and enthusiast programmers.

  • 1
    Just dumping a stack trace with little explanation isn't likely to get any help here. You might want to also tell us what you have tried to remedy the situation. – Tim Biegeleisen Jan 7 at 10:41
  • @TimBiegeleisen I tried to clear up disk space and also tried chown chmod to allow permissions and then tried a full removal and reinstall but it keeps failing when trying to install mysql-server. – user3074140 Jan 7 at 10:43
  • Have you tried to purge everything related to mysql and then reinstall? – Michael O. Jan 7 at 11:14
  • @MichaelO. I followed the list of commands here linuxscriptshub.com/… – user3074140 Jan 7 at 11:17
  • 1
    Stack Overflow is a site for programming and development questions. You should probably use another site on the Stack Exchange network for this question. If you feel the question is on-topic, then see How to create a Minimal, Complete, and Verifiable example. – jww Jan 8 at 1:28

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.