Red Hat Bugzilla – Bug 116531
mysql-server 'mysqld' service script fails to correctly start
Last modified: 2013-07-02 23:00:27 EDT
From Bugzilla Helper:
User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET
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):
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].
We have experienced this problem too. I had seen this reported in the
past and the fix we used was this...
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 bug has been marked as a duplicate of 108779 ***
Changed to 'CLOSED' state since 'RESOLVED' has been deprecated.