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