[SOLVED] MySQL Daemon failed to start

jastanle84 · 10-09-2011, 07:09 PM

The mysql.sock file that is supposed to be located at socket=/var/lib/mysql/mysql.sock on the my.cnf file, is not there. I ran the command:

Code:

mysqld_safe --user=mysql &

to restore the file and then I ran:

Code:

service mysqld start

The service starts and the file is created correctly but it does not persist after reboot. The file disappears after reboot. What do I need to do to keep the mysql.sock file in the /var/lib/mysql.sock directory after reboot? Any help is appreciated.

corp769 · 10-09-2011, 07:21 PM

Hello,

What distribution are you running? When you reboot, most likely the mysqld service is not being started. You need to use chkconfig in order to get it to run in run level 5. Run the following:

Code:

chkconfig mysqld on

Cheers,

Josh

jastanle84 · 10-09-2011, 07:56 PM

I ran the:

Code:

chkconfig mysqld on

after I ran the following in run level 5:

Code:

mysqld_safe --user=mysql &
service mysqld start

I am in Fedora 14 and MySQL community edition 5.1.

I did a reboot and the service still did not start after the reboot and the mysql.sock file was missing again. Any more suggestions?

corp769 · 10-09-2011, 08:22 PM

Go into Applications, System, Services - Within the services config GUI, scroll down to mysqld and check and make sure that it is supposed to run for run level 5.

jastanle84 · 10-09-2011, 08:30 PM

The services say that mysqld is set to startup in run level 2-5. Any other suggestions?

corp769 · 10-09-2011, 09:14 PM

After you double check that it is supposed to run in run level 5, reboot, and run the following:

Code:

ps aux | grep mysql

This will check if it is running or not in the background. I want to check this before we go any deeper with this issue....

jastanle84 · 10-09-2011, 09:31 PM

Here is the output of my.cnf file:

Code:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
#Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links = 0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

I ran ps aux | grep mysqld after reboot in run level 5 and this is what I get:

Code:

500   2273 0.0 0.0 4412 732 pts/0 S+ 22:23    0:00 grep --color=au
to mysqld

I hope this helps in solving my issue.

jastanle84 · 10-10-2011, 09:09 AM

bumping this thrad for help.

jastanle84 · 10-10-2011, 12:44 PM

Reinstalled Fedora 14 and added 2 gb to /var. Reinstalled MySQL and everything is working fine now. Not quite sure what the problem was. I'm marking this thread as solved. Thanks for your help Corp769.

corp769 · 10-10-2011, 02:54 PM

Sorry for the late reply, I have a kid and he takes up a lot of my time. Glad to see you got it to work though.... It was probably a misconfigured option within chkconfig or something of that sort.