phpMyAdmin配置存储未完全配置,某些扩展-Xampp- Version -7.3.8-0-VC 15

zujrkrfu  于 2022-11-09  发布在  PHP
关注(0)|答案(1)|浏览(139)

我更新了Xampp版本-最新版本= 7.3.8-0-VC 15我收到这些错误-
错误1-

The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. Find out why.

我点进去想知道为什么,但不明白--
错误2 -

mysqli_real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)

错误3-

Connection for controluser as defined in your configuration failed.

我尝试了许多解决方案,但没有解决。

xdnvmnnf

xdnvmnnf1#

这是一个错误,因为缺少默认phpmydamin数据库的一些默认表。要解决这个错误,您必须在***phpmyadmin数据库***中运行以下查询
我建议您下载并安装JetBrains DataGrip,并将此软件与您的本地数据库连接,并在其上运行以下查询以修复phpmyadmin问题。另一种方法是,如果您对命令行友好,请使用命令行登录到mysql并运行查询。

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

相关问题