mysql pmadb_mysql – phpMyAdmin配置存储未完全配置

OP’s answer：

我用以下方法解决了这个问题：

cd /usr/share/doc/phpmyadmin/examples

sudo gunzip create_tables.sql.gz

mysql -u root -p < create_tables.sql

mysql -u root -p -e 'GRANT SELECT, INSERT, DELETE, UPDATE ON phpmyadmin.* TO 'pma'@'localhost' IDENTIFIED BY "pmapassword"'

然后在这些行上编辑/etc/phpmyadmin/config.inc.php：

/* Optional: User for advanced features */

$cfg['Servers'][$i]['controluser'] = 'pma';

$cfg['Servers'][$i]['controlpass'] = 'pmapassword';

在phpmyadmin中重新登录,然后警告消息消失了.

另请注意,您可能有关于未完全配置的phpmyadmin存储的新警告.这可能是因为您需要告诉phpmyadmin表的名称以使用它们的功能.这可以在这行上编辑/etc/phpmyadmin/config.inc.php：

$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';

注意双下划线__.