Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I am going through my general log file when I realise that I always get the following error upon start up of my server:

Access denied for user 'UNKNOWN_MYSQL_USER'@'localhost' (using password: NO)

And every time upon launching of MySQL Workbench, I get this error:

Access denied for user 'root'@'localhost' (using password: NO)

Although I have no problem running queries or updating tables, I still find those two errors irritating and would like to not have it appear on my log file, or at least find out the reason why they are there.

Can anyone help?

share|improve this question
add comment

2 Answers

up vote 2 down vote accepted

It indicates that root has a password, but you are not supplying it, hence the (Using password: NO)

try using mysql -u root -p

The -p will make it prompt you for a password.

if everything working fine, then you have some application trying to make a request on the MYSQL with root username without password.

Is the Machine online? if yes do you have the MYSQL allowing remote connections?

If yes that dangerous you should install a protection on your MYSQL that can be done with iptables if ur machine is linux or if the server is Windows you should use the advanced firewall rule on MYSQL port 3306 or whatever port you use.

can u telnet your server on port 3306? if yes then protect the MYSQL... if you don't need the remote connections then simply disable it.

share|improve this answer
    
Thanks, I think I have found the reason. –  Question Overflow Jul 24 '12 at 15:09
    
@QuestionOverflow Remember to accept the answer that actually answered your question by clicking the outline of the check mark so that it turns green. Welcome to Server Fault! –  Michael Hampton Jul 24 '12 at 16:08
add comment

Here is your answer:

http://osdir.com/ml/centos/2011-07/msg01609.html

a bug in the startup script

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.