PMA 数据库 ... 在 phpMyAdmin 升级中不行 [英] PMA Database ... not OK in phpMyAdmin upgrade

问题描述

我刚刚在我的 Win8 PC IIS localhost 上与 phpMyAdmin 和 MySQL 服务器争论不休(它们之间没有连接，我认为这是由于 MySQL 服务未启动，所以我重新安装了 MySQL 并重新运行了配置设置并重新建立了连接他们之间，解决了这个问题).

I have just been wrangling with phpMyAdmin and MySQL server on my Win8 PC IIS localhost (there was no connection between these, which I think was due to MySQL service not starting so I reinstalled MySQL and reran the config setup and reestablished a connection between them, which fixed that).

然而，phpMyAdmin 建议我通过用新版本覆盖文件并包括以前的配置文件来进行更新.

However phpMyAdmin advised an update which I did by overwriting the files with the new version and including the previous config file.

我现在有:
phpMyAdmin 配置存储没有完全配置好，一些扩展功能已经停用.要了解原因，请单击此处.
然后点击我得到
PMA 数据库...不行 [文档]
禁用一般关系功能
当我点击链接时，我得到一个 http 404 页面，它给出了这个:

I now have:
The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. To find out why click here.
and on clicking I get
PMA Database ... not OK [ Documentation ]
General relation features Disabled
When I click the link I get a http 404 page which gives this:

Physical path C:inetpubwwwrootphpMyAdminpmadb

那么 phpMyAdmin 中的 pmadb 是什么，我应该为此烦恼吗?就目前而言，我有点厌倦了不得不花时间调整所有这些(即它不是一个顺利的无故障事件/安装).是旧版本的数据库还是什么?我不认为我创造了它！

So what is the pmadb in phpMyAdmin and should I be bothered by this? As it stands I'm a bit fed up at having to have had to spend time tweaking all of this (ie it has not been a smooth trouble free event/install). Is it some DB for the old version or what? I do not think I created it!

我对此并不感到很困扰，因为希望我可以为我的 localhost IIS 网站设置我的数据库并继续使用我的 webdeverry(!) 但我真的不喜欢这个未知错误并且不介意修复它/摆脱它.

I do not feel very bothered by this as hopefully I can setup my databases for my localhost IIS websites and press on with my webdeverry(!) but I don't really like having this unknown error and wouldn't mind fixing it/getting rid of it.

推荐答案

在我关注的同一问题上，有一些谷歌链接帮助我解决了这个问题(我应该在发帖前花更多时间谷歌搜索！).所以为了解决这个问题，我需要创建一个 phpmyadmin 数据库并导入 create_tables.sql 并分配一个具有完全权限的新用户，然后取消注释 config.inc.php 文件:

There are a few google links on this same issue that I have followed that have helped me fix this (I should have spent more time googling before posting!). So to solve the problem I needed to create a phpmyadmin database and import create_tables.sql and assign a new user with full privileges and then uncomment the config.inc.php file at:

/* 用户用来操作存储 */$cfg['Servers'][$i]['controlhost'] = '';$cfg['Servers'][$i]['controluser'] = 'phpmyadmin';

并取消注释下面的行

/* 存储数据库和表 */$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';

我还需要从新版本中添加一些行 config.sample.inc有一个很好的链接描述了我想保存但我必须清除我的浏览器缓存以重新加载 localhost/phpMyAdmin 这样做我丢失了我的历史记录 &那个链接！

I also needed to add some lines from the new version config.sample.inc There was a good link describing this I wanted to save but I had to clear my browser cache to reload localhost/phpMyAdmin and in doing so I lost my history & that link!

我知道这个解释没有被完全描述，但我希望它可以帮助任何在更新 phpMyAdmin 后遇到类似问题的人.我仍然不确定所有这些功能的作用，但现在都已修复，谢谢！

I know this explanation is not exactly described but I hope it may help anyone else who gets a similar issue after updating phpMyAdmin. I'm still not sure what all these features do but it is all fixed now, thanks!

这篇关于PMA 数据库 ... 在 phpMyAdmin 升级中不行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！