Show_db_priv ignored
Wouter de Jong <[email protected]>
| Newsgroups | gmane.comp.db.mysql.bugs |
|---|---|
| Message-ID | <[email protected]> |
Hello, We have MySQL 4.0.18 (Linux, source-compiled) running on some servers, and for some reason it ignores the Show_db_priv --------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ | Host | User | password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | +-----------------+----------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ | 212.204.254.% | almetaal | 60a1476777a54240 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | Y | Y | N | N | N | | | | | 0 | 0 | 0 | As you can see, Show_db_priv is 'N', but I can still view _ALL_ databases: mysql> \s -------------- mysql Ver 12.22 Distrib 4.0.18, for pc-linux (i686) Connection id: 46729 Current database: almetaal1 Current user: [email protected] SSL: Not in use Current pager: stdout Using outfile: '' Server version: 4.0.18 - WideXS Protocol version: 10 Connection: db.widexs.nl via TCP/IP Client characterset: latin1 Server characterset: latin1 TCP port: 3306 Uptime: 25 min 53 sec Threads: 22 Questions: 574857 Slow queries: 0 Opens: 9864 Flush tables: 3 Open tables: 512 Queries per second avg: 370.159 -------------- mysql> SHOW DATABASES; +---------------+ | Database | +---------------+ | 7parts | | Jokes | | NovaRage | | PaardenDB | | a | | actualiteiten | | adiso | | aedifex | | ahh | | airtoi | | ajaxtimpan | | alblas | | alfaleo | -- WideXS http://www.widexs.nl Wouter de Jong System-Administrator Tel +31 (0)23 5698070 Fax +31 (0)23 5698099 Bijlmermeerstraat 62, 2131 HG HOOFDDORP, NL -- MySQL Bugs Mailing List For list archives: http://lists.mysql.com/bugs To unsubscribe: http://lists.mysql.com/[email protected]