线上库维护权限很重要.
项目中使用
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"??