mysql8.0入坑体验
正常从官网下载,并且正常安装,直到安装完成。
然后用navicate连接,发现报错信息如下所示
Client does not support authentication protocol requested by server; consider upgrading MySQL client
bing了一下,发现 是密码加密方式不一样,然后接着更改
Flush Privileges;
然后查看一下用户表
mysql> select user,host,plugin from mysql.user; +------------------+-----------+-----------------------+ | user | host | plugin | +------------------+-----------+-----------------------+ | heima | % | mysql_native_password | | mysql.infoschema | localhost | caching_sha2_password | | mysql.session | localhost | caching_sha2_password | | mysql.sys | localhost | caching_sha2_password | | root | localhost | mysql_native_password | +------------------+-----------+-----------------------+ 5 rows in set (0.00 sec)
MySQL8.0默认的加密方式为caching_sh2_password。修改为mysql_native_password
然后再次用navicate;连接,就能够成功了
安装的时候,需要额外安装一下Microsoft visual C++ 2015 redistributation

更多精彩