[CentOS] MySQL ERROR - UNKNOWN_MYSQL_USER
Keith Roberts
keith at karsites.net
Wed Jul 20 21:32:23 UTC 2011
On Wed, 20 Jul 2011, Ljubomir Ljubojevic wrote:
> To: CentOS mailing list <centos at centos.org>
> From: Ljubomir Ljubojevic <office at plnet.rs>
> Subject: Re: [CentOS] MySQL ERROR - UNKNOWN_MYSQL_USER
>
> 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.
Hi Ljubomir.
It might be collectd that can use mysql. The man page is
over 5,000 pages for the config file. I seem to remember
seeing a message at boot time about collectd not being
configured properly to use mysql.
I installed collectd recently, so I could monitor my HDD
temperatures using GKrellM, which it's doing OK.
I'll leave this for another day!
Kind Regards,
Keith
-----------------------------------------------------------------
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]
-----------------------------------------------------------------
More information about the CentOS
mailing list