Can you hide tables from a MySQL user in phpMyAdmin?

Posted by AK on Stack Overflow See other posts from Stack Overflow or by AK
Published on 2010-03-12T19:50:38Z Indexed on 2010/03/12 20:07 UTC
Read the original article Hit count: 249

Filed under:
|

I have a MySQL user added to a database that I would like to prevent from viewing certain tables.

I can limit their privileges through MySQL by preventing them from running statements like DROP or ALTER. But is it possible to prevent them from viewing certain tables in phpMyAdmin?

If there isn't a MySQL privilege that controls this (I wouldn't imagine there would be), is there a configuration in phpMyAdmin that allows this?

I understand one workaround here is to move the tables to a new database that they're not added to. This isn't an option for my application.

© Stack Overflow or respective owner

Related posts about phpmyadmin

Related posts about mysql