数据库跨域操作配置

数据库跨域操作配置

INSERT INTO mysql.user(Host,User,Password) VALUES('%','papaid',PASSWORD('123456'));
FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON  `papaid` . * TO  'papaid'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION ;

GRANT ALL PRIVILEGES ON  `papa_papaid` . * TO  'papa_papaid'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION ;
grant  all on *.* to   dba@localhost;
revoke all on *.* from dba@localhost;

MySQL>update user set host = '%' where user = 'root';
MySQL>select host, user from user;

mysql5.1以上添加用户

GRANT USAGE ON *.* TO 'root'@'%' IDENTIFIED BY 'yuxiu' WITH GRANT OPTION;