phpMyAdmin: The additional features for working with linked tables have been deactivated.

Step 1: Edit and run create_tables.sql

This sql file is included with phpMyAdmin, in a wamp installation it can be found at: C:\wamp\apps\phpmyadmin3.2.0.1\scripts\create_tables.sql

There are two sections at the top which are usually commented out – one to create a phpmyadmin database, and one to create a phpmyadmin user. I usually just create the database myself and I prefer to use the following command in the next step to create the user. So, after creating the database, I usually just run the file as it originally came.

Step 2: Create a control user (controluser):

You’re on your own if you used the script above to create your control user, and you probably know what you’re doing. If you don’t, however, I recommend these mysql commands:

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

Step 3: Edit config.inc.php:

Add these lines to your config.inc.php file and then you should be good to go!

$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][‘controluser’] = ‘phpmyadmin’;
$cfg[‘Servers’][$i][‘controlpass’] = ‘pmapass’;

Troubleshooting:

If you’re getting the message “The additional features for working with linked tables have been deactivated. To find out why click here.” or something similar, it probably means you don’t have the pmadb, controluser, and/or controlpass set up correctly to corresponding users in the database.

If you’re getting a message saying ”not OK [ Documentation ]” but the first line ($cfg[‘Servers’][$i][‘pmadb’]) says OK, you either need to adjust the table names, or overcome something more complex. For me, after I switched to Apache 2.0 from 2.2 it started working.

NB :

You need to log out of phpMyAdmin or remove the session cookies and reload once the changes are made.

One Response to “phpMyAdmin: The additional features for working with linked tables have been deactivated.”

  1. S Briggs Says:

    I understand all and i’ve done it.. But not working.
    Is step 1 asking for a database to be created? before the control user is created? If yes, How to create it.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: