Mysql no longer working and cannot reinstall
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.
mysql linux
edited 2 hours ago
Rick James
41.1k22258
migrated from stackoverflow.com 2 hours ago
This question came from our site for professional and enthusiast programmers.
|
show 1 more comment
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.
mysql linux
edited 2 hours ago
Rick James
41.1k22258
migrated from stackoverflow.com 2 hours ago
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
yesterday
@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
yesterday
Have you tried topurgeeverything related tomysqland then reinstall?
– Michael O.
yesterday
@MichaelO. I followed the list of commands here linuxscriptshub.com/…
– user3074140
yesterday
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
yesterday
|
show 1 more comment
0
0
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.
mysql linux
edited 2 hours ago
Rick James
41.1k22258
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.
mysql linux
mysql linux
edited 2 hours ago
Rick James
41.1k22258
edited 2 hours ago
Rick James
41.1k22258
edited 2 hours ago
Rick James
41.1k22258
edited 2 hours ago
Rick James
41.1k22258
edited 2 hours ago
Rick James
41.1k22258
41.1k22258
asked yesterday
user3074140
migrated from stackoverflow.com 2 hours ago
This question came from our site for professional and enthusiast programmers.
migrated from stackoverflow.com 2 hours ago
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
yesterday
@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
yesterday
Have you tried topurgeeverything related tomysqland then reinstall?
– Michael O.
yesterday
@MichaelO. I followed the list of commands here linuxscriptshub.com/…
– user3074140
yesterday
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
yesterday
|
show 1 more comment
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
yesterday
@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
yesterday
Have you tried topurgeeverything related tomysqland then reinstall?
– Michael O.
yesterday
@MichaelO. I followed the list of commands here linuxscriptshub.com/…
– user3074140
yesterday
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
yesterday
1
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
yesterday
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
yesterday
@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
yesterday
@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
yesterday
Have you tried to
purge everything related to mysql and then reinstall?– Michael O.
yesterday
Have you tried to
purge everything related to mysql and then reinstall?– Michael O.
yesterday
@MichaelO. I followed the list of commands here linuxscriptshub.com/…
– user3074140
yesterday
@MichaelO. I followed the list of commands here linuxscriptshub.com/…
– user3074140
yesterday
1
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
yesterday
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
yesterday
|
show 1 more comment
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f226650%2fmysql-no-longer-working-and-cannot-reinstall%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f226650%2fmysql-no-longer-working-and-cannot-reinstall%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
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
yesterday
@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
yesterday
Have you tried to
purgeeverything related tomysqland then reinstall?– Michael O.
yesterday
@MichaelO. I followed the list of commands here linuxscriptshub.com/…
– user3074140
yesterday
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
yesterday