mysql用户授权

查看 mysql库 user表结构
> desc mysql.user;

查看 mysql用户和密码
> select User,Host,authentication_string from mysql.user;

查看 crm_user'@'10.%.%.%' 授权
> show grants for  'crm_user'@'10.%.%.%';

mms_sales_clue.sl_clue_base_info 增加UPDATE权限，mms_sales_clue.* 增加UPDATE权限
> GRANT UPDATE ON `mms_sales_clue`.* TO 'crm_user'@'10.%.%.%';
> GRANT UPDATE ON `mms_sales_clue`.`sl_clue_base_info` TO 'crm_user'@'10.%.%.%';
> FLUSH PRIVILEGES;