Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Prevent views of other databases

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
How would I go about preventing the listing of other MySQL databases on a server when a person remotely connects to his/her database.
 
you have 2 options - maybe more, but i know just these

1. start your mysql server with this option "--safe-show-database"

2. edit /etc/my.cnf - in the mysqld section add "safe-show-database"
so it should look like this

[mysqld]
#your other options
safe-show-database

or instead of "safe-show-database" you could use "skip-show-database", this option prevents from displaying any databases, this returns nothing

hope that helps
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top