Ubuntu 18.04 MySQL can't start

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP








up vote
0
down vote

favorite
1












I just fresh installed Ubuntu 18.04 and tried to get the LAMP stack. During install, no pop-up screen for MySQL server configuration, during installation of the OS. I tried to login using root w/out password (default is no password), permission denied. Run mysql_secure_installation, set a password for root user, then I tried to login using the password I set, it still says permission denied even I typed the correct password. I tried to start the service manually, it turns out to time out. Purged mysql-server and change to mariadb-server, same thing. Is it a bug in MySQL server in 18.04? I have used MySQL in 17.10, no issues.



Excerpt of journalctl -xe:



-- Unit mariadb.service has begun starting up.
May 13 05:55:09 v1 mysqld[4863]: 2018-05-13 5:55:09 140117780589696 [Note] /usr/sbin/mysqld (mysqld 10.1.29-MariaDB-6) starting as process 4863 ...
May 13 05:55:09 v1 audit[4863]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=48
May 13 05:55:09 v1 kernel: audit: type=1400 audit(1526190909.418:36): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld
May 13 05:56:39 v1 systemd[1]: mariadb.service: Start operation timed out. Terminating.
May 13 05:56:39 v1 audit[4863]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=48
May 13 05:56:39 v1 kernel: audit: type=1400 audit(1526190999.051:37): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld
May 13 05:56:41 v1 audit[4863]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=48
May 13 05:56:41 v1 kernel: audit: type=1400 audit(1526191001.179:38): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld
May 13 05:56:41 v1 audit[4863]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=48
May 13 05:56:41 v1 kernel: audit: type=1400 audit(1526191001.179:39): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld
May 13 05:56:41 v1 systemd[1]: mariadb.service: Failed with result 'timeout'.
May 13 05:56:41 v1 systemd[1]: Failed to start MariaDB database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Unit mariadb.service has failed.


Expected output during LAMP stack installation in Ubuntu server




server mysql




