mysql8.0入坑体验

正常从官网下载，并且正常安装，直到安装完成。
然后用navicate连接，发现报错信息如下所示
Client does not support authentication protocol requested by server; consider upgrading MySQL client

bing了一下，发现是密码加密方式不一样，然后接着更改

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '你的密码';

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的密码';
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

巴特西