navicat链接阿里云mysql8

1. root密码

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '密码';

 

2.新建用户

create  user  '新用户'@'%'  identified  by  '密码';

 

3.权限

GRANT ALL PRIVILEGES ON *.* TO '新用户'@'%' WITH GRANT OPTION;

 

4.改密码规则

UPDATE user set authentication_string='' where user='新用户';

ALTER USER '新用户'@'%' IDENTIFIED WITH mysql_native_password BY '密码';

 

5.刷新

flush privileges;