share|improve this question


















  • 1




    Possible duplicate of MySQL won't start because of AppArmor?
    – s1mmel
    May 13 at 6:12










  • No, it already happened in the fresh install of Ubuntu server
    – ckykenken
    May 13 at 6:16










  • it is apparmor giving you the trouble. Instead of searching for differences in your and the other posts. You should focus on apparmor and the answer given in that post, as missing entries in the apparmor profile CLEARLY is the culprit here as seen in your output. audit: apparmor="DENIED" name="run/systemd/notify" Looks like the status (start(stop/restart) of the database cannot be send to run/systemd/notify. Please look in /var/log/mysql for more information and add them to your question
    – s1mmel
    May 13 at 6:28











  • see here askubuntu.com/questions/750604/…
    – s1mmel
    May 13 at 6:32














up vote
0
down vote

favorite
1












I just fresh installed Ubuntu 18.04 and tried to get the LAMP stack. During install, no pop-up screen for MySQL server configuration, during installation of the OS. I tried to login using root w/out password (default is no password), permission denied. Run mysql_secure_installation, set a password for root user, then I tried to login using the password I set, it still says permission denied even I typed the correct password. I tried to start the service manually, it turns out to time out. Purged mysql-server and change to mariadb-server, same thing. Is it a bug in MySQL server in 18.04? I have used MySQL in 17.10, no issues.



Excerpt of journalctl -xe:



-- Unit mariadb.service has begun starting up.
May 13 05:55:09 v1 mysqld[4863]: 2018-05-13 5:55:09 140117780589696 [Note] /usr/sbin/mysqld (mysqld 10.1.29-MariaDB-6) starting as process 4863 ...
May 13 05:55:09 v1 audit[4863]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=48
May 13 05:55:09 v1 kernel: audit: type=1400 audit(1526190909.418:36): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld
May 13 05:56:39 v1 systemd[1]: mariadb.service: Start operation timed out. Terminating.
May 13 05:56:39 v1 audit[4863]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=48
May 13 05:56:39 v1 kernel: audit: type=1400 audit(1526190999.051:37): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld
May 13 05:56:41 v1 audit[4863]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=48
May 13 05:56:41 v1 kernel: audit: type=1400 audit(1526191001.179:38): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld
May 13 05:56:41 v1 audit[4863]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=48
May 13 05:56:41 v1 kernel: audit: type=1400 audit(1526191001.179:39): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld
May 13 05:56:41 v1 systemd[1]: mariadb.service: Failed with result 'timeout'.
May 13 05:56:41 v1 systemd[1]: Failed to start MariaDB database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Unit mariadb.service has failed.


Expected output during LAMP stack installation in Ubuntu server




server mysql




share|improve this question


















  • 1




    Possible duplicate of MySQL won't start because of AppArmor?
    – s1mmel
    May 13 at 6:12










  • No, it already happened in the fresh install of Ubuntu server
    – ckykenken
    May 13 at 6:16










  • it is apparmor giving you the trouble. Instead of searching for differences in your and the other posts. You should focus on apparmor and the answer given in that post, as missing entries in the apparmor profile CLEARLY is the culprit here as seen in your output. audit: apparmor="DENIED" name="run/systemd/notify" Looks like the status (start(stop/restart) of the database cannot be send to run/systemd/notify. Please look in /var/log/mysql for more information and add them to your question
    – s1mmel
    May 13 at 6:28











  • see here askubuntu.com/questions/750604/…
    – s1mmel
    May 13 at 6:32












up vote
0
down vote

favorite
1









up vote
0
down vote

favorite
1






1





I just fresh installed Ubuntu 18.04 and tried to get the LAMP stack. During install, no pop-up screen for MySQL server configuration, during installation of the OS. I tried to login using root w/out password (default is no password), permission denied. Run mysql_secure_installation, set a password for root user, then I tried to login using the password I set, it still says permission denied even I typed the correct password. I tried to start the service manually, it turns out to time out. Purged mysql-server and change to mariadb-server, same thing. Is it a bug in MySQL server in 18.04? I have used MySQL in 17.10, no issues.



Excerpt of journalctl -xe:



-- Unit mariadb.service has begun starting up.
May 13 05:55:09 v1 mysqld[4863]: 2018-05-13 5:55:09 140117780589696 [Note] /usr/sbin/mysqld (mysqld 10.1.29-MariaDB-6) starting as process 4863 ...
May 13 05:55:09 v1 audit[4863]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=48
May 13 05:55:09 v1 kernel: audit: type=1400 audit(1526190909.418:36): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld
May 13 05:56:39 v1 systemd[1]: mariadb.service: Start operation timed out. Terminating.
May 13 05:56:39 v1 audit[4863]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=48
May 13 05:56:39 v1 kernel: audit: type=1400 audit(1526190999.051:37): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld
May 13 05:56:41 v1 audit[4863]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=48
May 13 05:56:41 v1 kernel: audit: type=1400 audit(1526191001.179:38): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld
May 13 05:56:41 v1 audit[4863]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=48
May 13 05:56:41 v1 kernel: audit: type=1400 audit(1526191001.179:39): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld
May 13 05:56:41 v1 systemd[1]: mariadb.service: Failed with result 'timeout'.
May 13 05:56:41 v1 systemd[1]: Failed to start MariaDB database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Unit mariadb.service has failed.


Expected output during LAMP stack installation in Ubuntu server




server mysql




share|improve this question














I just fresh installed Ubuntu 18.04 and tried to get the LAMP stack. During install, no pop-up screen for MySQL server configuration, during installation of the OS. I tried to login using root w/out password (default is no password), permission denied. Run mysql_secure_installation, set a password for root user, then I tried to login using the password I set, it still says permission denied even I typed the correct password. I tried to start the service manually, it turns out to time out. Purged mysql-server and change to mariadb-server, same thing. Is it a bug in MySQL server in 18.04? I have used MySQL in 17.10, no issues.



Excerpt of journalctl -xe:



-- Unit mariadb.service has begun starting up.
May 13 05:55:09 v1 mysqld[4863]: 2018-05-13 5:55:09 140117780589696 [Note] /usr/sbin/mysqld (mysqld 10.1.29-MariaDB-6) starting as process 4863 ...
May 13 05:55:09 v1 audit[4863]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=48
May 13 05:55:09 v1 kernel: audit: type=1400 audit(1526190909.418:36): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld
May 13 05:56:39 v1 systemd[1]: mariadb.service: Start operation timed out. Terminating.
May 13 05:56:39 v1 audit[4863]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=48
May 13 05:56:39 v1 kernel: audit: type=1400 audit(1526190999.051:37): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld
May 13 05:56:41 v1 audit[4863]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=48
May 13 05:56:41 v1 kernel: audit: type=1400 audit(1526191001.179:38): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld
May 13 05:56:41 v1 audit[4863]: AVC apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld" name="run/systemd/notify" pid=48
May 13 05:56:41 v1 kernel: audit: type=1400 audit(1526191001.179:39): apparmor="DENIED" operation="sendmsg" info="Failed name lookup - disconnected path" error=-13 profile="/usr/sbin/mysqld
May 13 05:56:41 v1 systemd[1]: mariadb.service: Failed with result 'timeout'.
May 13 05:56:41 v1 systemd[1]: Failed to start MariaDB database server.
-- Subject: Unit mariadb.service has failed
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Unit mariadb.service has failed.


Expected output during LAMP stack installation in Ubuntu server





server mysql





share|improve this question













share|improve this question




share|improve this question








edited May 13 at 6:15

























asked May 13 at 6:07









ckykenken

12




12







  • 1




    Possible duplicate of MySQL won't start because of AppArmor?
    – s1mmel
    May 13 at 6:12










  • No, it already happened in the fresh install of Ubuntu server
    – ckykenken
    May 13 at 6:16










  • it is apparmor giving you the trouble. Instead of searching for differences in your and the other posts. You should focus on apparmor and the answer given in that post, as missing entries in the apparmor profile CLEARLY is the culprit here as seen in your output. audit: apparmor="DENIED" name="run/systemd/notify" Looks like the status (start(stop/restart) of the database cannot be send to run/systemd/notify. Please look in /var/log/mysql for more information and add them to your question
    – s1mmel
    May 13 at 6:28











  • see here askubuntu.com/questions/750604/…
    – s1mmel
    May 13 at 6:32












  • 1




    Possible duplicate of MySQL won't start because of AppArmor?
    – s1mmel
    May 13 at 6:12










  • No, it already happened in the fresh install of Ubuntu server
    – ckykenken
    May 13 at 6:16










  • it is apparmor giving you the trouble. Instead of searching for differences in your and the other posts. You should focus on apparmor and the answer given in that post, as missing entries in the apparmor profile CLEARLY is the culprit here as seen in your output. audit: apparmor="DENIED" name="run/systemd/notify" Looks like the status (start(stop/restart) of the database cannot be send to run/systemd/notify. Please look in /var/log/mysql for more information and add them to your question
    – s1mmel
    May 13 at 6:28











  • see here askubuntu.com/questions/750604/…
    – s1mmel
    May 13 at 6:32







1




1




Possible duplicate of MySQL won't start because of AppArmor?
– s1mmel
May 13 at 6:12




Possible duplicate of MySQL won't start because of AppArmor?
– s1mmel
May 13 at 6:12












No, it already happened in the fresh install of Ubuntu server
– ckykenken
May 13 at 6:16




No, it already happened in the fresh install of Ubuntu server
– ckykenken
May 13 at 6:16












it is apparmor giving you the trouble. Instead of searching for differences in your and the other posts. You should focus on apparmor and the answer given in that post, as missing entries in the apparmor profile CLEARLY is the culprit here as seen in your output. audit: apparmor="DENIED" name="run/systemd/notify" Looks like the status (start(stop/restart) of the database cannot be send to run/systemd/notify. Please look in /var/log/mysql for more information and add them to your question
– s1mmel
May 13 at 6:28





it is apparmor giving you the trouble. Instead of searching for differences in your and the other posts. You should focus on apparmor and the answer given in that post, as missing entries in the apparmor profile CLEARLY is the culprit here as seen in your output. audit: apparmor="DENIED" name="run/systemd/notify" Looks like the status (start(stop/restart) of the database cannot be send to run/systemd/notify. Please look in /var/log/mysql for more information and add them to your question
– s1mmel
May 13 at 6:28













see here askubuntu.com/questions/750604/…
– s1mmel
May 13 at 6:32




see here askubuntu.com/questions/750604/…
– s1mmel
May 13 at 6:32















active

oldest

votes











Your Answer







StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "89"
;
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',
convertImagesToLinks: true,
noModals: false,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);








 

draft saved


draft discarded


















StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f1035591%2fubuntu-18-04-mysql-cant-start%23new-answer', 'question_page');

);

Post as a guest






















active

oldest

votes













active

oldest

votes









active

oldest

votes






active

oldest

votes










 

draft saved


draft discarded


























 


draft saved


draft discarded














StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f1035591%2fubuntu-18-04-mysql-cant-start%23new-answer', 'question_page');

);

Post as a guest
































































-

Popular posts from this blog

pylint3 and pip3 broken

Image
Clash Royale CLAN TAG #URR8PPP up vote 0 down vote favorite I have tried sudo apt remove --purge on various packages. I get the same when I reinstall. I have also tried reinstall using aptitude. This does not work. My current workaround is to run pylint3 as root, which works, but is bad practice. pip3 $ pip3 Traceback (most recent call last): File "/usr/lib/python3/dist-packages/pip/_vendor/__init__.py", line 33, in vendored __import__(vendored_name, globals(), locals(), level=0) ImportError: No module named 'pip._vendor.pkg_resources' During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/usr/bin/pip3", line 9, in <module> from pip import main File "/usr/lib/python3/dist-packages/pip/__init__.py", line 13, in <module> from pip.exceptions import InstallationError, CommandError, PipError File "/usr/lib/python3/dist-packages/pip/exceptions.py", line 6, ...
Read more

Missing snmpget and snmpwalk

Image
Clash Royale CLAN TAG #URR8PPP up vote 0 down vote favorite I have installed Zabbix appliance, directly preinstalled and found that there is missing snmpwalk and snmpget commands. I tried to install it with: apt-get install net-snmp-utils but I have error message: Unable to locate package. I have also check what from SNMP is preinstalled and there is: libsnmp-base libsnmp30:amd64 snmp-mibs-downloader snmpd snmptrapd snmptrapfmt How can I install snmpget and snmpwalk ? snmp zabbix share | improve this question edited Jan 29 at 10:10 Yaron 8,552 7 18 38 asked Jan 29 at 9:51 Alfista 1 apt install snmp perhaps ? If named differently - apt cache snmp – fugitive Jan 29 at 10:00 add a comment  |  up vote 0 down vote favorite I have installed Zabbix appliance, directly preinstalled and found that there is missing snmpwalk and snmpget commands. I tried...
Read more

How to enroll fingerprints to Ubuntu 17.10 with VFS491

Image
Clash Royale CLAN TAG #URR8PPP up vote 1 down vote favorite I decided to switch from Windows to Ubuntu 17.10, I meet it like 8 years ago and I didn't decided to switch until now (haha). Well, my actual device is an HP Probook 4540s with a Validity fingerprint sensor (VFS491). The fingerprint sensor worked fine on Windows but I can't get it to work in Ubuntu. The device is recognized as 138a:003d but is not detected as a fingerprint scanner by some apps like Fingerprint GUI. I want to use the fingerprint scanner to log in into my user account in Ubuntu but it doesn't supports fingerprints without special software and the drivers of the fingerprint scanner are available for Windows but not for any Linux distribution. I found something on GitHub (https://github.com/eekpie/libfprint) about the integration of the VFS491 in libfprint and I think it can help but I don't know what to do with it, so that's why I need the help of the community to do it since I am...
Read more