[Ubuntu Server] Mysql does not start at boot

Software, Cloud and Development Software & Tools
1

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?

2 
#

I mean its mysqld not mysql. d for daemon.

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

mysqld: unknown service

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

mysql                     0 šŸ˜® ff  1 šŸ˜® ff  2 šŸ˜® n   3 šŸ˜® n   4 šŸ˜® n   5 šŸ˜® n   6 šŸ˜® ff

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

mysqld: unknown service
4

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

5

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

6

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

7

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

8

Yes Iā€™m using Amazon EC2 free options (micro instance) which are free for a year! :grinning_face_with_smiling_eyes:

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 :face_with_tongue:

9

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

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

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.

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?

10

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

Firewall? Whats that? :face_with_tongue: 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.

11

What control panels?

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

12

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 :face_with_tongue:

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 :grinning_face_with_smiling_eyes:

So I have created a micro instance and booted it up and left it runningā€¦ so effectively I have TWO VPSes :grinning_face_with_smiling_eyes: