How to hide information_schema database from phpmyadmin

phpmyadmin wamp
Onkar Janwa picture Onkar Janwa · Aug 22, 2012 · Viewed 17.6k times · Source

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 ?

Answer

Abhishek Goel picture Abhishek Goel · Apr 15, 2017

I installed phpmyadmin in outside directory but and these methods didn't work for me.

Open phpmyadmin

Settings > Features > General > database > Hide databases

Enter Database that you want to hide as following

information_schema|performance_schema|mysql

Related questions

#1045 - Access denied for user 'root'@'localhost' (using password: YES)

This might seem redundant but I was unable to find a correct solution. I was unable to login to mysql using the mysql console.It is asking for a password and I have no clue what I actually entered.(Is …

Read More
Fix Access denied for user 'root'@'localhost' for phpMyAdmin

I'm using WAMP Server 2.2 on a PC. In phpMyAdmin (version 5.5.24) I edited the 'root' user (with 'localhost' host) and gave it a password of 'root'. This turned out to be a big mistake that I'm trying to revert. Now when …

Read More
where does MySQL store database files?

I have uninstall wamp server and now I need my database to restore. How can I do this process?

Read More