Home >Backend Development >PHP Tutorial > linux下设置新建mysql帐号并赋予权限有关问题
linux下设置新建mysql帐号并赋予权限有关问题
- WBOYOriginal
- 2016-06-13 12:50:52939browse
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： 求php好手，看下这一段加密算法的原理 Next article： 用过齐博系统的大神帮忙看下,该如何处理