## mysql 8 版本密码操作

[TOC]



#### 1.删除root@local后，怎么恢复

>  INSERT INTO user (host, user, authentication_string, ssl_cipher, x509_issuer, x509_subject) VALUES ('localhost', 'root', 'Rot@1234', '', '', '');
> ![image-20241205150050311](./$%7Bimages%7D/image-20241205150050311.png)



#### 2.忘记密码更改用户密码

> flush privileges;
>
> alter user root IDENTIFIED BY 'Tmp@1234';
>
> ![](./$%7Bimages%7D/image-20241205160840022.png)



#### 3.更改用户密码(需要系统权限用户，首选更新密码应当使用alter语句)

> set password for 'admin'@'%' = 'Pass@adm1234';
>
> ![image-20241205162906367](./$%7Bimages%7D/image-20241205162906367.png)



#### 4.更改mysql8默认认证caching_sha2_password插件为mysql_native_password;

> ALTER USER 'admin'@'%' IDENTIFIED WITH mysql_native_password BY 'your_password';