Mike, I forgot to say I'm using mysql-3.23.52
Perhaps, this GRANT option do not work for this version, look: ----------------------------- mysql> grant show databases to dfn@"%"; ERROR 1064: You have an error in your SQL syntax near 'show databases to dfn@"%"' at line 1 mysql> grant show databases on mysql.* dfn@"%"; ERROR 1064: You have an error in your SQL syntax near 'show databases on mysql.* dfn@"%"' at line 1 ----------------------------- Looking for the command syntax in the MySQL manual, it allows the follow options: ----------------------------- ALL PRIVILEGES FILE RELOAD ALTER INDEX SELECT CREATE INSERT SHUTDOWN DELETE PROCESS UPDATE DROP REFERENCES USAGE ----------------------------- Do you have any idea about what could be wrong? Thank's again, Ronan On Fri, 13 Jun 2003 11:07:24 -0600 "Mike Hillyer" <[EMAIL PROTECTED]> wrote: > I find the @localhost line redundant if you havd a @"%" line, as the > wildcard includes localhost. > > I think the syntax is GRANT SHOW DATABASES TO dfn@"%"; > > But I personally do not use it. > > Regards, > Mike Hillyer > www.vbmysql.com > > > -----Original Message----- > From: Ronan Lucio [mailto:[EMAIL PROTECTED] > Sent: Friday, June 13, 2003 11:04 AM > To: Mike Hillyer > Cc: [EMAIL PROTECTED] > Subject: Re: Access denied > > > Mike, > > On Fri, 13 Jun 2003 08:59:09 -0600 > "Mike Hillyer" <[EMAIL PROTECTED]> wrote: > > > GRANT SHOW DATABASES will allow a user to see all databases, whether > the > > user can access them or not. > > How should I securely grant SHOW DATABASES to an user? > > GRANT SHOW DATABASES ON mysql.db to [EMAIL PROTECTED]; > GRANT SHOW DATABASES ON mysql.db to dfn@"%"; > > Is this right? > > Thank's > Ronan > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
