问题

之前一直用mysql5.7 远程授权登录，后来换mysql8.0原来的授权方式报错

mysql> GRANT ALL ON *.* to root@'%' IDENTIFIED BY 'AAbb1122!!';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY 'AAbb1122!!'' at line 1

原因分析

8.0授权方式不一样 ，不能授权给自己

先创建一个其他用户

create user 'user0001'@'%' identified by 'User0001!';

grant all privileges on *.*  to  'user0001'@'%'  identified by 'User0001!'  with grant option;

GRANT ALL PRIVILEGES ON *.* TO 'user0001'@'%';


FLUSH PRIVILEGES;

ALTER USER 'user0001'@'%' IDENTIFIED WITH mysql_native_password BY 'User0001!';

select host, user, authentication_string, plugin from user;