How to Enable Relation View in phpMyAdmin?

The option Relation View is probably one of the best features available in phpMyadmin. Sometimes you are required to set foreign keys for database tables, but you do not see this Relation View option in PHPMyAdmin. When you don’t have this option enabled in PHPMyAdmin, the first thing you should verify is, your table's storage engine is set to use InnoDB. It’s because only innoDB allows the Relation View, which will help you make the foreign keys. In this article, we’ll describe the steps to change storage engine to innoDB from PHPMyAdmin.

  1. Login to phpMyAdmin.
  2. Navigate to database table whose storage engine you wish to change.
  3. Click on Operations tab, under Table options you would find drop down called Storage Engine.
  4. Select Innodb storage engine from the Storage Engine drop down and click on Go button.

    Table Options

  • 5 Users Found This Useful

Was this answer helpful?

Related Articles

How to Clone MySQL database using PhpMyAdmin?

Database clone is a process to create a separate copy of the database. You can also use it as...

How to Stop and Start MySQL Service in Windows and Linux VPS?

This article will assist you to stop and start MySQL service from Windows VPS and Linux VPS....

How to turn on/off Mysql strict mode in the Windows server?

By default in the windows server, the strict mode will be enabled on MySQL. Please refer to the...

How do I connect to MySQL server from phpMyAdmin?

This article will guide you on how to connect to MySQL server from phpMyAdmin. You can obtain...

How to generate MySQL (backup) dump from the command line in Windows VPS?

This article will assist you how to generate MySQL (backup) dump from the Command line in the...