MySQL database 1067 error code solution, mysql1067

MySQL database 1067 error code solution, mysql1067

MySQL 5.6 is installed in Windows Professional 7 64-bit, but an error occurs one day with the error code 1067. How can this problem be solved?

Follow these steps:

1. log in as a system administrator;

2. Stop the MySQL service;

3. Enter the CMD command line mode, and then enter the MySQL installation directory, for example, D:/MySQL Server 5.6 /;

4. Skip the permission check to start MySQL and use the command

D:/MySQL Server 5.6/bin/mysqld-nt -- skip-grant-tables

5. Open CMD again and enter D:/MySQL Server 5.6/bin /,

Reset the root password

D:/MySQL Server 5.6/bin/mysqladmin-uroot flush-privileges password "newpassword" D:/MySQL Server 5.6/bin/mysqladmin-u root-p shutdown

Replace newpassword with your new password. The second command will allow you to repeat the new password.

Later, the service was restarted.

Log On, OK.

The above is a small series of Solutions to MySQL database 1067 error code, I hope to help you, if you have any questions, please leave a message, the small series will reply to you in a timely manner. Thank you very much for your support for the help House website!