[FIXED] How to enable relation view in phpmyadmin

Issue

When working in XAMPP with phpmyadmin, after creating a table I have the option to click "relation view" after clicking on the structure tab. See below:

However anytime when I create a table with my host phpmyadmin, I dont have the option to select "relation view" See below:

Is there anyway of enabling this? Currently I have to set up relationships in xampp and export to my host phpmyadmin for it to work.

Solution

Change your storage engine to InnoDB by going to Operation

Answered By - Harley