How to phpMyAdmin advanced feature settings

Source: Internet
Author: User
Tags config table name phpmyadmin

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 ';

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.