In 4.0.2 SHOW DATABASES became a privilege, and if you don't have that privilege then 
you can see only 'your own' databases.

Maybe your privileges were changed during the upgrade?

http://www.mysql.com/doc/en/Show_database_info.html

Chris

-----Original Message-----
From: Dickon Newman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 29, 2003 1:55 PM
To: [EMAIL PROTECTED]
Subject: show databases problem


Dear All,

I've tried searching the web to save me having ask for help.

I'm trying to remove my user's ability to use SHOW DATABASES.  In the past, I have 
added skip-show-database to /etc/my.cnf.
However, on this installation, any user can see all the database names!  Despite my 
efforts to stop them being able to.

I am using FreeBSD 5.1.  I am using mysql version 4.0.15a.

So far, the only think I can think of is that I migrated from a (freebsd) package of 
mysql...I think version 4.0.10?  I copied the
same mysql database across to the new server.

Can anyone enlighten me on how to restrict users from seeing databases other than 
their own?  Even if they can't see any...that's
fine too!

Dickon...


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to