Method 1
1. Download the MySQL source code distribution package. We don't need to differentiate the operating system. We need the same thing;
2. Rename the mysql folder in the data directory of your mysql database to oldmysql;
3. Copy the mysql directory under the data directory in the source code package to the data directory of your mysql;
4. Restart mysql. Now the mysql authorization relationship is the same as that of the new installation. log on with a blank password and adjust the authorization;
5. Open the database oldmysql to check what is going on;
6. If there is a backup, the integrity of the original database in the system will be checked to avoid modification.
Method 2
1. Send the kill command to the mysqld server to disable the mysqld server (not kill-9). The files that store the process ID are usually located in the directory of the MYSQL database.
Kill 'cat/mysql-data-directory/hostname. Pi'
You must be the root user of Linux or the same user on the SERVER where you are running;
Killall-TERM mysqld
2. Use the '-- skip-grant-tables' parameter to start mysqld;
Shell> mysqld_safe -- skip-grant-tables &
/Bin/safe_mysqld -- skip-grant-tables &
3. Use the 'mysql-h hostname mysql' command to log on to the mysqld server and use the grant command to change the password. You can also do this:
'Mysqladmin-h hostname-u user password' new password''
It can also be used
Use mysql; update user set password = password ('yourpass') where user = 'root'
;
Shell> mysqladmin-u root flush-privileges password "newpassword"
> Use mysql
> Update user set password = password ("new_pass") where user = "root ";
> Flush privileges;
4. Load the permission table:
'
Mysqladmin-h hostname flush-privileges'
Or use SQL commands
'Flush privileges'
Of course, you can restart mysqld here.