If you have removed the default anonymous users as recommended by
mysql, starting mysqld will report an error (even though mysql started
successfully), because the script attempts to issue 'mysqladmin -uxxxx
ping' and the user xxxx no longer exists.
I can't use normal users, because they're all locked down with
passwords, so I've inserted a dummy user 'pinger' and modified the
script accordingly to eliminate this error message. The question is,
and I've found nothing in google, what are the minimum privileges to
give a user to enable 'ping' permissions? I did 'grant usage on *.* to
'pinger'@'localhost';'. Could I have granted privilege for only one
database, for example?
--
Collins
