问题
之前一直用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;
var code = “d0c57f0a-5cf9-4987-b71b-c13c1363af76”