You may notice that you can start MySQL correctly only once under Fedora Core 1. All subsequent attempts result in the message “Timeout error occurred trying to start MySQL Daemon.”.
[root@bigboy tmp]# /etc/init.d/mysqld start Timeout error occurred trying to start MySQL Daemon. Starting MySQL: [FAILED] [root@bigboy tmp]#
This is caused by the MySQL startup script incorrectly attempting to do a TCP port ping to contact the server. The solution is:
1) Edit the script /etc/rc.d/init.d/mysqld.
2) Search for the two mysqladmin lines with the word ping in them and insert the string “-u $RANDOM” before the word “ping”:
if [ -n "`/usr/bin/mysqladmin -u $RANDOM ping 2> /dev/null`" ]; then ifÂ !([ -n "`/usr/bin/mysqladmin -u $RANDOM ping 2> /dev/null`" ]); then
3) Restart MySQL.
After doing this MySQL should function correctly even after a reboot.