Unable to start MySQL by using Upstart on Lucid

[Nero Ferocious]

I don’t know why MySql is not running after booting of Lucid. However can manually start by using below mentioned command

sudo -u mysql mysqld

however when I am trying to use Upstart I got below mentioned error message.

dom@mythbox:~$ start mysql
start: Rejected send message, 1 matched rules; type="method_call", sender=":1.51" (uid=1000 pid=3891 comm="start) interface="com.ubuntu.Upstart0_6.Job" member="Start" error name="(unset)" requested_reply=0 destination="com.ubuntu.Upstart" (uid=0 pid=1 comm="/sbin/init"))

Let me know if you are having any idea to resolve the matter will be appreciated. Thanks a lot in advance.

[Agavoli]

I think you need to start MySQL by using below mentioned commands.

sudo service mysql restart

or

sudo service mysql start

[Jessalyn]

after going through mysqld upstart job at /etc/init/mysqld.conf and you will be see ‘start on (net-device-up’. Mysql is configure to bind with a specific address and it fails to begin if network interface does not seems to be up. I recommend that you should update mysqld upstart job to ‘start on (net-device-up IFACE=ethX’ to start mysqld only when correct interface is up.

[DakshaMira]

You should browse to /etc/init/mysql.conf.
Here you have to edit

# MySQL Service

description     "MySQL Server"
author          "Mario Limonciello <superm1@ubuntu.com>"

start on (net-device-up
          and local-filesystems
	  and runlevel [2345])
stop on runlevel [016]

respawn

make sure that there should be space after the term ‘runlevel’.