hi
How can i Set User passwd in Mysql.I am very new to Mysql

I tried
GRANT ALL PRIVILEGES ON *.* TO user@localhost
IDENTIFIED BY 'password' WITH GRANT OPTION;

and

INSERT INTO user VALUES('localhost','user',PASSWORD('password'),
-> 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');

The Query shows Successfull but when i am ligging to mysql as
mysql test -h sr2 -u user -p
Password:
ERROR 1045: Access Denied For User 'user@localhost' (using password=YES)



And I can login by just hitting enter on that password prompt

Help Me !! I am in trouble;

mysqladmin -u <username> -p password <newpassword>

This will prompt you for the current password and change it to the <newpassword>. You don't need the <>, I just put them in so you know which things you need to change.

hi

Thank You fro your Valuable reply

The mysqladmin executed successfully but when i am loggong
mysql test -h sr2 -u user -p

again
ERROR 1045: Access Denied For User 'user@localhost' (using password=YES)

what is happening here??

Sounds like there is no database "test"