How to change MYSQL root password in windows 7

In my last post, i shared my experience with installing MYSQL in windows 7.

During the installation I set ‘root’ as MYSQL password.

Now I want to change the same to ‘hostonnet’

I followed the instructions at MYSQL Documentation

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

But that was not successfull.

I got much simpler way to reset MYSQL root password in windows 7

Go to start-> MYSQL command line ->

mysql-password-change-1

mysql -u root -p

Use mysql database

use mysql

Update user password using simple update query.

update user set password=PASSWORD("hostonnet") where User='root';

then flush:

flush privileges;

mysql-password-change-2


About hostonnet2

Bootstrap and Android LOVER. I've been creating things for the web for over 10 years, from the period of flash and table based layout web sites till mobile and tab friendly web sites.
Posted in MySQL