Tuesday 29 March 2016





How to Change MySQL root password on Windows


Setting  root password for MySQL Database

  • Start your command line by going to the Start Menu > Run and typing cmd (or type command if you are using an older version of windows)
  • Change directory to where you installed mysql to:
    C:\> cd C:\mysql\bin
  • Switch to mysql command line:
    C:\mysql\bin> mysql -u root mysql
  • Then set a default password:
  • mysql> SET PASSWORD FOR root@localhost=PASSWORD('newpass');
    where "newpass" is the password you want to use

No comments:

Post a Comment