Search code examples
phpmysqldatabasephpmyadmininnodb

How to enable "Relation view" feature in PHPMyAdmin


I am trying to establish Foreign Key relationships between a number of tables but cannot find the "Relation view" option. I have ensured my database and the relevant tables are using InnoDB.

I am using a Mac with MAMP and using PHPMyAdmin to manage my database.

I have tried a number of tutorials but have been unsuccessful including: Enabling bookmarks and other advanced features in phpMyAdmin.


Solution

  • Check out this tutorial, I found this helpful and also includes some configuration files which may be of use http://www.lynda.com/phpMyAdmin-tutorials/Setting-up-foreign-key-constraint/144202/157544-4.html