phpMyAdmin hides mysql and information_schema database_PHP tutorial

The mysql and information_schema databases in the mysql server are system databases. This is of little use to us, but we cannot delete them. They are critical, so how to hide the mysql and information_schema databases? Next we Let’s look at ways to hide them.

Content collected in this article:

• phpMyAdmin hides multiple databases (information_schema|mysql|test)
• phpMyAdmin prohibits/does not allow users to change passwords

phpMyAdmin hides multiple databases information_schema|mysql|test

Edit/libraries/config.default.php

Hide a single database:

The code is as follows

代码如下	复制代码
$cfg['Servers'][$i]['hide_db'] = 'information_schema'

Copy code

代码如下	复制代码
$cfg['Servers'][$i]['hide_db'] = '(information_schema|mysql|test)'

$cfg['Servers'][$i]['hide_db'] = 'information_schema'

Hide multiple databases:

The code is as follows

Copy code

代码如下	复制代码
$cfg['ShowChgPassword'] = false;

$cfg['Servers'][$i]['hide_db'] = '(information_schema|mysql|test)'

#If you want to hide all databases starting with hf, you can use '^hf'. If you want to hide a list, you can use

Use the form '(database|database|...)' #Supplement: version 3.3.3 or above phpMyAdmin prohibits/does not allow users to change passwords

The code is as follows	Copy code
$cfg['ShowChgPassword'] = false; http://www.bkjia.com/PHPjc/633114.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/633114.htmlTechArticleThe mysql and information_schema databases in the mysql server are system databases. This is of little use to us, but We can't delete them, they are key...