From Bugzilla Helper: User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322) Description of problem: The service script uses '/usr/bin/mysqladmin' to 'ping' the mysql server, however when the server is properly password protected, the 'mysqld is alive' string is unable to be returned. Instead, this is returned: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' A quickfix was to include the -p<password> argument on lines 42 & 48, however this poses security issues. Version-Release number of selected component (if applicable): mysql-server-3.23.58-4 How reproducible: Always Steps to Reproduce: 1. service mysqld start 2. Apply password for 'root' user in mysql 3. service mysqld stop 4. service mysqld start (will 'appear' to fail now) 5. Verify mysqld is running anyway (ps -aux|grep mysql) Actual Results: Service script notes that starting of the service was unsuccessful. [FAILED] Expected Results: Service script should note [OK]. Additional info:
We have experienced this problem too. I had seen this reported in the past and the fix we used was this... edit /etc/init.d/mysqld locate the two mysqladmin ping commands. change them to mysqladmin -ujoefoo ping Using the bogus user will allow the ping and there is no chance of exposing the root password with this method. Hopefully we'll see a fix as I have no idea of the real quality of this patch.
*** This bug has been marked as a duplicate of 108779 ***
Changed to 'CLOSED' state since 'RESOLVED' has been deprecated.