给mysql数据添加一个只拥有一张表的权限

grant all privileges on [database].* to 'database'@'localhost' identified by 'password'

 

 

例如:

grant all privileges on mytest.* to 'mytest'@'localhost' identified by '123456'

posted @ 2017-08-12 16:50  换行程序员  阅读(493)  评论(0编辑  收藏  举报