深圳全飞鸿

标题: 菲律宾反馈帐号不存在 [打印本页]

作者: zhgc 时间: 2019-11-16 17:02
标题: 菲律宾反馈帐号不存在
问题的原因：
database在复制到菲律宾时，只有root，其他帐号都没有同步过去

解决方法：

1. 创建帐号：
CREATE USER 'sfcapi'@'%' IDENTIFIED BY 's2018' ;

2. 查看东莞的权限：
show grants for sfcapi@'%';

GRANT SELECT, SUPER ON *.* TO 'sfcapi'@'%' IDENTIFIED BY PASSWORD '*E321932433F41AE1E364AA2B' WITH GRANT OPTION
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, EXECUTE, CREATE ROUTINE, ALTER ROUTINE ON `sfc`.* TO 'sfcapi'@'%' WITH GRANT OPTION
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON `mysql`.`proc` TO 'sfcapi'@'%'

3. 执行后两条

4. 权限太大，拿掉drop的权限
REVOKE DROP ON `sfc`.* FROM 'sfcapi'@'%';
REVOKE DROP ON `mysql`.`proc` FROM 'sfcapi'@'%';

GRANT SELECT, SUPER ON *.* TO 'sfcapi'@'%' IDENTIFIED BY PASSWORD '*E32193243EE5B2E364AA2B' WITH GRANT OPTION
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, INDEX, ALTER, EXECUTE, CREATE ROUTINE, ALTER ROUTINE ON `sfc`.* TO 'sfcapi'@'%' WITH GRANT OPTION
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, INDEX, ALTER ON `mysql`.`proc` TO 'sfcapi'@'%'

欢迎光临深圳全飞鸿 (http://www.nagomes.com/disc/)