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.
我现在有:
The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. To find out why click here.
然后点击我得到
PMA Database ... not OK [ Documentation ]
General relation features Disabled
当我单击链接时，我得到一个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:\inetpub\wwwroot\phpMyAdmin\pmadb
那么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!
我对此并不感到很困扰，因为我希望可以为我的本地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.
推荐答案
在我关注的同一问题上，有一些google链接可以帮助我解决此问题(在发布之前，我应该花更多的时间进行谷歌搜索！).因此，要解决该问题，我需要创建一个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:
/* User used to manipulate with storage */
$cfg['Servers'][$i]['controlhost'] = '';
$cfg['Servers'][$i]['controluser'] = 'phpmyadmin';
/* User used to manipulate with storage */
$cfg['Servers'][$i]['controlhost'] = '';
$cfg['Servers'][$i]['controluser'] = 'phpmyadmin';
和下面的取消注释行
/* Storage database and tables */
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
/* Storage database and tables */
$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屋！
