mysql update failed to restart the service

Peter Peltonen <[email protected]>
Newsgroups gmane.linux.tao.general
Message-ID <[email protected]>
Last night my TaoLinux server had updated it's mysql with yum. After the 
update, the service was restarted, which failed due to a timeout, which 
was caused by the startup script failing to use mysqlping due to lack of 
privileges. It seems I encountered this bug

   https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=108779

What is strange, because the update installed last night

   mysql-3.23.58-2.3

is mentioned as a fix for that particular bug:

   http://rhn.redhat.com/errata/RHSA-2004-569.html

I resolved the problem for now by commenting out the mysqlping section 
from the startup script:

--<snip>--
ping="/usr/bin/mysqladmin -uUNKNOWN_MYSQL_USER ping"
#(peter 20041022) removed because ping does not work without passwd
#if !([ -n "`$ping 2> /dev/null`" ]); then
   #echo "Timeout error occurred trying to start MySQL Daemon."
   #action $"Starting $prog: " /bin/false
#else
   action $"Starting $prog: " /bin/true
#fi
--</snip>--

Now mysql starts ok, but I'd like to know how to repair the startup 
script properly, as mysqlping does not seem to work with dummy or real 
users without passwords:

   /usr/bin/mysqladmin -uUNKNOWN_MYSQL_USER ping
   /usr/bin/mysqladmin: connect to server at 'localhost' failed
   error: 'Access denied for user: 'UNKNOWN_MYSQL_USER@localhost' (Using
   password: NO)'
   /usr/bin/mysqladmin -uroot ping
   /usr/bin/mysqladmin: connect to server at 'localhost' failed
   error: 'Access denied for user: 'root@localhost' (Using password: NO)'
   /usr/bin/mysqladmin -uroot -p ping
   Enter password:
   mysqld is alive

Should I create a dummy account for just this purpose? This is a bit 
scary, as the password must be give with the mysqlping command as a 
paramter. But if so, what kind of privileges should I give the user?


Regards,
Peter
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.