How to change MySQL root password?

How to change MySQL root password?

Steps by Step 

  1.  Open MySQL Command Line Client  
  2.  To remove a password  SET PASSWORD FOR root@localhost=PASSWORD(”);
  3.  To add a password    SET PASSWORD FOR root@localhost=PASSWORD(‘root’);
  4.  Demo image is below

Published by arjunpremier

Software Engineer, Blogger,

Leave a comment

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

Design a site like this with WordPress.com
Get started