Showing posts with label Phpmyadmin. Show all posts
Showing posts with label Phpmyadmin. Show all posts

Nov 30, 2007

Getting Relational(Designer) view in Phpmyadmin

Its just simple....
just go to the phpmyadmin folder
In my case i am using lampp and and the path to phpmyadmin is:
/opt/lampp/phpmyadmin

open the file:
confing.inc.php
Note: You should be root (or use sudo command) to open the file.

Find the line:
$cfg['Servers'][$i]['pmadb'] = '';
Edit it to:
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
and save the file.
And also conform the the following lines exists and exactly same as below:
$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';



Reopen phpmyadmin and you will get, what you are searching for.