Are you saying I have to upgrade to 4.0.2? Is this the best path for me to take?
Dickon... ----- Original Message ----- From: "Chris" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 29, 2003 7:24 PM Subject: RE: show databases problem > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]