HostOnNet Blog

How to change MYSQL root password in windows 7

Looking for Linux Server Admin or WordPress Expert? We can help.

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

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 -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;


About Sibi Antony

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

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.