菲律宾反馈帐号不存在

zhgc

问题的原因：
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'@'%'