MySQL forgot password login does not go in, with the command to modify the new password re-login method: 1. Back up My.ini2. In the My.ini field [mysqld] #socket = Mysqlskip-grant-tables Save My.ini This file and then close, restart Mysql3. Go to your MySQL installation directory (for example, my D:\software\mysql\MySQL Server 5.6\ BIN) at the command line, enter D: Press ENTER to enter D and then enter: CD: "D:\software\mysql\MySQL Server 5.6\bin" Enter 4. Enter the SQL command Mysql-uroot-penter PASSWORD: Direct return without entering anything show databases; Note to have a semicolon, the carriage return will see all of your database files to see if the use Mysqlupdate Mysql.user set Password=password (' Enter your password ') where user= ' root '; flush Privileges;quit Enter to complete without permission to go into the database and reset the password
MySQL forgot password login do not go in, with the command to modify the new password re-login method