Home / ubuntu / Questions / 130918
Accepted
b. e. hollenbeck
Asked: 2012-05-04 09:58:57 +0800 CST

Mysqld not starting on boot?

  • 772

After upgrading to Pangolin, mysqld is not starting on boot. I've looked into various other MySQL issues with the Pangolin release, and I haven't seen the same issue that other people are having (mysqld bouncing, etc). Once I run it from the command line, it runs just fine.

Where do I add the command to start the service on boot?

boot mysql 12.04

4 Answers

  1. Best Answer

    While I was looking for a solution to the same symptom, I found out there are a lot of things that can go wrong and prevent mysql(d) from starting. If you can manage to start it from the command line with the proper user:

    sudo -u mysql mysqld

    And that conversely it fails as a service:

    root@my-linode:~# service mysql start
start: Job failed to start

    Then check the upstart log in /var/log/upstart/mysql.log. If you find the following error message:

    [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

    Then you've found the culprit. To fix it, specify the mysql user in /etc/mysql/my.cnf

    user=mysql

    Restart with start mysql and you should be good.

    Again, there are many possible cause to this error (apparmor, incorrect privileges on the socket file, insufficient disk space, insufficient memory during the upgrade to mention a few I stumbled upon). This is only one of them. Thanks to this guy.

    • 3

  2. sudo service mysql start should start mysql. It is an upstart job, so the full job can be seen at /etc/init/mysql.conf

    You probably need to check /var/log/mysql*, as there may be issues with the upgrade table process that are causing problems.

    • 1

  3. This solved it for me during the 11.xx 12.04 upgrade:

    sudo touch /etc/apparmor.d/local/usr.sbin.mysq

    I could start it in safe mode but not in regular mode. Hope this helps.

    • 1

  4. Well here is the problem, maybe your's is a domain problem. Mysql would have been installed in the other user profile and just could not start due to profile issues. Well here is one thing I found for you.
    http://www.thegeekstuff.com/2009/07/ubuntu-open-applications-automatically-during-system-startup/

    and a question similar to you is having the problem. So I found the following answer for you. https://stackoverflow.com/questions/2198752/adding-a-start-up-via-command-line-ubuntu

    Just give it a try.

    • 0