PhpMyAdmin hides mysql and information_schema databases

Mysql and information_schema databases on the mysql server are system databases, which is of little use to us, but they cannot be deleted.

Mysql and information_schema databases on the mysql server are system databases, which is of little use to us, but they cannot be deleted, so how can we hide mysql and information_schema databases? let's take a look at how to hide them.

Content collected in this article:

PhpMyAdmin hides multiple databases (information_schema | mysql | test)

PhpMyAdmin prohibits/disallows users to change passwords

PhpMyAdmin hides information_schema from multiple databases | mysql | test

Edit/libraries/config. default. php

Hide a single database,The code is as follows:

$ Cfg ['servers'] [$ I] ['hide _ db'] = 'information _ scheme'

The code for hiding multiple databases is as follows:

$ Cfg ['servers'] [$ I] ['hide _ db'] = '(information_schema | mysql | test )'

# To hide all databases starting with hf, you can use '^ hf'. to hide a list, you can use '(database | ...)'.

# Supplement: version 3.3.3 and later

PhpMyAdmin prohibits/disallows users to change passwords. the code is as follows:

$ Cfg ['showchgpassword'] = false;