[phpMyAdmin] How to enable Designer in phpMyAdmin
February 11, 2012 26 Comments
Some times we need to create ERD. In phpMyAdmin this can be done very easily. Just you need to change some configuration.
I am assuming that you have already installed phpMyAdmin (in my case it’s 3.4.3.2 version). You have to follow these simple steps;
Step 1: Open the file
libraries/config.default.php
Step 2: Find and change these configuration like this:
$cfg[‘Servers’][$i][‘pmadb’] = ‘phpmyadmin’;
$cfg[‘Servers’][$i][‘bookmarktable’] = ‘pma_bookmark’;
$cfg[‘Servers’][$i][‘relation’] = ‘pma_relation’;
$cfg[‘Servers’][$i][‘table_info’] = ‘pma_table_info’;
$cfg[‘Servers’][$i][‘table_coords’] = ‘pma_table_coords’;
$cfg[‘Servers’][$i][‘pdf_pages’] = ‘pma_pdf_pages’;
$cfg[‘Servers’][$i][‘column_info’] = ‘pma_column_info’;
$cfg[‘Servers’][$i][‘history’] = ‘pma_history’;
$cfg[‘Servers’][$i][‘designer_coords’] = ‘pma_designer_coords’;
Step 3: Now, create a database name phpmyadmin. You can copy and paste in these script.
Click to download phpmyadmin.sql
**NOTE: People are getting some unknown characters like ‘–’ and facing difficulties to load the SQL into the database. So I remove the SQL block form here and upload that in my github repository. Please download from there and accept my apologies for that.
you are done!
Step 4: Now select any of your database from the left side database list
Step 5: You will get a “Designer” tab
Step 6: Now, you need to logged out to phpmyadmin and then log-in again to be able to see the Designer tab. Click on the “Designer” tab and you will get something like this:
That’s all, you can now enjoy the model 😉
Updated suggest by:
– Meri Alvarado