MySql8安装及ROOT密码修改
安装
参考链接:https://www.cnblogs.com/mashangsir/p/11286322.html
修改ROOT密码
1、mysql8.0以上密码策略限制必须要大小写加数字特殊符号
2、1、alter user ‘root’@‘localhost’ identified with mysql_native_password by ‘********’;
3、flush privileges;
查看端口
show global variables like ‘port’;
Navicat连接Mysql报错:Client does not support authentication protocol requested by server
1、alter user ‘root’@‘localhost’ identified with mysql_native_password by ‘********’;
2、flush privileges;