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...
|
|
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
