数据库权限管理和维护_MySQL
- WBOYOriginal
- 2016-05-31 08:49:431237browse
﹙1﹚ 赋权限
1﹚ 对普通用户的查询删除Grant select,insert, update, delete, execute on database.* to ‘user’@’hostname’ identifiedby ‘password’
2﹚ 对数据库开发人员需要权限:”create(创建),alter(修改) ,drop(删除),reference(外键), create temporary tables(创建临时表权限), index(索引), createview(创建视图),show view(展示视图), ”
﹙2﹚ 收回权限
1﹚ Revoke all on database.* from ‘user’@’hostname’
﹙3﹚ 保护选项文件以阻止其他用户读取
1﹚ 选项文件在数据库就是my.ini文件
2﹚ Windows实现用资源管理器实现
3﹚ Linux用语句% chmod 600 .my.cnf等语句实现
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：sql点滴42—mysql中的数据结构Next article：mysql存储过程示例代码_MySQL