php 7のアップグレード後、phpmyadminで問題が発生しました.
2892 ワード
一、問題:The mbstring extension is missing.Please check your PHP configuration.
解決:1、(ubuntu)sudo apt-get install php-mbstring
(centos)yum install php-mbstring
２、(ubuntu)sudo service httpd restart
(centos)sudo service apache2 restart
二、問題:The mcrypt extension is missing.Please check your PHP configuration.
解決:1、sudo apt-get install php 7.0-mcrypt
２、sudo service apache2 restart
三、問題:
The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. To find out why click here.
解決:
I solved this problem with the following :
cd/usr/share/doc/phpmyadmin/examplessudo gunzip create_tables.sql.gz mysql -u root -p < create_tables.sql
Edited /etc/phpmyadmin/config-db.php on this lines:
$dbname='phpmyadmin';
Then edited /etc/phpmyadmin/config.inc.php on these lines :
/* Optional: User for advanced features */$cfg['Servers'][$i]['controluser'] = 'pma';$cfg['Servers'][$i]['controlpass'] = 'pmapassword';
Logged back in phpmyadmin, and then, the warning message had disappeared.
Also note that you may have a new warning about phpmyadmin storage not completely configured. This can be caused because you need to tell phpmyadmin the name of the tables to use their features. That can be done editing /etc/phpmyadmin/config.inc.php on this lines:
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';$cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';$cfg['Servers'][$i]['relation'] = 'pma__relation';$cfg['Servers'][$i]['table_info'] = 'pma__table_info';$cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';$cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';$cfg['Servers'][$i]['column_info'] = 'pma__column_info';$cfg['Servers'][$i]['history'] = 'pma__history';$cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';$cfg['Servers'][$i]['tracking'] = 'pma__tracking';$cfg['Servers'][$i]['designer_coords'] = 'pma__designer_coords';$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';$cfg['Servers'][$i]['recent'] = 'pma__recent';Note the double underscore __
特に、元のpmaの後ろには下線が付いていて、2つに変更します.
In Short, whatever is the missing component error showing up just Add:
$cfg['Servers'][$i][COMPONENT] = 'pma__COMPONENT';
in /etc/phpmyadmin/config.inc.php
phpmyadminで問題名の最後の単語hereをクリックすると、$cfg['Servers'][$i][COMPONENT]not okが表示され、/etc/phpmyadmin/config.inc.phpに$cfg['Serbs'][i][COMPONENT]='pma__を1行追加COMPONENT';
解決:1、(ubuntu)sudo apt-get install php-mbstring
(centos)yum install php-mbstring
２、(ubuntu)sudo service httpd restart
(centos)sudo service apache2 restart
二、問題:The mcrypt extension is missing.Please check your PHP configuration.
解決:1、sudo apt-get install php 7.0-mcrypt
２、sudo service apache2 restart
三、問題:
The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. To find out why click here.
解決:
I solved this problem with the following :
cd/usr/share/doc/phpmyadmin/examplessudo gunzip create_tables.sql.gz mysql -u root -p < create_tables.sql
Edited /etc/phpmyadmin/config-db.php on this lines:
$dbname='phpmyadmin';
Then edited /etc/phpmyadmin/config.inc.php on these lines :
/* Optional: User for advanced features */$cfg['Servers'][$i]['controluser'] = 'pma';$cfg['Servers'][$i]['controlpass'] = 'pmapassword';
Logged back in phpmyadmin, and then, the warning message had disappeared.
Also note that you may have a new warning about phpmyadmin storage not completely configured. This can be caused because you need to tell phpmyadmin the name of the tables to use their features. That can be done editing /etc/phpmyadmin/config.inc.php on this lines:
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';$cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';$cfg['Servers'][$i]['relation'] = 'pma__relation';$cfg['Servers'][$i]['table_info'] = 'pma__table_info';$cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';$cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';$cfg['Servers'][$i]['column_info'] = 'pma__column_info';$cfg['Servers'][$i]['history'] = 'pma__history';$cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';$cfg['Servers'][$i]['tracking'] = 'pma__tracking';$cfg['Servers'][$i]['designer_coords'] = 'pma__designer_coords';$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';$cfg['Servers'][$i]['recent'] = 'pma__recent';Note the double underscore __
特に、元のpmaの後ろには下線が付いていて、2つに変更します.
In Short, whatever is the missing component error showing up just Add:
$cfg['Servers'][$i][COMPONENT] = 'pma__COMPONENT';
in /etc/phpmyadmin/config.inc.php
phpmyadminで問題名の最後の単語hereをクリックすると、$cfg['Servers'][$i][COMPONENT]not okが表示され、/etc/phpmyadmin/config.inc.phpに$cfg['Serbs'][i][COMPONENT]='pma__を1行追加COMPONENT';