Description of problem: After upgrading from RedHat 9, following error showed up during boot: Timeout error occurred trying to start MySQL Daemon. The new script that starts mysqld is at fault. In particular, the command "/usr/bin/mysqladmin ping" fails if mysql root password is set. Version-Release number of selected component (if applicable): mysql-server-3.23.58-4 How reproducible: Always, if mysql root password is set Steps to Reproduce: bash-2.05b# /etc/rc.d/init.d/mysqld status mysqld (pid 16723) is running... bash-2.05b# /etc/rc.d/init.d/mysqld stop Stopping MySQL: [ OK ] bash-2.05b# /etc/rc.d/init.d/mysqld start Timeout error occurred trying to start MySQL Daemon. Starting MySQL: [FAILED] bash-2.05b# /etc/rc.d/init.d/mysqld status mysqld (pid 16826) is running... Actual results: Get failed message Expected results: Should have started normally Additional info: The bug is in the starting script, and it only fails to display that the server is up. The server actually starts properly, so priority to fix this is low. I have isolated the problem to the command "/usr/bin/mysqladmin ping" which returns: bash-2.05b# /usr/bin/mysqladmin ping /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' That's because the mysql root account is pasword protected, as it should be. If I do: bash-2.05b# /usr/bin/mysqladmin ping -p Enter password: mysqld is alive all is well, but of course you can't do that during boot. The RedHat 9 mysqld starting script works fine with a mysql root password.
*** This bug has been marked as a duplicate of 108779 ***
I tried the following and now I cannot even start my mysqld: mysql> UPDATE mysql.user SET Password = PASSWORD('12345') -> WHERE User = 'root'; mysql> FLUSH PRIVILEGES; ###After this I did an exit and then tried the following: [root@netd rprakash]# service mysqld start Timeout error occurred trying to start MySQL Daemon. Starting MySQL: [FAILED] [root@netd rprakash]# mysql ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) I am only a beginner in this field. Could anyone kindly sugest me a work-around to restart my mysqld. Thanks
Changed to 'CLOSED' state since 'RESOLVED' has been deprecated.