如何防止mysql用户显示所有数据库 [英] how to prevent mysql user from showing all databases

问题描述

0.82sp1正在运行，我注意到每个用户都可以通过调用show databases;命令来查看所有数据库.即使我撤销了给定用户的所有特权.是否有一些设置允许默认显示数据库?我该如何阻止.

0.82sp1 running and i've noticed that every user can see all databases by invoking show databases; command. Even if i revoke all privileges for given user. Is there some setting that allows showing databases by default? How can i stop this.

推荐答案

免责声明:从ajreal评论中窃取

DISCLAIMER: Stolen from ajreal comment

来自dev.mysql :

如果服务器使用--skip-show-database选项启动，则您 除非您拥有SHOW DATABASES，否则根本不能使用此语句(SHOW DATABASES) 特权.

If the server was started with the --skip-show-database option, you cannot use this statement (SHOW DATABASES) at all unless you have the SHOW DATABASES privilege.

这篇关于如何防止mysql用户显示所有数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！