HostOnNet Blog

Change MySQL Root Password

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

To change MySQL root Password, login to MySQL as user root.

mysql -u root -p

Now run

use mysql;
update user set password=PASSWORD("NEW-MYSQL-PASSWORD-HERE") where User='root';
flush privileges;

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.