Xampp 1.8.3.3和phpmyadmin 4.1.8 phpMyAdmin配置存储未完全配置 [英] Xampp 1.8.3.3 with phpmyadmin 4.1.8 phpMyAdmin configuration storage is not completely configured
问题描述
并安装了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 ['服务器'] [$ i] ['用户'] ...不好[文档]
$cfg['Servers'][$i]['users'] ... not OK [ Documentation ]
$ cfg ['服务器'] [$ i] ['用户组'] ...不好[文档] 可配置菜单:已禁用
$cfg['Servers'][$i]['usergroups'] ... not OK [ Documentation ] Configurable menus: Disabled
$ cfg ['服务器'] [$ 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 文件中:
Then, add the following lines into your config.inc.php file:
$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.
这篇关于Xampp 1.8.3.3和phpmyadmin 4.1.8 phpMyAdmin配置存储未完全配置的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!