Next I will introduce some methods for changing the password of mysql. The simplest is to modify the password of mysql directly in phpmyadmin or command mode, the other is to change the password in command mode.
Next I will introduce some methods for changing the password of mysql. The simplest is to modify the password of mysql directly in phpmyadmin or command mode, the other is to change the password in command mode.
If you forget the MySQL root Password, You can reset it using the following methods:
1. KILL the MySQL process in the system;
The Code is as follows: |
|
Killall-TERM mysqld
|
2. Run the following command to start MySQL without checking its permissions;
The Code is as follows: |
|
Safe_mysqld-skip-grant-tables &
|
3. Use the empty password to log on to MySQL as the root user;
The Code is as follows: |
|
Mysql-u root
|
4. Modify the password of the root user;
The Code is as follows: |
|
Mysql> update mysql. user set password = PASSWORD ('new password') where User = 'root '; Mysql> flush privileges; Mysql> quit
|
Restart MySQL to log on with the new password.
Knowing the mysql password is simple modification.
1. Modify records directly in the database
The Code is as follows: |
|
Mysql> use mysql Mysql> update user set password = password ("new_password") where user = "user_name "; Mysql> flush privileges; |
In fact, this method is to update a database record. Unlike normal update statements, the password is encrypted and generated using the password () function. Another difference is that the permission table needs to be refreshed.
2. Run set password in the database
The Code is as follows: |
|
Mysql> set password for user_name = password ("new_password "); Mysql> flush privileges; |
In the same method, you must refresh the permission table.
3. Run mysqladmin directly in the shell Environment
The Code is as follows: |
|
> Mysqladmin-u user_name-p password "new_password" > Mysqladmin flush-privileges |
4.
The Code is as follows: |
|
Grant all privileges on db. table to user_name @ localhost identified by "set password "; |
Do not use flush privileges to refresh the user name and password