mysql8.0+版本创建用户授权:
create user 'root'@'%' identified by '123456';
grant all privileges on *.* to 'root'@'%' with grant option;
flush Privileges
;
Navicat连接Mysql报错:
1、use mysql;
2、alter user 'root'@'localhost' identified with mysql_native_password by '********';
3、flush privileges;