正常從官網下載，並且正常安裝，直到安裝完成。然後用navicate連接，發現報錯信息如下所示Client does not support authentication protocol requested by server; consider upgrading MySQL clientbing ...
正常從官網下載，並且正常安裝，直到安裝完成。
然後用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
