Yup...latest stable is 4.0.16! Does anyone know what I need to do to stop SHOW DATABASE? Even though I specify in /etc/my.cnf
Dickon... ----- Original Message ----- From: "Fortuno, Adam" <[EMAIL PROTECTED]> To: "'Dickon Newman'" <[EMAIL PROTECTED]> Sent: Thursday, October 30, 2003 9:16 AM Subject: RE: show databases problem > Is there a 4.0.2 release? I thought production was up to 4.0.16? > > Regards, > Adam > > -----Original Message----- > From: Dickon Newman [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 30, 2003 8:55 AM > To: [EMAIL PROTECTED] > Subject: Re: show databases problem > > > 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]