Possible to hide names in Mysql when a client use MySQLCC

[Coolaid]

My client said that he can see all bases on my Mysql server witch MySQL Control Center (MySQLCC)
Is it possible to block it ?

Tanx in advance ...

 

[sleipnir214]

It should be that a user can only see those databases to which he has permissions.

What permissions are you assigning your clients?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[Coolaid]

When you connect with MySqlCC you first see all the bases ... you must double-click on your base and after it ask the "authentification".
Here are the permissions ...

y Select_priv
y Insert_priv
y Update_priv
y Delete_priv
y Create_priv
y Drop_priv
n Grant_priv
n References_priv
y Index_priv
y Alter_priv

Tanx ..

 

[Coolaid]

Up was the permission of the base.
Permission of user are all No ...

 

[sleipnir214]

The permissions in what table in the mysql database?

I have a database "test", and a user "test" that has full permissions, but only to that database. This user can only see the "test" database.

In the "user" table, the permissions entries for "test" are all "N".

In the "db" table, I have an entry for the user "test" that shows the table "test" and everything but GRANT permissions.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[Coolaid]

Same to me ... maybe its on the "host" table
Exemple :
Host : %
Db : test

y Select_priv
y Insert_priv
y Update_priv
y Delete_priv
y Create_priv
y Drop_priv
n Grant_priv
n References_priv
y Index_priv
y Alter_priv

 

[sleipnir214]

Okay, you've given me the contents of one unspecified table in the mysql database. Not really helpful.

Permissions are defined in multiple tables. This is why I described the contents of two specific tables in the mysql database and specified which data came from where.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!