Unable to start MySQL by using Upstart on Lucid

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

Code:

---

sudo -u mysql mysqld

---

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

Quote:

---

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.

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

Code:

---

sudo service mysql restart

---

or

Code:

---

sudo service mysql start

---

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.

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

Code:

---

# MySQL Service

---

Code:

---

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’.