How to phpMyAdmin advanced feature settings

phpMyAdmin installation, the default of its advanced features are not open, so generally log on to phpMyAdmin, will prompt "phpMyAdmin advanced features have not been fully set, some features are not activated." Please click here to see why. ”。 And the so-called advanced function, in fact, is to store the various parameters of phpMyAdmin into the database.

To solve this problem is not difficult, in fact, according to the phpMyAdmin hint step by step can also be completed. Here is a simple record of the process.

The first step is to have a create_tables.sql file in the examples directory of the phpMyAdmin source code, which is to create the SQL named phpMyAdmin database. When you log in with the root user phpMyAdmin, on the "import" page, upload the Create_tables.sql file to successfully create the database phpMyAdmin.

The second step, after creating the database phpMyAdmin, expand left phpMyAdmin, 12 table names appear.

In the third step, change the parameters in the configuration file (config.inc.php), see the example in config.sample.inc.php. The setting for phpMyAdmin Configuration Storage settings is 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] [' tracking '] = ' pma__tracking ';

$cfg [' Servers '] [$i] [' designer_coords '] = ' pma__designer_coords ';

$cfg [' Servers '] [$i] [' userconfig '] = ' pma__userconfig ';

$cfg [' Servers '] [$i] [' recent '] = ' pma__recent ';

$cfg [' Servers '] [$i] [' table_uiprefs '] = ' pma__table_uiprefs ';

Step fourth, exit and log back in phpMyAdmin to load the new configuration and make it effective.

Note that I remember that the create_tables.sql created in the old version of the table name, similar to Pma_bookmark, is an underscore "_" instead of the current Pma__bookmark, two underline "__", Therefore, the configuration file also makes the appropriate changes.

December 18, 2013 update:

Because the phpMyAdmin version 4.1.1 created a phpMyAdmin database that adds 3 tables, the configuration file config.inc.php also needs to be changed accordingly. The latest version of phpMyAdmin Configuration Storage settings is 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] [' tracking '] = ' pma__tracking ';

$cfg [' Servers '] [$i] [' designer_coords '] = ' pma__designer_coords ';

$cfg [' Servers '] [$i] [' userconfig '] = ' pma__userconfig ';

$cfg [' Servers '] [$i] [' recent '] = ' pma__recent ';

$cfg [' Servers '] [$i] [' table_uiprefs '] = ' pma__table_uiprefs ';

$cfg [' Servers '] [$i] [' users '] = ' pma__users ';

$cfg [' Servers '] [$i] [' usergroups '] = ' pma__usergroups ';

$cfg [' Servers '] [$i] [' navigationhiding '] = ' pma__navigationhiding ';