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.
+-----------+--------+------------------+-------------+-------------+-----------
--+-------------+-------------+-----------+-------------+---------------+-------
-------+-----------+------------+-----------------+------------+------------+
| Host | User | Password | Select_priv | Insert_priv | Update_pri
v | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Proces
s_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv |
+-----------+--------+------------------+-------------+-------------+-----------
--+-------------+-------------+-----------+-------------+---------------+-------
-------+-----------+------------+-----------------+------------+------------+
| localhost | fhgweb | xxxxxxxxxxxxx | N | N | N
| N | N | N | N | N | N
| N | N | N | N | N |
+-----------+--------+------------------+-------------+-------------+-----------
--+-------------+-------------+-----------+-------------+---------------+-------
-------+-----------+------------+-----------------+------------+------------+
and from the db table...
mysql> select * from db where User like 'fhgweb';
+-----------+-------+--------+-------------+-------------+-------------+--------
-----+-------------+-----------+------------+-----------------+------------+----
--------+
| Host | Db | User | Select_priv | Insert_priv | Update_priv | Delete_
priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alt
er_priv |
+-----------+-------+--------+-------------+-------------+-------------+--------
-----+-------------+-----------+------------+-----------------+------------+----
--------+
| localhost | fhgdb | fhgweb | Y | Y | Y | Y
| N | N | N | N | N | N
|
+-----------+-------+--------+-------------+-------------+-------------+--------
-----+-------------+-----------+------------+-----------------+------------+----
--------+
1 row in set (0.01 sec)
Paul DuBois wrote:
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 there a way I can show only those databases that he has rights to without giving him rights to the mysql database to use the db table?
Make sure that the user doesn't have any global privileges that apply to databases. If the user has such a privilege, SHOW DATABASES will display all databases. (To check this, look at the privilege columns in the mysql.user table for the user's account record.)
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
