Im running FC2 and if i change the root password from nothing to *****
and then i restart mysql i get a :

Timeout error occrred trying to start mysql daemon

if i change it back to no password then the error goes away.


What can i do to fix this security problem.

Wierd.

Are you changing the Linux root user password? Or the mysql root user?

What do the mysql error logs say?

im changing the mysql root user.


mysql -u root
mysql> SET PASSWORD FOR ''@'localhost' = PASSWORD('*****');
Query OK, 0 rows affected (0.00 sec)

then i restart mysql and i get the error.

Timeout error occrred trying to start mysql daemon

PS:Im not getting nothing on the log..

Anyone?

i try this and still get the same ..

A Common Fedora Core MySQL Startup Error
You may notice that you can start MySQL correctly only once under Fedora. All subsequent attempts will give a "Timeout error occurred trying to start MySQL Daemon" error.


this is caused by the MySQL startup script incorrectly attempting to do a TCP port "ping" to contact the server. The solution to this is to:


Edit the script /etc/rc.d/init.d/mysqld

Search for the two "mysqladmin" lines with the word "ping" in them and insert the string "-u $RANDOM" before the word "ping" like this:



if [ -n "`/usr/bin/mysqladmin -u $RANDOM ping 2> /dev/null`" ]; then

if !([ -n "`/usr/bin/mysqladmin -u $RANDOM ping 2> /dev/null`" ]); then



o Restart MySQL



Helpp

I just updated to the latest mysql.