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:
- 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.
- 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
- 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'@'%';
- 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';
|