Home >Backend Development >PHP Tutorial > linux上设置新建mysql帐号并赋予权限有关问题
linux上设置新建mysql帐号并赋予权限有关问题
- WBOYOriginal
- 2016-06-13 13:16:21779browse
linux下设置新建mysql帐号并赋予权限问题
在linux下新建一个账户只对一个数据库的某张表有读权限
------解决方案--------------------
grant select on testdb.test to common_user@'%' //赋予 common_user 用户对 testdb中test表的查询权限
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article： zend studio9.0.0怎么无限期使用 Next article： 怎么正确运用PHP ini_set函数