How does MySQL forget the password?

MySQL forgot the password. 1. Find the MySQL installation directory and copy the MySQL installation directory (C:/../bin) to dos.

Enter mysqld-NT -- skip-grant-tables

Restart MySQL to log on. The password is blank.

2. Update mysql. User SET Password = PASSWORD (1234) where user = 'root ';

In this way, you can reset the MySQL password. It can be seen that the MySQL server segment cannot be easily accessed, otherwise the consequences will be very serious.

This article from [SVN Chinese network] Forward Please retain this site address: http://www.svn8.com/mysql/200906036015.html