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.

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.