Fix phpMyAdmin Warnings/Errors

After I unzip the phpmyadmin and create a virtual directory for phpmyadmin, it keeps giving you two warning messages:

  • The configuration file now needs a secret passphrase (blowfish_secret).
  • The additional features for working with linked tables have been deactivated. To find out why click here.
1. To enter secret passphrase

If you use cookie based authentication to encrypt password in cookie in the ./phpmyadmin/configure.inc.php or ./phpmyadmin/libraries/configure.default.php, you must set a password for encryption.

You just add a new line in configure.inc.php with any password other than a space. So change this:

$cfg[‘blowfish_secret’] = ”; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

to:

$cfg[‘blowfish_secret’] = ‘anypasswordisokhere'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

2. To enable Additional Features:

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.
  2. Create phpmyadmin database.
    If you are running Web and MySQL servers on the same box:
  3. mysql -u root -p<password> < ./phpMyAdmin/scripts/create_tables.sql

    If they are on different boxes:

    mysql -h <MYSQL_SERVER_IP> -u root -p<PASSWORD> < ./phpMyAdmin/scripts/create_tables.sql

  4. 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 ‘pma’@’%';
  5. Enter the following values in the file ./phpMyAdmin/config.inc.phpon the web server:/* User for advanced features */
    $cfg[‘Servers’][$i][‘controluser’] = ‘pma';
    $cfg[‘Servers’][$i][‘controlpass’] = ‘pmapass';
    /* Advanced phpMyAdmin features */
    $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';