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;