Menu
I am able to hide the database from writing this line
$cfg['Servers'][$i]['hide_db'] = 'information_schema'; in config.inc.php file pf phpmyadmin.
It is possible to access content of this database through url like http://www.test.com/phpmyadmin/index.php?db=information_schema&token=3ba37ae1e41f6a10e4afc7c69b934bba
How is it possible to remove complete access of information_schema database ?
885
Although you can query tables in the information_schema database, you cannot modify them. You also cannot delete the information_schema database.
INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access privileges. Other terms that are sometimes used for this information are data dictionary and system catalog.
To revoke the SHOW DATABASES privilege, we can simply uncheck the box beside the SHOW DATABASES label, and click the Save button. There, we can set also database-specific privileges such as those to create views, show views, drop tables, execute INSERT statements, etc.
Once a table is hidden, a light bulb or eye (depending on version) should appear next to the database name. Click on that, and it will bring up a dialog box with the hidden tables, allowing you to unhide (show) them.
Follow these steps:
|), i.e.: information_schema|performance_schema|mysql|phpmyadmin As per KeshV's comments below, depending on your operating system (Linux, Windows etc.) and environment configuration you may need to have config.inc.php file writable in order to have above changes persistent between server or browser restarts.
However, on some configurations and in certain phpMyAdmin versions the above settings are stored directly in cookie and are preserved even though noting is added to config.inc.php file.
172
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
