mysql>GRANTALLON*.*toroot@'%'IDENTIFIEDBY'AAbb1122!!';

ERROR1064(42000):YouhaveanerrorinyourSQLsyntax;checkthemanualthatcorrespondstoyourMySQLserverversionfortherightsyntaxtousenear'IDENTIFIEDBY'AAbb1122!!''atline1

缘由缘由分解

8.0授权情势分比方样，没有言授权给尔圆

先创修一个别的用户

createuser'user0001'@'%'identifiedby'User0001!';

grantallprivilegeson*.*to'user0001'@'%'identifiedby'User0001!'withgrantoption;

GRANTALLPRIVILEGESON*.*TO'user0001'@'%';

FLUSHPRIVILEGES;

ALTERUSER'user0001'@'%'IDENTIFIEDWITHmysql_native_passwordBY'User0001!';

selecthost， 国产男女猛烈视频在线观看user，a片在线观看authentication_string，pluginfromuser;