Dear all:
I m planning to configure a LAMP for the first time. Every thing work fine except mysql. It is my first experience of configuring mysql in linux.
After the installation of mysql, the /etc/hosts file is as under

=======================
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
#::1 system7.exmple.com system7
172.21.1.1 system7.example.com system7
========================

but i m getting the following error

[root@system7 ~]# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

[root@system7 ~]# mysql -h system7 -u root -p
Enter password:
ERROR 1130 (00000): Host 'system7.example.com' is not allowed to connect to this MySQL server

[root@system7 ~]# mysql -h localhost -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[root@system7 ~]#

I had consulted an article on howtoforge.com but even after applying those changes, my system does not accept the password. The "localhost" entry is also not present in the "user" table. Please help me to solve this problem.

Try (as root), just typing in "mysql", and pressing enter. If this is a new installation, it should let you right in as root.

Look at the "grant" options in the MySQL knowledgebase, for details on how to add/modify users. You're probably having issues because you're putting password/host options in. The password, by the way, is for the root user in MySQL, NOT the Linux root user. The two are different.

Also, since you applied changes from "an article", if this doesn't work for you, it would help if you actually told us WHAT you did....

It is no good experimenting as Linux root. Do this in your own user account.

TB0ne is right, the root pwd for mysql is blank after a fresh installation, so log in into mysql as:
mysql -uroot

Remember that Linux root and mysql root don't have any relationship. Check these chapters: http://dev.mysql.com/doc/refman/5.0/...anagement.html.

jlinkels

Finally I have resolved the problem. It was my mistake to delete localhost line from user table. I completed the required line and it is all ok now. Thanks for support.