Changing USER ID Password in MySql

Setting the MySQL Root Password
You now should have MySQL running in a DOS console. Open another console window using one of the two methods described above. You need to change the default root password on your MySQL Windows install. Write your password down somewhere so you don't forget it.

 TYPE c: TYPE cd mysql\bin TYPE mysql -u root 

At the MySQL prompt:

 TYPE SET PASSWORD FOR 'root'@'localhost' = PASSWORD('yourpasswordhere'); TYPE DELETE FROM mysql.user WHERE Host='localhost' AND User='""'; TYPE FLUSH PRIVILEGES; 

These commands change your root password and remove another out-of-the-box root user to improve your security.