mysql授权单个表权限 

mysql> create user haochengtest@'%' identified by 'haocheng.123';
Query OK, 0 rows affected (0.01 秒)

mysql> grant select,insert,update,delete on test.t_m_user to haochengtest@'%';
Query OK, 0 rows affected (0.02 秒)

mysql>

　　

posted @ 2019-04-19 17:41  kkblog  阅读(3079)  评论(0)  编辑  收藏  举报