phpMyAdmin�Łwinformation_schema�x�Ȃǂ��\���ɂ�����@

MySQL�ł́A������ԂŁwinformation_schema�x�A�wmysql�x�A�wtest�x�A�wperformance_schema�x�Ȃǂ��쐬����܂��B
�winformation_schema�x�͏��X�L�[�}�ƌĂ΂�A�f�[�^�x�[�X�Œ�`���ꂽ��񂪊i�[����Ă��܂��B
���X�L�[�}�͕W��SQL�Œ�`����Ă�����̂ŁAPostgreSQL�ȂǑ���RDBMS�Ƌ��ʉ����邽�߂ɑ��݂��܂��B

���́winformation_schema�x�͒ʏ�A��ʂ̃��[�U�[�ɂ͉{���Ȃǂ����邱�Ƃ��Ȃ����̂ł����A �ǂ̃��[�U�[�ɂ��A�N�Z�X���錠��������̂�phpMyAdmin�ł��f�[�^�x�[�X�̈ꗗ�ɕ\��������܂��B

���̃f�[�^�x�[�X���ꗗ�ɕ\�����������Ȃ��ꍇ��config.inc.php�Łwhide_db�x���g���܂��B

config.inc.php

$cfg['Servers'][$i]['hide_db'] = "(^information_schema$|^performance_schema$|^test$)";


�whide_db�x���g�p�����ꏊ�͎��̂悤�ɂȂ��Ă��܂��B

/libraries/List_Database.class.php 85�s��

protected function _checkHideDatabase()
{
    if (empty($GLOBALS['cfg']['Server']['hide_db'])) {
        return;
    }

    foreach ($this->getArrayCopy() as $key => $db) {
        if (preg_match('/' . $GLOBALS['cfg']['Server']['hide_db'] . '/', $db)) {
            $this->offsetUnset($key);
        }
    }
}

�whide_db�x�𐳋K�\���̃p�^�[���Ƃ��Ďg�p���āA��v����f�[�^�x�[�X���\���Ƃ��Ă��܂��B

�������ꗗ�����\���ƂȂ邾���ŁA�A�N�Z�X���邱�Ƃ͂ł��܂��B
�winformation_schema�x�́A���ׂẴ��[�U�[����Q�Ƃ����K�v�����邽��GRANT�ȂǂŃA�N�Z�X�ł���f�[�^�x�[�X�����肵�Ă������I�ɃA�N�Z�X�����t�^����܂��B

SHOW DATABASES;
SHOW TABLES FROM information_schema;

�̂悤��SQL���ł͎Q�Ƃ��邱�Ƃ��ł��܂��B

�֘A�L��

�X�|���T�[�����N

�����R�[�h�\(EUC-JP) [6000/12836]

�z�[���y�[�W����Eweb�n�A�v���n�̐���Č���W���ł��B

��ɖ߂