pointing me in the right direction,
John
-Original Message-
From: Stephen Edberg [mailto:sbedb...@ucdavis.edu]
Sent: Sunday, February 15, 2009 7:07 PM
To: John
Cc: mysql@lists.mysql.com
Subject: Re: Show Databases issue
On Sun, 15 Feb 2009, John wrote:
> How do I disable showing ALL the d
On Sun, 15 Feb 2009, John wrote:
> How do I disable showing ALL the databases on the server for a normal user
> that only has access to a single database? So that when a user runs show
> databases, they only get a list of ones they can access. I've seen this done
> before.
>
> Sorry if it's a newb
The first thing to do is to verify that things are as expected. In the root
session, run
SHOW GRANTS FOR [EMAIL PROTECTED]
You should see something like this:
+--+
| Grants for [EMAIL PROTECTED]
On 10/17/2004 7:12 AM, Michael J. Pawlowsky <[EMAIL PROTECTED]> wrote:
> All priviliges for that user in mysql.user are set to N.
> I know this is hard to read but here are the outputs from user and db.
[snip]
> Paul DuBois wrote:
>
>> At 10:02 -0400 10/16/04, Michael J. Pawlowsky wrote:
>>
>>
All priviliges for that user in mysql.user are set to N.
I know this is hard to read but here are the outputs from user and db.
+---++--+-+-+---
--+-+-+---+-+---+---
---+
At 10:02 -0400 10/16/04, Michael J. Pawlowsky wrote:
I just noticed that a restricted user to only one database can still
run "show databases;"
and see all the names of the databases in MySQL.
You would think that it would only return the databases that that
user is allowed to connect to.
Is th
, October 30, 2003 5: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: Wedne
"Dickon Newman" <[EMAIL PROTECTED]> wrote:
> 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
>
>From version 4.0.2 user can't see databases if he doesn't have permissions on these
>databases or SHOW DATABASES pr
;
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,
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.
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:[
Vladimir Trebicky <[EMAIL PROTECTED]> wrote:
> VR> What is the output of SHOW GRANTS for the users that can show list of all
> databases?
>
> Here it is:
>
> Grants for [EMAIL PROTECTED]
> GRANT CREATE TEMPORARY TABLES, LOCK TABLES ON *.* TO
> 'guru'@'localhost' IDENTIFIED BY PASSWORD '5b58234a5
Vladimir Trebicky <[EMAIL PROTECTED]> wrote:
>
> VR> What do you mean "didn't work properly'? What exactly was
> VR> wrong with mysql_fix_privilege_tables?
>
> Sorry, cannot reproduce the error. The result was that some of the
> tables were corrected, some not. Anyway, even old privilege tables
>
Vladimir Trebicky <[EMAIL PROTECTED]> wrote:
>
> I've been trying to solve this problem for a long time. Only thing
> I did when upgrading from 3.25 to 4.0.14 I took the default my.cnf. I
> did not convert the privilege tables with mysql_fix_privilege_tables.
>
> Suddenly, the mysql started to
;
Gesendet: Donnerstag, 26. Juni 2003 11:25
Betreff: Re: SHOW DATABASES user rights
> [EMAIL PROTECTED] wrote:
> > I have a MySQL server running with some users besides root, that I want to grant
> > all privileges for their own databases, but no rights for anything else.
> &g
[EMAIL PROTECTED] wrote:
> I have a MySQL server running with some users besides root, that I want to grant all
> privileges for their own databases, but no rights for anything else.
> So to say, I have a user web01 that shall be able to do whatever he wants with the
> database db01. There are mo
On Wed, Jul 25, 2001 at 03:19:03PM +0200, Sebastiaan Smit wrote:
> Hello,
>
> I'm having a problem with MySQL when it runs for a couple of
> days. At some time mysqld 'forgets' where it's databases are and
> searches for them in the mysql temp dir. (In my case /var/tmp). In
> the tmp dir there is
"Thalis A. Kalfigopoulos" wrote:
>
> I sent that reply about this 1 WEEK Back.
> Look up safe_show_databases and skip_show_databases in
>http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html
>
> regards,
> thalis
>
> On Mon, 9 Apr 2001, Fabien Salvi wrote:
>
> > Hello, is it possible to prevent us
I sent that reply about this 1 WEEK Back.
Look up safe_show_databases and skip_show_databases in
http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html
regards,
thalis
On Mon, 9 Apr 2001, Fabien Salvi wrote:
> Hello, is it possible to prevent users from seing other databases than
> the one there a
Try putting a line in your my.cnf that contains:
safe-show-database
This will only allow the user to see databases that they have permissions
for
You can optionally use skip-show-database, which will not allow the
command at all.
John Barton
Unix Systems Administrator
Primary Networks, Inc.
[EMAI
On Wed, Mar 07, 2001 at 05:38:55PM +, Greg Cope wrote:
> Paul DuBois wrote:
> >
> > I've been reading the thread about SHOW DATABASES and SHOW TABLES
> > returning lists of blank entries or no results. Just out of curiosity,
> > I upgraded my RedHat 6.2 machine from MySQL 3.23.32 to MySQL 3.
Paul DuBois wrote:
>
> I've been reading the thread about SHOW DATABASES and SHOW TABLES
> returning lists of blank entries or no results. Just out of curiosity,
> I upgraded my RedHat 6.2 machine from MySQL 3.23.32 to MySQL 3.23.33
> and found that suddenly I had the problem too! However, then
22 matches
Mail list logo
