Xampp 1.8.3.3 和 phpmyadmin 4.1.8 phpMyAdmin 配置存储未完全配置

2022-01-14 00:00:00 xampp mysql phpmyadmin

并安装了xampp phpmyadmin，当我进入以下跳转

and installed the xampp phpmyadmin and when I entered the following jump

phpMyAdmin 配置存储未完全配置，部分扩展功能已停用.要找出原因，请单击此处.

The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. To find out why click here.

然后点击显示，这里是错误

and click show and here is errors

$cfg['Servers'][$i]['users'] ... 不正常 [ 文档 ]

$cfg['Servers'][$i]['users'] ... not OK [ Documentation ]

$cfg['Servers'][$i]['usergroups'] ... 不正常 [ 文档 ]可配置菜单:已禁用

$cfg['Servers'][$i]['usergroups'] ... not OK [ Documentation ] Configurable menus: Disabled

$cfg['Servers'][$i]['navigationhiding'] ... 不行 [ 文档 ]隐藏/显示导航项:已禁用

$cfg['Servers'][$i]['navigationhiding'] ... not OK [ Documentation ] Hide/show navigation items: Disabled

如何解决?

推荐答案

在 phpmyadmin 数据库中运行以下查询:

Run the following query in the phpmyadmin database:

CREATE TABLE IF NOT EXISTS `pma_users` (
  `username` varchar(64) NOT NULL,
  `usergroup` varchar(64) NOT NULL,
  PRIMARY KEY (`username`,`usergroup`)
) 
  COMMENT='Users and their assignments to user groups'
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

CREATE TABLE IF NOT EXISTS `pma_usergroups` (
  `usergroup` varchar(64) NOT NULL,
  `tab` varchar(64) NOT NULL,
  `allowed` enum('Y','N') NOT NULL DEFAULT 'N',
  PRIMARY KEY (`usergroup`,`tab`,`allowed`)
) 
  COMMENT='User groups with configured menu items'
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

CREATE TABLE IF NOT EXISTS `pma_navigationhiding` (
  `username` varchar(64) NOT NULL,
  `item_name` varchar(64) NOT NULL,
  `item_type` varchar(64) NOT NULL,
  `db_name` varchar(64) NOT NULL,
  `table_name` varchar(64) NOT NULL,
  PRIMARY KEY (`username`,`item_name`,`item_type`,`db_name`,`table_name`)
) 
  COMMENT='Hidden items of navigation tree'
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

<小时>

然后，将以下行添加到您的 config.inc.php 文件中:

$cfg['Servers'][$i]['users'] = 'pma_users';
$cfg['Servers'][$i]['usergroups'] = 'pma_usergroups';
$cfg['Servers'][$i]['navigationhiding'] = 'pma_navigationhiding';

<小时>

然后，退出 phyMyAdmin 并重新登录.

Then, log out of phyMyAdmin and log back in.

注意:您可能还需要创建一个pma"用户并授予对phpmyadmin"数据库的所有权限.

NOTE: You may also need to create a 'pma' user and grant all permissions on the 'phpmyadmin' database.

相关文章