Linux [Ubuntu Server] Mysql does not start at boot

[Gaurish]

Hi,

I have a Ubuntu server running 10.04 LTS. Now the problem is after

every reboot I have to manually start mysql which is causing

lot of downtime:ashamed:

I tried chkconfig mysql on but it does not work

Anyone knows to get mysql to start automatically after reboot?

 

[booo]

[root@booo ~]# chkconfig --level 5 mysqld off

[root@booo ~]# chkconfig --list | grep mysql

mysqld          0:off   1:off   2:off   3:on    4:off   5:off   6:off

[root@booo ~]# chkconfig --level 5 mysqld on

[root@booo ~]# chkconfig --list | grep mysql

mysqld          0:off   1:off   2:off   3:on    4:off   5:on    6:off

[root@booo ~]#

I mean its mysqld not mysql. d for daemon.

 

[Gaurish]

root@dev:~# chkconfig --level 5 mysqld off

mysqld: unknown service

root@dev:~# chkconfig --list | grep mysql

mysql                     0:off  1:off  2:on   3:on   4:on   5:on   6:off

root@dev:~# chkconfig --level 5 mysqld on

mysqld: unknown service

 

[booo]

root@dev:~# chkconfig --list | grep mysql

mysql 0ff 1ff 2n 3n 4n 5n 6ff

^so it means its already on. there should be some problem with your mysql installation. check ~/.my.cnf file to locate the log file and check for errors.

 

[Gaurish]

Adding start mysql into /etc/rc.local file did the trick. Thank for reply

 

[vishalrao]

OT question @Gaurish: Where/what server do you have? I have a VPS @ lahsiv.net also running the same LTS

 

[Gaurish]

OT question @Gaurish: Where/what server do you have? I have a VPS @ lahsiv.net also running the same LTS

I have a 512MB/1GB VPS from thrustvps.com. use it to host my personnel blog. You using amazon ec2?

 

[vishalrao]

Yes I'm using Amazon EC2 free options (micro instance) which are free for a year!

Running backups on to S3 (simple storage service 5gb) and EBS (elastic block storage 10gb) micro instances using the "backup_manager" script.

Got my website/blog etc (lahsiv.net) all running in there, and some friends have accounts there too.

All this controlled from a landscape.canonical.com free cloud command and control center

 

[Gaurish]

Yes I'm using Amazon EC2 free options (micro instance) which are free for a year!

I am thinking of jumping the ship and switching to Amazon's free tier but need to find a VCC to do this

Running backups on to S3 (simple storage service 5gb) and EBS (elastic block storage 10gb) micro instances using the "backup_manager" script.

Currently I am using Dropbox for the same. advantage is, it syncs backups on my personel computer as well. Quite Handy

Got my website/blog etc (lahsiv.net) all running in there, and some friends have accounts there too.

Do you use a control panel like Cpanel or something Currently I am running it all bare which works very well for me but other method are scared of using command line.

All this controlled from a landscape.canonical.com free cloud command and control center

Started using it but I don't find it useful for 1instance. maybe it does help when you have 100instances to maintain but single instance ssh works pretty well.

PS: Which firewall you use?

 

[vishalrao]

A few control panels here n there but mostly SSH based admin I do too

Firewall? Whats that? I have just disabled all/most services/ports, my system is WIDE OPEN for all you dirty hackers hehe (a.k.a. its a honeypot too) ! mwwwahahahahahaha!

--- Updated Post - Automerged ---

Note that I only pay for my VPS, all amazon services are free for one year.

 

[Gaurish]

A few control panels here n there but mostly SSH based admin I do too

Firewall? Whats that? I have just disabled all/most services/ports, my system is WIDE OPEN for all you dirty hackers hehe (a.k.a. its a honeypot too) ! mwwwahahahahahaha!

What control panels?

Note that I only pay for my VPS, all amazon services are free for one year.

Doesn't 750 hours of Amazon EC2 Linux Micro Instance comes bundled, then pay?

 

[vishalrao]

Sorry, my control panel information is top-secret, classified information for reasons of [strike]national[/strike], er, personal security. Meaning if I told you I would have to "kill -9" you

Yes, according to Amazon itself, if you run the micro instance 24x7 you still don't consume the free duration for one year! Do the math

So I have created a micro instance and booted it up and left it running... so effectively I have TWO VPSes