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!