Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 0) shut down service mysql56
- 1) go to C:ProgramDataMySQLMySQL Server 5.6
- (note that ProgramData is a hidden folder)
- 2) look for file my.ini, open it and add one line skip-grant-tables below [mysqld],
- save [mysqld]
- skip-grant-tables
- 3) start service mysql56
- 4) by right, you can access the database, and use the query below to update the password
- update mysql.user set password=PASSWORD('NEW PASSWORD') where user='root';
- 5) shun down the service again, remove the line skip-grant-tables save it, and start the service again. try to use the password you set to login.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement