select host, user, authentication_string, plugin from mysql.user;
grant all privileges on *.* to root@"%" identified by "aaa+Pe4" ;
create user 'root'@'10.%' identified by 'aaa';
grant all privileges on *.* to 'root'@'10.%' identified by "aaa" ;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'10.%' WITH GRANT OPTION;
grant select on xesbi.* to spylisel@"10.%" ;
show grants for 'testUser'@'%';
flush privileges;
高版本授权分布执行:
create user 'root'@'%' identified by 'password';
grant all privileges on *.* to 'root'@'%' with grant option;
flush privileges;