mysql change root user password

A simple way to change root user password is to open SQL box and launch the following query:

UPDATE mysql.user SET Password=PASSWORD(‘password’) WHERE User=’root’; FLUSH PRIVILEGES;

Facebooktwitterredditpinterestlinkedinmail