CODEWITHSUNDEEP
phpmysqldatabasephpmyadmininnodb
serverNewbie
serverNewbie

Reputation: 55

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.

Upvotes: 0

Views: 2449

Answers (3)

GalaxyWeb
GalaxyWeb

Reputation: 1

It turns out all you need to do is import create_tables.sql from phpMyAdmin. create_tables.sql is currently found under /Library/Application Support/appsolute/MAMP PRO/phpMyAdmin/sql for mamp pro users. For mamp users it's under /Applications/MAMP/bin/phpMyAdmin/sql. Note that the file location seems to change form versions to versions.

Upvotes: 0

underflow
underflow

Reputation: 483

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

Upvotes: 2

serverNewbie
serverNewbie

Reputation: 55

Finally resolved this, it appears there are a number of prerequisites that need to be done when using MAMP on the MAC. Including:

  1. Import the phpmyadmin database which is found in Mamp/Bin/PhpMyAdmin/Example/Create_Tables.sql. Go to the import tab and select this file.
    1. Create a pma user account by clicking on the database then click user. Details can be found in the link provided.
    2. Update config.inc.php in phpMyAdmin. Details can be found in the link provided.
    3. Restart your MAMP servers

Link:http://foundationphp.com/tutorials/pma_config.php

Upvotes: 0

Related Questions