On Thu, 21 Jul 2011, Markus Falb wrote:
To: centos@centos.org From: Markus Falb markus.falb@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] -----------------------------------------------------------------