IDEA连接mysql数据库权限出错 Client does not support authentication protocol requested by server； consider upg

小咪咪 2024-03-23 17:26 75阅读 0赞

### Client does not support authentication protocol requested by server; consider upgrading MySQL client ###

### 翻译：客户端不支持服务器请求的身份验证协议;考虑升级MySQL客户端 ###

### ![0ddf6f31dfca4aaaba279fbb13d6722f.png][] ###

### 解决方法： ###

### 登录到mysql配置mysql\_native\_password身份验证插件 ###

//root是登录的用户名称，后面的by '新密码'；中的密码要换成自己的
    alter user 'root'@'localhost' identified with mysql_native_password by '12345678';
    //刷新权限
    flush privileges;

### win+R输入cmd打开命令行窗口![983abfebe2684edd8b242d9bd8c74070.png][] ###

### 我这里mysql因为在环境里面配置过的，所以在哪个路径下打开mysql都是可以的，如果不能正常进入到输入密码选项需要找到mysql下的路径输入命令，或者你在环境里面配置好也可以。 ###

### ![b4b573b475244b7bb1f2be0fa8f81769.png][] ###

###  ###

### 原因：这是因为mysql8.0的默认密码验证不再是password。所以在创建用户时，create user 'username'@'%' identified by 'password'; 客户端是无法连接服务的。所以要修改mysql\_native\_password身份验证插件的密码。 ###

###  ###

### 解决问题，连接成功！！！ ###

### ![42aa246932574cd6b6a7c0768ab2f4ba.png][] ###

###  ###

[0ddf6f31dfca4aaaba279fbb13d6722f.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/b3cde17926734980b9a7c7f3dffbcdb5.png
[983abfebe2684edd8b242d9bd8c74070.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/c1b59a8f26a545f390088ac22838317b.png
[b4b573b475244b7bb1f2be0fa8f81769.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/571d874ac2cf4f328079bb893d8d0b59.png
[42aa246932574cd6b6a7c0768ab2f4ba.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/14/9250b39cf869473f8ae236b41df4dec3.png

IDEA连接mysql数据库权限出错 Client does not support authentication protocol requested by server； consider upg

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 Client does not support authentication protocol requested by server； consider upgrading MySQL client

相关 IDEA连接mysql数据库权限出错 Client does not support authentication protocol requested by server； consider upg

相关 MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading

相关 1251-Client does not support authentication protocol requested by server； consider upgrading MySQL c

相关 Client does not support authentication protocol requested by server; consider upgrading MySQL Client

相关 1251 Client does not support authentication protocol requested by server;consider upgrading MySQLcli

相关 nodejs连接mysql报错：Client does not support authentication protocol requested by server; consider upgrad

相关 client does not support authentication protocol requested by server;consider upgrading mysql client

相关 1251 - Client does not support authentication protocol requested by server;consider upgrading MySQL

相关 1251-client does not support authentication protocol requested by server