连接MySql报错Unable to load authentication plugin 'caching_sha2_password'.。
mysql8.0.13程序不能连接mysql。
在MySQL中执行
ALTER USER 'root'@'localhost' IDENTIFIED BY '123' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123';
FLUSH PRIVILEGES;
报错:
ERROR 1146 (42S02): Table 'mysql.user' doesn't exist
这怎么解决?
在ini配置里更改版本号为8.0.11,更新最新的!
mysql_native_password改成caching_sha2_password呢
好家伙,我的mysql直接进不去了