I've visited www.mysqlfreaks.com and found this article which is very similar to what I'm facing in MySQL.
Can someone tell me what I'm suppose to do after reading this? And How can I do it.

Access denied for user error
If you get the error Access denied for user: 'some-user@unknown' to database 'mysql' when accessing a MySQL server on the same machine, this means that MySQL can't resolve your host name properly. To fix this, you should create a file `\windows\hosts' with the following information:
127.0.0.1 localhost

How to create this file?

Looking forward to your reply,
MIMT

What is the OS you are using? are you trying all that from windows?

_________________________
-Vijay G
Strive for Perfection

the error message means you do not have enough rights. try this line
C:\mysql\bin>mysql -uroot -pYOURPASSWORD u is for username and p for password
you don't need to change anything .Try this and see what happen(I am assuming you are using windows)
goto command prompt then goto your mysql folder and type this
c:\yourmysqlfolder\bin>mysql -uroot
then you will see this page
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 14 to server version: 3.23.58-max

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
if you see this page it means you can connect to your mysql server
other soloution is use phpmyadmin
try to download it from this link it's very easy to setup
http://prdownloads.sourceforge.net/p...2.zip?download
but remember you should install php first and you should have iis installed aswell


Best Regards,
Hamed Gholamian