I did a apt-get update & installed few updates on my server which runs 10.04LTS. But this has broken mysql. it doesn't start at boot. I tried to manually start it using the following commands:
$ sudo /etc/init.d/mysql restart
Rather than invoking init scripts through /etc/init.d, use the service(8)
utility, e.g. service mysql restart
Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the restart(8) utility, e.g. restart mysql
start: Job failed to start
$ sudo service mysql start
start: Job failed to start
$ service mysql start
start: Rejected send message, 1 matched rules; type="method_call", sender=":1.5" (uid=1001 pid=1796 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="init"))
$ restart mysql
restart: Rejected send message, 1 matched rules; type="method_call", sender=":1.10" (uid=1001 pid=2014 comm="restart) interface="com.ubuntu.Upstart0_6.Job" member="Restart" error name="(unset)" requested_reply=0 destination="com.ubuntu.Upstart" (uid=0 pid=1 comm="init"))
here is my /etc/init/mysql.conf file for service, mysql error log & /etc/mysql/my.cnf. Currently, I have run sudo mysqld &
only then, my server starts accepting connections but it causes problem as It has to be done after every reboot.
Please let me know how to I fix this.