mysql 帐号容易管理

mysql 帐号简单管理
线上库维护权限很重要.项目中使用

GRANT Select,Update,Delete,Insert ON *.* TO operator@127.0.0.1  IDENTIFIED BY "operator"

GRANT Select ,Update ,Delete,Insert ON *.* TO fb@192.168.1.11  IDENTIFIED BY "fb"

GRANT Select ON *.* TO readonly@192.168.1.10  IDENTIFIED BY "readonly"