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]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.