This is strange behavior because as soon as I start mysqld with a clean error log, I get the following messages: 110720 21:38:47 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.5.14-log' socket: '/var/lib/mysql/mysql.sock' port: 2500 MySQL Community Server (GPL) by Remi 110720 21:38:48 [Warning] Access denied for user 'UNKNOWN_MYSQL_USER'@'localhost' (using password: NO) The strange things is, AFAIK there are no clients trying to connect to mysql. I shutdown a mysql CLI monitor I had running, and did the restart again. So I'm just wondering why I get this message, when AFAIK there is nothing that should be trying to connect to mysql - unless it's a server daemon running somewhere? Has anyone else come across this funny error message? Kind Regards, Keith Roberts ----------------------------------------------------------------- Websites: http://www.karsites.net http://www.php-debuggers.net http://www.raised-from-the-dead.org.uk All email addresses are challenge-response protected with TMDA [http://tmda.net] -----------------------------------------------------------------
Keith Roberts wrote:> This is strange behavior because as soon as I start mysqld > with a clean error log, I get the following messages: > > 110720 21:38:47 [Note] /usr/libexec/mysqld: ready for > connections. > Version: '5.5.14-log' socket: '/var/lib/mysql/mysql.sock' > port: 2500 MySQL Community Server (GPL) by Remi > > 110720 21:38:48 [Warning] Access denied for user > 'UNKNOWN_MYSQL_USER'@'localhost' (using password: NO) > > The strange things is, AFAIK there are no clients trying to > connect to mysql. I shutdown a mysql CLI monitor I had > running, and did the restart again. > > So I'm just wondering why I get this message, when AFAIK > there is nothing that should be trying to connect to mysql - > unless it's a server daemon running somewhere? > > Has anyone else come across this funny error message? >There must be some service that does uses MySQL but does not have user set. Website like CMS? Try getting more logs to see what app/script uses it. -- Ljubomir Ljubojevic (Love is in the Air) PL Computers Serbia, Europe Google is the Mother, Google is the Father, and traceroute is your trusty Spiderman... StarOS, Mikrotik and CentOS/RHEL/Linux consultant
On 20.7.2011 23:07, Keith Roberts wrote:> This is strange behavior because as soon as I start mysqld > with a clean error log, I get the following messages: > > 110720 21:38:47 [Note] /usr/libexec/mysqld: ready for > connections. > Version: '5.5.14-log' socket: '/var/lib/mysql/mysql.sock' > port: 2500 MySQL Community Server (GPL) by Remi > > 110720 21:38:48 [Warning] Access denied for user > 'UNKNOWN_MYSQL_USER'@'localhost' (using password: NO) > > The strange things is, AFAIK there are no clients trying to > connect to mysql. I shutdown a mysql CLI monitor I had > running, and did the restart again. > > So I'm just wondering why I get this message, when AFAIK > there is nothing that should be trying to connect to mysql - > unless it's a server daemon running somewhere? > > Has anyone else come across this funny error message?Please have a look at the initscript /etc/init.d/mysqld ...snip # Spin for a maximum of N seconds waiting for the server to come up. # Rather than assuming we know a valid username, accept an "access # denied" response as meaning the server is functioning. snap... -- Kind Regards, Markus Falb -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 307 bytes Desc: OpenPGP digital signature URL: <http://lists.centos.org/pipermail/centos/attachments/20110721/c2b6fa68/attachment-0001.sig>
On Thu, 21 Jul 2011, Markus Falb wrote:> To: centos at centos.org > From: Markus Falb <markus.falb at fasel.at> > Subject: Re: [CentOS] MySQL ERROR - UNKNOWN_MYSQL_USER > > On 20.7.2011 23:07, Keith Roberts wrote: >> This is strange behavior because as soon as I start mysqld >> with a clean error log, I get the following messages: >> >> 110720 21:38:47 [Note] /usr/libexec/mysqld: ready for >> connections. >> Version: '5.5.14-log' socket: '/var/lib/mysql/mysql.sock' >> port: 2500 MySQL Community Server (GPL) by Remi >> >> 110720 21:38:48 [Warning] Access denied for user >> 'UNKNOWN_MYSQL_USER'@'localhost' (using password: NO) >> >> The strange things is, AFAIK there are no clients trying to >> connect to mysql. I shutdown a mysql CLI monitor I had >> running, and did the restart again. >> >> So I'm just wondering why I get this message, when AFAIK >> there is nothing that should be trying to connect to mysql - >> unless it's a server daemon running somewhere? >> >> Has anyone else come across this funny error message? > > Please have a look at the initscript /etc/init.d/mysqld > > ...snip > # Spin for a maximum of N seconds waiting for the server to come up. > # Rather than assuming we know a valid username, accept an "access > # denied" response as meaning the server is functioning. > snap...Hi Markus. Thanks for that detailed explanation. I've checked the /etc/init.d/mysqld file, and like you say, it's the mysqld script itself, using the --user=UNKNOWN_MYSQL_USER option to test the mysql server is up and running. So at least I know what is causing this error, and the reason for it: TIMEOUT="$STARTTIMEOUT" while [ $TIMEOUT -gt 0 ]; do RESPONSE=`/usr/bin/mysqladmin --socket="$socketfile" --user=UNKNOWN_MYSQL_USER ping 2>&1` ----------------------------------------------------------------- Websites: http://www.karsites.net http://www.php-debuggers.net http://www.raised-from-the-dead.org.uk All email addresses are challenge-response protected with TMDA [http://tmda.net] -----------------------------------------------------------------