数据库跨域操作配置

最新推荐文章于 2022-09-27 19:59:55 发布

weixin_30915275

最新推荐文章于 2022-09-27 19:59:55 发布

阅读量213

点赞数

CC 4.0 BY-SA版权

文章标签：数据库 php

原文链接：http://www.cnblogs.com/zhuiluoyu/p/4469457.html

数据库跨域操作配置

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;

转载于:https://www.cnblogs.com/zhuiluoyu/p/4469457.html