Enabling Linked Tables in phpMyAdmin

 

Related Docs:   phpMyAdmin 2.6.0 Security Fix

New versions of phpMyAdmin give the following error if not configured accordingly:

"Error
The additional features for working with linked tables have been deactivated."

These features include bookmarks, comments, SQL-history, PDF generation, field contents transformation, etc. To enable them, do the following:

  1. Log into the web server as root. This must be the web server where phpMyAdmin is installed. The ID of this logical server is specified in /hsphere/local/home/cpanel/shiva/psoft_config/hsphere.properties on the CP server.
  2. Create phpmyadmin database.
    If you are running Web and MySQL servers on the same box:
    mysql -u root -p<password> < /hsphere/shared/apache/htdocs/phpMyAdmin/scripts/create_tables.sql
    If they are on different boxes:
    mysql -h <MYSQL_SERVER_IP> -u root -p<PASSWORD> < /hsphere/shared/apache/htdocs/phpMyAdmin/scripts/create_tables.sql
  3. Give necessary permissions to the controluser.
    If you are running Web and MySQL servers on different boxes, first log into the MySQL server as root.
    mysql# GRANT SELECT, INSERT, UPDATE, DELETE ON phpmyadmin.* TO 'phpuser'@'%';
  4. Enter the following values in the file /hsphere/shared/apache/htdocs/phpMyAdmin/config.inc.php on the web server:
    $cfgServers[1]['pmadb'] = 'phpmyadmin';
    $cfgServers[1]['table_info'] = 'pma_table_info';
    $cfgServers[1]['pdf_pages'] = 'pma_pdf_pages';
    $cfgServers[1]['history'] = 'pma_history';
    $cfgServers[1]['column_info'] = 'pma_column_info';
    $cfgServers[1]['table_coords'] = 'pma_table_coords';
    $cfgServers[1]['relation'] = 'pma_relation';
    $cfgServers[1]['bookmarktable'] = 'pma_bookmark';

Related Docs:   phpMyAdmin 2.6.0 Security Fix







Home   Products   Services   News
© Copyright. . PSOFT. All Rights Reserved. Terms | Site Map