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]