Advertisement
Guest User

Untitled

a guest
Feb 5th, 2016
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.57 KB | None | 0 0
  1. 0) shut down service mysql56
  2.  
  3. 1) go to C:ProgramDataMySQLMySQL Server 5.6
  4. (note that ProgramData is a hidden folder)
  5.  
  6. 2) look for file my.ini, open it and add one line skip-grant-tables below [mysqld],
  7. save [mysqld]
  8.  
  9. skip-grant-tables
  10. 3) start service mysql56
  11.  
  12. 4) by right, you can access the database, and use the query below to update the password
  13.  
  14. update mysql.user set password=PASSWORD('NEW PASSWORD') where user='root';
  15. 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