Enable designer tab in phpmyadmin

In this tutorial I’m going to show you how you can enable the designer tab in WAMP’s phpmyadmin.
Its already enabled by default in XAMPP that’s why XAMPP users are very lucky. Since they won’t need to configure anything to have the neat feature.

 

Requirement

  • Wampserver – phpmyadmin is already included by default. So you don’t need to download it separately

 

Configuration File

First, let’s find the config.inc.php under:

C:wampappsphpmyadmin3.3.9

Open that up in a decent text-editor. And add the lines below:

$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';

I don’t have my code snippet plugin right now, so bear with me.

Next, access my phpmyadmin from the browser. And perform the query inside this sql file:

http://dl.dropbox.com/u/27328449/Tutorial%20Files/create_tables.sql

I haven’t tried importing it from phpmyadmin. It might as well work.

 

Countermeasures

  • Clear browser history by pressing ctrl + shift + del on your keyboard.
  • Restart all services from wampserver tray menu.

 

Database designer

Hopefully you can now see the designer tab whenever you try to open up a database in phpmyadmin. Here’s a sample. This is the database that I’m using for keeping track of my dvd and cd collection on all kinds of stuff that interests me.

image

 

Conclusion

You’ve learned how to enable designer tab in phpmyadmin. If something is not working, please don’t hesitate to comment it below.

17 thoughts on “Enable designer tab in phpmyadmin

  1. $cfg[‘Servers’][$i][‘pmadb’] … OK
    $cfg[‘Servers’][$i][‘relation’] … not OK [ Documentation ]
    General relation features: Disabled

    $cfg[‘Servers’][$i][‘table_info’] … not OK [ Documentation ]
    Display Features: Disabled

    $cfg[‘Servers’][$i][‘table_coords’] … not OK [ Documentation ]
    $cfg[‘Servers’][$i][‘pdf_pages’] … not OK [ Documentation ]
    Creation of PDFs: Disabled

    $cfg[‘Servers’][$i][‘column_info’] … not OK [ Documentation ]
    Displaying Column Comments: Disabled
    Browser transformation: Disabled

    $cfg[‘Servers’][$i][‘bookmarktable’] … not OK [ Documentation ]
    Bookmarked SQL query: Disabled

    $cfg[‘Servers’][$i][‘history’] … not OK [ Documentation ]
    SQL history: Disabled

    $cfg[‘Servers’][$i][‘designer_coords’] … not OK [ Documentation ]
    Designer: Disabled

    $cfg[‘Servers’][$i][‘tracking’] … not OK [ Documentation ]
    Tracking: Disabled

    $cfg[‘Servers’][$i][‘userconfig’] … not OK [ Documentation ]
    User preferences: Disabled

    after follow your instruction,it show me above
    what should i do?

    • To tell you the truth, I also couldn’t get this to work on my desktop. So I’ll just tell you what I got on my laptop where its working:

      mysql 5.5.8
      php 5.3.5
      apache 2.2.17

      And here’s the whole of the config.inc.php:

      If you still couldn’t get it to work. I recommend you try using mysqlyog, It will also help you design your database, with some extra features.

  2. i followed the instructions and i have the designer view showing now including the tables and their repective relationship between them.
    now the problem:
    the menus do not work. Eg. save, create relations, etc do not function when you click on them. can you help me out?

  3. i followed the instructions and i have the designer view showing now including the tables and their repective relationship between them.
    now the problem:
    the menus do not work. Eg. save, create relations, etc do not function when you click on them. can you help me out?

  4. OMG this whole freakin MySQL and PhpMyAdmin is driving me nuts. 20 years ago I though Linux was too much freakin effort and now 20 years later it still freakin is. Why can’t anyone who programs in this environment make it simple and make it work!!!!

  5. i did it..
    but i didnt use his instructions.
    its actually con.default.php which is located at C:\wamp\apps\phpmyadmin3.3.9\libraries
    then do the editing..

    after that. u must have the file create.table.sql (which is downloadable as i presume) paste it on the SQL tab then click go! restart all the services of the wamp then ur good.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s