Ok, I figured it out.
My scenario
Had "Deactivate show databases" checked, so users got access denied error
when trying to exec show databases.
Granted show databases to a user, and now they see all of the databases.
New Scenario
Unchecked "Deactivate show databases"
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.
&g
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 question.
John
--
MyS
ens.
I'll post back with results.
Thanks for all the advice,
Waynn
On 3/8/08, Baron Schwartz <[EMAIL PROTECTED]> wrote:
> Hi,
>
> On Sat, Mar 8, 2008 at 6:58 AM, Waynn Lue <[EMAIL PROTECTED]> wrote:
> > SHOW DATABASES; shows that I have a database called "
Hi,
On Sat, Mar 8, 2008 at 6:58 AM, Waynn Lue <[EMAIL PROTECTED]> wrote:
> SHOW DATABASES; shows that I have a database called "test", but when I
> call "DROP DATABASE test", I get
>
> ERROR 1008 (HY000): Can't drop database 'test'; datab
:58 AM, Waynn Lue <[EMAIL PROTECTED]> wrote:
> SHOW DATABASES; shows that I have a database called "test", but when I
> call "DROP DATABASE test", I get
>
> ERROR 1008 (HY000): Can't drop database 'test'; database doesn't exist
>
Waynn-
does the OS user you use to execute mysql have create/write/read/execute
rights to the ./test folder?
Martin-
- Original Message -
From: "Waynn Lue" <[EMAIL PROTECTED]>
To:
Sent: Saturday, March 08, 2008 6:58 AM
Subject: Can't drop database that shows
SHOW DATABASES; shows that I have a database called "test", but when I
call "DROP DATABASE test", I get
ERROR 1008 (HY000): Can't drop database 'test'; database doesn't exist
When I run any queries on that database, I get errors like:
mysql> select *
Bummer! I was hoping that you'd see what actually gets executed
during a SHOW DATABASES, like "select * from user, table_privs where
" so you could then run an EXPLAIN on it.
For me on 5.0.21 EXPLAIN SHOW DATABASES gives me an error so no joy there.
I suspect you've go
ECTED]: X[X] @ nico.abc.loc [192.168.0.34]
# Query_time: 20 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
show databases;
Perhaps the tables_priv table could use an
additional index, if OPTIMIZE doesn't do the trick.
Hope this helps.
Dan
done, but still no improvement :(
Thanks for
could use an
additional index, if OPTIMIZE doesn't do the trick.
Hope this helps.
Dan
On 8/23/06, Nico Sabbi <[EMAIL PROTECTED]> wrote:
Hello,
as the title reads, when a user X with access to few tables runs "show
databases"
the query executes _very_ slowly and there
Hello,
as the title reads, when a user X with access to few tables runs "show
databases"
the query executes _very_ slowly and there's a sudden HUGE load (mysqld
takes 99% cpu for the whole
duration of the query):
show databases;
+-
ct as root or as a standard user that has
only privileges for one database.
If you set no-auto-rehash in the cnf then show databases will be fast
again as root.
It still takes ages as a normal user though.
e.g.
mysql -uroot -p
mysql> show databases;
...
+--+
55693 rows in s
On 4/21/06, Nico Sabbi <[EMAIL PROTECTED]> wrote:
> the more databases a user has the less time it takes to execute "show
> databases" and vice versa:
If no rows in `show databases` output appear because some user has
some table/columns privs but no db privs for a databa
On 4/21/06, Nico Sabbi <[EMAIL PROTECTED]> wrote:
> Is this behaviour due to a bug or maybe my mysql tables are messed up?
I'm not sure if we can call it a bug. But spending 8 seconds (and
using 100% CPU) for a simple SHOW DATABASES query is a bit too much,
and should be fixed.
Hi,
I have a strange and annoying problem with Mysql 4.0.26 that I hope
someone will help me to fix:
the more databases a user has the less time it takes to execute "show
databases" and vice versa:
show databases;
+--+
5 rows in set
On 1/9/06, Logan, David (SST - Adelaide) <[EMAIL PROTECTED]> wrote:
>
> True, however you could run the perl script locally via another
> mechanism and allow it to return the database info in the format that
> you desire, or run it using the mysql -e &
True, however you could run the perl script locally via another
mechanism and allow it to return the database info in the format that
you desire, or run it using the mysql -e 'show databases' -u
local_user_that_doesn't_need_a_password
The other option is to use an ssh tunnel t
On 1/9/06, Logan, David (SST - Adelaide) <[EMAIL PROTECTED]> wrote:
>
> Hi Anthony,
>
> If you are accessing the db from perl, just execute a show databases
> from there using the DBI interface. There is quite an amount of doco
> about this and other features at cpan.org
Hi Anthony,
If you are accessing the db from perl, just execute a show databases
from there using the DBI interface. There is quite an amount of doco
about this and other features at cpan.org. You could also look at the
source for phpMyadmin as this has to get the database names to display
them
'SHOW DATABASES;' | mysql -u foo -h bar.com
this works, I haven't tested it with other databases though.
On 1/9/06, Mikhail Berman <[EMAIL PROTECTED]> wrote:
>
> Hi Anthony,
>
> I am not sure if you have an installation of MySQL on your local server.
> If you
Hi Anthony,
I am not sure if you have an installation of MySQL on your local server.
If you do then you can try to use something like below to execute your
"SHOW DATABASES"
Local_server>[path to your mysql/bin directory]/mysql
--host=your_remote_host --user=your_user --password=you
I know I can login via ssh and run $mysqlshow
But I would then have to parse the outputted text, is there an easier way
(I'm using Perl locally here).
The pitfall of running it locally is that you DO have to password protect
your database user since it's an outside connection to
applies to any database.
Well, some privileges are strictly global, but should not affect SHOW DATABASES.
The FILE privilege is one example. In any case, you are right about "CREATE
TEMPORARY TABLES ON *.*" causing all dbs to show up. I should have suggested
REVOKE CREATE TEMP
Hello.
If all your users has 'SHOW DATABASES' privilege, it is normal behavior.
However, probably, it is not you want. You may want to
update the grant tables manually and revoke this privilege from your
users.
BÁRTHÁZI András wrote:
> Hi,
>
> When I migrated from
id everything listed there, except I
didn't dumped and imported all my tables. Maybe
missed something, but don't know what. I ran
the mysql_fix_privilege_tables when I was
running MySQL 5.0, but I don't think it's
important.
The default in 4.0 and higher is to only show
databa
imported all my tables. Maybe missed something, but don't know what. I
ran the mysql_fix_privilege_tables when I was running MySQL 5.0, but I
don't think it's important.
The default in 4.0 and higher is to only show databases for which a
user has privileges, but this can be ov
es. Maybe missed something, but don't know what. I
ran the mysql_fix_privilege_tables when I was running MySQL 5.0, but I
don't think it's important.
The default in 4.0 and higher is to only show databases for which a user
has privileges, but this can be overridden for an individual
you follow the upgrade instructions in the manual
<http://dev.mysql.com/doc/refman/5.0/en/upgrade.html>? If you did, then the
problem is probably with user privileges.
The default in 4.0 and higher is to only show databases for which a user has
privileges, but this can be overridden for an
Hi,
When I migrated from 3.23 to 4.0 version (if I'm remember well), I think
I missed to upgrade something, so all my MySQL users are able to see the
list of the databases on my server. Currently, the MySQL version is
5.0.15, i ran the mysql database upgrade script, but it still is a
problem.
nux Fedora 2 with mysqld running as a daemon and the service mysql
running (/etc/rc.d/init.d/).
I have two shell sessions (mysql client) running one with root and the other
with a user.
I did (as root) : grant all privileges on mydb to [EMAIL PROTECTED];
in the root session the show databases; retu
databases; return 3 databases (test, mysql, mydb)
in the user session the show databases; return 1 database (test)
what is going on?
thanks
laurie
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
In the last episode (Jan 15), Justin Lundy said:
> When I open over nine connections to mysql I see vi.recover in my show
> databases output. The existing connections stay open and continue to
> operate. No new database connections can be made at this point. I should
> be seei
When I open over nine connections to mysql I see vi.recover in my show
databases output. The existing connections stay open and continue to
operate. No new database connections can be made at this point. I should
be seeing the mysql, phpdig and test databases when performing the query
but I
chael 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
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 there a way I can show only those databases that he has rights to
without giving him rights to
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 conne
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 there a way I can show only those databas
SHOW DATABASES is a global privilege. It allows the named user to see (with
SHOW DATABASES) dbs he/she cannot work with. If that's really what you
want, the syntax for your 4th line would be:
GRANT SHOW DATABASES ON *.* TO [EMAIL PROTECTED]
You use *.* instead of OSMS.* because th
ION;
GRANT ALL PRIVILEGES ON OSMS.* TO osms@"%" IDENTIFIED BY 'openipmp' WITH
GRANT OPTION;
GRANT SHOW DATABASES ON OSMS.* TO [EMAIL PROTECTED] IDENTIFIED BY 'openipmp'
WITH GRANT OPTION;
GRANT SHOW DATABASES ON OSMS.* TO [EMAIL PROTECTED] IDENTIFIED BY 'openipm
On Nov 25, Christophe DIARRA wrote:
> > Hello.
> >
> > MySQL 4.1.0 is not respecting the registered privileges.
> ...
> > "show databases" displays an incorrect list of databases. Each user lists a
> > database it should not, and doesn't show all the dat
Hi!
On Nov 25, Christophe DIARRA wrote:
> Hello.
>
> MySQL 4.1.0 is not respecting the registered privileges.
...
> "show databases" displays an incorrect list of databases. Each user lists a
> database it should not, and doesn't show all the databases it should.
for all host ('%'). Each user always use the same
password for all the databases.
"show databases" displays an incorrect list of databases. Each user lists a
database it should not, and doesn't show all the databases it should.
Same thing with 'use ' : the acces
, 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 permis
;
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
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! Despit
VR> User has some privileges on the global level (CREATE
VR> TEMPORARY TABLES, LOCK TABLES). That is why user can see list of
VR> all databases.
All right! :) It works, thanks! :)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql
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
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 '5b58234a58cd6a22'
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP,
, some not. Anyway, even old privilege tables
> shouldn't IMHO cause the SHOW DATABASES to work. In addition, I
> corrected the tables manually and are ok now.
>
> VR> In 4.0.14 --safe-show-database is enabled by default.
>
> I know, another reason why I'm so confu
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
shouldn't IMHO cause the
rs, that are ok) so I did the changes manually
> conforming to source code of mysql_fix_privilege tables.
What do you mean "didn't work properly'? What exactly was wrong with
mysql_fix_privilege_tables?
>
> PhpMyAdmin stopped its warning about privilege tables not confor
ege tables.
PhpMyAdmin stopped its warning about privilege tables not conforming
to current mysql version. Everything seemed ok except that SHOW
DATABASES still worked.
The users naturally all have Show_db_priv="N" in the tables. Also
trying "safe_show_database", "skip_show_d
;
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
1. There are more databases, like db02 etc.
> If user web01 runs a 'SHOW DATABASES' command, he'll get to see ALL databases on the
> server, but I don't want him to see them... When the user does a 'USE ;', it
> says 'access denied'. There must be s
etc.
If user web01 runs a 'SHOW DATABASES' command, he'll get to see ALL databases on the
server, but I don't want him to see them... When the user does a 'USE ;', it
says 'access denied'. There must be some special trick to let him only see the
data
Hello,
I have installed mysql 4.0.13 but suddenly all users can see names of all
databases on the server in phpmyadmin (show databases command afaik)
Is there something to avoid it ???
Sincerely,
Roman
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
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
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 always the
recover directory for vi (vi.recover) so mysqld thinks that it's
mysqladmin variables
I believe it is safe_show_database or some-such.
Marco Kammerer wrote:
> 3.22.38
>
> Hello guys
>
> I figured out how I can set up different user that are able to work
> on their own dbs.
>
> here is my command to add a db and a user;
>
> GRANT SELECT, INSERT, UPDATE,
3.22.38
Hello guys
I figured out how I can set up different user that are able to work
on their own dbs.
here is my command to add a db and a user;
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON bernddb.* TO
bernduser@LOCALHOST IDENTIFIED BY '1234'
But a questions:
when I have added th
Hi,
(Sorry about my previous post: wrong list)
In 3.23.32, I can do a "show databases", no problem, it shows my 18 database names.
But with
3.23.38, with the same user, I only get 36 empty rows
for a "show databases".
Same problem with "show tables".
However,
I have had the same problem on a Redhat 7.0 box w/2.4.1 kernel with
mysql versions 3.23.32 thru 3.23.37
The tables and databases are there and are usable, but 'show databases'
and 'show tables' return nothing. We've installed this version on
another machine and
>Description:
empty show tables
>How-To-Repeat:
show tables;
>Submitter-Id:
>Originator:[EMAIL PROTECTED]
>Organization:
poelzi.org
>MySQL support: none
>Synopsis: show tables return nothing. show databases too.
>Severity: serio
"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
Hello, is it possible to prevent users from seing other databases than
the one there are using ?
I thought it was possible using priveleges and "Select_priv", but It
doesn't work...
I am using 3.23.33
Thanks in advance for your help...
-
Fabien SALVI Centre de Ressources Inform
Dear All
I got very excited today when 3.23.34 worked (i.e now show tables bug) !
I then recomplied with optimisations and then with pgcc and bug
reappears.
I am now having a go with different CFLAGS and CXXFLAGS.
Not being a C / complier / libs expert I can not comment any further !
How weir
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 mac
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 p
l 2.2.17-14
> > all 'show' commands doesn't works. They display empty tables.
> In my case error appeared in RedHat 6.2 with kernel 2.2.18. And on RedHat 7.0
> sources from www.mysql.com compliled and work pretty well.
>
> > &g
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 I remembered
tha
. They display empty tables.
In my case error appeared in RedHat 6.2 with kernel 2.2.18. And on RedHat 7.0
sources from www.mysql.com compliled and work pretty well.
> >How-To-Repeat:
> $ mysql
> mysql> show databases;
>
Richard Ellerbrock wrote:
>
> >>Description:
> > I have found the error. On Linux RedHat 7.0 with kernel 2.2.17-14
> >all 'show' commands doesn't works. They display empty tables.
> >>How-To-Repeat:
> >Install RedHat 7.0 on Intel platform, apply all updates from RedHat
> >
On Wednesday 07 March 2001 12:43, Richard Ellerbrock wrote:
> >>Description:
> >
> > I have found the error. On Linux RedHat 7.0 with kernel 2.2.17-14
> >all 'show' commands doesn't works. They display empty tables.
> >
> >>How-To-Repeat:
> >
> >Install RedHat 7.0 on Intel plat
nge results for 'show' commands:
>
> $ mysql
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 3 to server version: 3.23.33-log
>
> Type 'help;' or '\h' for help. Type '
>>Description:
> I have found the error. On Linux RedHat 7.0 with kernel 2.2.17-14
>all 'show' commands doesn't works. They display empty tables.
>>How-To-Repeat:
>Install RedHat 7.0 on Intel platform, apply all updates from RedHat
>(up to March, 01 2001), compile ker
he MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 3.23.33-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer
mys
As building process, nor system libs, may not be perfect, try using
our binaries.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /
Sinisa Milivojevic wrote:
>
> As building process, nor system libs, may not be perfect, try using
> our binaries.
Thanks Sinisa, but this does not solve the problem - I've several
machines (RedHat|SUSE|SUN) (7) that all have near identical (with
different data and binary dirs so that I can upgra
Sinisa Milivojevic wrote:
>
> HI!
>
> In response to several mail messages on mailing list that were
> centered around some misbehaviour of SHOW DATABASES / TABLES, I have
> tested thoroughly (with several --user=... options) 3.23.33 and found
> out that it works perf
Gerald L. Clark writes:
> I also rebuilt 3.23.33 today for SCO Openserver 5.0.4 and RedHat Linux
> 6.2.
> Show Databases works just fine here.
>
Thanks !
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa
I also rebuilt 3.23.33 today for SCO Openserver 5.0.4 and RedHat Linux
6.2.
Show Databases works just fine here.
Sinisa Milivojevic wrote:
>
> HI!
>
> In response to several mail messages on mailing list that were
> centered around some misbehaviour of SHOW DATABASES / TABLES,
HI!
In response to several mail messages on mailing list that were
centered around some misbehaviour of SHOW DATABASES / TABLES, I have
tested thoroughly (with several --user=... options) 3.23.33 and found
out that it works perfectly.
Causes of misbehavious can be :
- errors in building
88 matches
Mail list logo
