• Content
  • Comments (0)
  • Related articles
Jun
13
2011

How to enable Linked Tables in phpMyAdmin ! Monday, 13 June 2011

Updated for phpMyAdmin v3.5.2
After fresh install of Wamp Server suite you may get the following message under phpMyAdmin v3.3.9. These are addional features of phpMyAmin. You do not need to worry about as they won’t affect your databases. Anyway if you want to enable those features or just get rid of the message follow this guide.
The additional features for working with linked tables have been deactivated. To find out why click here.

 

localhost
$cfg[‘Servers’][$i][‘pmadb’] … not OK [ Documentation ]
$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

 

Resolution:

  • Find and Run [create_tables.sql] or just copy/paste in phpMyAdmin > SQL, don’t worry about comments in *.sql script file as they would be ignored so just copy as it is.
    – for Wamp Server instalation can be found [c:\wamp\apps\phpmyadmin3.3.9\scripts\]
    – for Wamp Server instalation can be found [c:\wamp\apps\phpmyadmin3.5.2\examples\]
  • Create the user for [phpmyadmin] newly created database manually using phpMyAdmin > Privileges > Add new User or go to phpMyAdmin > SQL using this script:

    CREATE USER ‘pma’@’localhost’ IDENTIFIED BY ‘pmapass’;
    GRANT SELECT, INSERT, UPDATE, DELETE ON phpmyadmin.* TO ‘pma’@’localhost’;

  • Find and Edit [config.inc.php], you need to enable / add few lines as follows:

    $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’;
    $cfg[‘Servers’][$i][‘tracking’] = ‘pma_tracking’;
    $cfg[‘Servers’][$i][‘userconfig’] = ‘pma_userconfig’;
    $cfg[‘Servers’][$i][‘recent’] = ‘pma_recent’;
    $cfg[‘Servers’][$i][‘table_uiprefs’] = ‘pma_table_uiprefs’;

    $cfg[‘Servers’][$i][‘controluser’] = ‘pma’;
    $cfg[‘Servers’][$i][‘controlpass’] = ‘pmapass’;

  • Close browser if is already open to get proper refresh and open it again.

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*