Flushing Password and setting a new

[javed.iqbal.3979]

Hi all,
I have to clarify a few ambiguites regarding mysql client to use for i running database scripts
1).Firstly i want to flush the root password set by me earlier using :mysqladmin -u root password 'root password goes here'.
2).Second i am faced with a problem of "Acces denied for user@localhost using password... time and again by using cmd.exe and mysqclient.

Kindly help me fix this so as to get password free root account to run mysql scripts.

[peeyush.budhia]

Check this: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

[mugiraneza]

*thanks**

[Borzoi]

Your syntax is incorrect. To specify the password, you use the -p flag, you don't type password.

mysql -u root -p password

This will log you in to MySQL from the command line.