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.
- Wampserver – phpmyadmin is already included by default. So you don’t need to download it separately
First, let’s find the config.inc.php under:
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:
I haven’t tried importing it from phpmyadmin. It might as well work.
- Clear browser history by pressing ctrl + shift + del on your keyboard.
- Restart all services from wampserver tray menu.
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.
You’ve learned how to enable designer tab in phpmyadmin. If something is not working, please don’t hesitate to comment it below.