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:

open the file:
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.

1 comment:

Anonymous said...

Wichtig ist auch das in der config Datei auch noch folgende Optionen aktiviert sind:

/* Authentication type */
//$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysqli if your server has it */
//$cfg['Servers'][$i]['extension'] = 'mysql';