mysql--Password View or modify

Today in the study, suddenly forgot MySQL password, simply helpless, Baidu, finally solve how to check the original password problem, record.

First, start the command line, enter: taskkill/f/im mysqld.exe//Turn off MySQL

Second, into the MySQL bin directory under Three, input: mysqld--skip-grant-tables//Skip password detection Four, the original window does not close, a new open, into the MySQL bin directory Five, input: mysql-u root

Six, check the original password: select Host,user,password from Mysql.user;

　　Modify the original password: Update mysql.user set password= ' Here fill in the password you want to set ' where user= ' root ';

mysql--Password View or modify