Article ID: 2514, created on Oct 29, 2007, last review on May 10, 2014

  • Applies to:
  • Pro Control Panel Linux


View Knowledge
Knowledge ID 1291
Product : WEBppliance for Linux
Version : 3.5.0
Topic : FAQ

How can I stop a MySQL user from seeing all of the database names

How can I stop a MySQL user from seeing all of the database names



If you want to prevent a MySQL user from being able to see the other database names when using the show databases command then edit /etc/rc.d/init.d/mysql_app_init and change the following line:



SAFE_MYSQLD_OPTIONS="--defaults-file=/etc/my.cnf --safe-show-database"

Then restart MySQL. Even though previously the user could see the MySQL database names, they would not be able to access the actual databases unless they had access to them. This only obscures the database names from show databases, so the MySQL user can not see the database name that he/she doesn't have some kind of access to.


Related Knowledge

Related Links
Last ModifiedUsageSatisfiedLast Used
8/20/2004 12:50:49 PM57 10/11/2007 6:35:03 AM

4cc899da08664637a8bc437308d3ddd7 3ccb419cf98083f3bb45808fba8dbc7c 6311ae17c1ee52b36e68aaf4ad066387

Email subscription for changes to this article
Save as PDF