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.
Re: Unable to start MySQL by using Upstart on Lucid
I think you need to start MySQL by using below mentioned commands.
Code:
sudo service mysql restart
or
Code:
sudo service mysql start
Re: Unable to start MySQL by using Upstart on Lucid
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.
Re: Unable to start MySQL by using Upstart on Lucid
You should browse to /etc/init/mysql.conf.
Here you have to edit
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’.