chkconfig not automatically starting mysql

Question

I have mysql set in chkconfig to automatically start when the system reboots:

root@myserver:~#chkconfig mysql
mysql  on

However, this does not seem to be the case. When the system reboots, I get the following error on my PHP pages:

SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

If I run service mysql start, the PHP pages begin to work (the above error does not appear, and queries return values). Is this an inappropriate configuration on my part? What else do I need to do to get mysql to start correctly after a reboot?

Note: I'm running mysql on a SLES VM.

Is it able to start at all? Are you getting errors in the mysql logs? — Kyle, Aug 12 '13 at 22:10
It starts fine if I run `service mysql start`, but not at boot. My `/var/log/mysqld.log` file only shows from the point I ran `service mysql start`. — EGr, Aug 12 '13 at 22:30
`ps aux |grep mysql`. It there another MySQL daemon running already? — Stefan Lasiewski, Aug 13 '13 at 05:40

score 4 · Answer 1 · answered Aug 13 '13 at 05:25

4

Perhaps something went wonky when the init script was installed. I'd recommend the following:

chkconfig --del mysql
chkconfig --add mysql
chkconfig mysql on

Certainly can't hurt.

answered Aug 13 '13 at 05:25

anastrophe

5,488
2
16
16

chkconfig mysqld ... – Wojciech Domalewski May 17 '16 at 12:57
Not necessarily, it depends upon the distribution. – anastrophe May 19 '16 at 15:25

score 0 · Answer 2 · answered Aug 12 '13 at 20:56

0

Are you starting up MySQL at the correct init level ? the network services should be up before mySQL can be started . S

answered Aug 12 '13 at 20:56

user2676172

1
1

Are you talking about runlevels? If so, both `network` and `mysql` are set to 2,3, and 5 – EGr Aug 12 '13 at 21:45

score 0 · Answer 3 · answered Aug 19 '13 at 09:19

0

mysql is the client. If you have installed mysql server before, you can start it with

service mysqld start

Please check:

chkconfig mysqld

answered Aug 19 '13 at 09:19

syamimi

1

chkconfig not automatically starting mysql

3 Answers3