MySQL phpMyAdmin - 错误：关系功能被禁用
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/28218491/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
phpMyAdmin - Error: relational features are disabled
提问by user3022069
When I want to create a relation between two tables in designer mode with phpMyAdmin 4.3.8, it gives me an error saying: Error: relational features are disabled! When I try it with 4.1.4, it works just fine. I can't seem to find where I should change the settings to be able to create relations in designer mode. Any idea? Thanks in advance!
当我想使用 phpMyAdmin 4.3.8 在设计器模式下创建两个表之间的关系时，它给了我一个错误消息：错误：关系功能被禁用！当我用 4.1.4 尝试它时，它工作得很好。我似乎找不到应该在哪里更改设置才能在设计器模式下创建关系。任何的想法？提前致谢！
回答by Mwangi Thiga
Convert your table/db engine to InnoDB using
使用将您的表/数据库引擎转换为 InnoDB
ALTER TABLE table_name ENGINE=InnoDB;
回答by user3022069
I had the same issue, it was because I didn't have a database on the mysql server for pypMyAdmin settings.
我遇到了同样的问题，这是因为我在 mysql 服务器上没有用于 pypMyAdmin 设置的数据库。
So you may need to update your PMA settings database or create one...
因此，您可能需要更新 PMA 设置数据库或创建一个...
There is a guide on how to do it here
这里是如何做到这一点的指南在这里
回答by Nour
I have faced the same error I didn't create any PMA Users I just upgraded the version of phpmyadmin to latest version and everything worked just fine
我遇到了同样的错误我没有创建任何 PMA 用户我只是将 phpmyadmin 的版本升级到最新版本，一切正常
here is the link for downloading and for me it was 4.6.0
这是下载链接，对我来说是 4.6.0
https://www.phpmyadmin.net/downloads/
https://www.phpmyadmin.net/downloads/
and for me I was working on MAMP Pro so I just did :
对我来说，我在 MAMP Pro 上工作，所以我做了：
- I stopped the server (MAMP Pro).
- I copied the file (config.inc.php) from the old phpmyadmin folder to the new one.
- I replaced the older version with the new one in ("/Applications/MAMP/bin/").
- I copied the same new version folder to ("/Library/Application Support/appsolute/MAMP PRO/") because I am working with MAMP Pro not MAMP.
- And then I restarted the server (MAMP Pro ) and everything worked just fine.
- 我停止了服务器（MAMP Pro）。
- 我将文件 (config.inc.php) 从旧的 phpmyadmin 文件夹复制到新文件夹中。
- 我用（“/Applications/MAMP/bin/”）中的新版本替换了旧版本。
- 我将相同的新版本文件夹复制到 ("/Library/Application Support/appsolute/MAMP PRO/")，因为我使用的是 MAMP Pro 而不是 MAMP。
- 然后我重新启动了服务器（MAMP Pro），一切正常。
I hope it will work for you as well.
我希望它也适用于你。
