Navicat无法连接Mysql8.0
2020-01-31 本文已影响0人
Yuri1996
sql命令控制台，如果这段无法运行，将mysql安装目录的bin目录添加到环境变量中
mysql -u root -p
改加密方式
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
改密码为password
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
刷新
FLUSH PRIVILEGES;
