To turn on the phpMyAdmin Advanced feature setting method

Note: This article is based on phpMyAdmin5.5, using the LNMP environment

Problem:

登录到phpMyAdmin以后，在主界面的底部，我们发现两条提示信息:一条提示信息是“phpMyAdmin高级功能尚未完全设置，部分功能未激活。请点击这里查看原因”，另外一条信息是“配置文件现在需要一个短语密码。”

Once these two pieces of information are present, it means that some of the features in phpMyAdmin are not available. The procedure for solving this problem is divided into three parts: uploading create_tables.sql files, configuring config.inc.php files, and modifying config.default.php files.

Resolution: 1. phpMyAdmin Database creation:

Open the phpMyAdmin directory and find Create_tables.sql
CD./sql
You can see the create_tables.sql, then copy the SQL statement inside and execute it so that the phpMyAdmin database is created successfully

2. Configuring the config.inc.php File

Open the phpMyAdmin folder, locate the config.sample.inc.php file, and rename it to a config.inc.php file.

3. Open the config.inc.php file and locate the following statement:

/* Storage Database andTables *///$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] [' Table_uiprefs '] =' Pma__table_uiprefs ';//$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] [' favorite '] =' Pma__favorite ';//$cfg [' Servers '[$i] [' users '] =' Pma__users ';//$cfg [' Servers '[$i] [' usergroups '] =' pma__usergroups ';//$cfg [' Servers '[$i] [' navigationhiding '] =' pma__navigationhiding ';//$cfg [' Servers '[$i] [' savedsearches '] =' pma__savedsearches ';

Remove the//(double slash) and space in front of each statement below the/* Storage database and Tables */statement.

Note:
In/* Storage database and Tables */sentence above, there are two lines of sentence:

// $cfg[‘Servers‘][$i][‘controluser‘‘pma‘;// $cfg[‘Servers‘][$i][‘controlpass‘‘pmapass‘;

If necessary, you can modify it to:

$cfg[‘Servers‘][$i][‘controluser‘‘用户名‘;$cfg[‘Servers‘][$i][‘controlpass‘‘密码‘;

4. Modify the config.default.php file

Open the config.default.php file in the Phpmyadmin\libraries\ folder.
Within the config.default.php file

1) Looking for: $cfg [' Servers '[$i] [' pmadb '] ="'; modified to: $cfg [' Servers '[$i] [' pmadb '] =' phpMyAdmin ';2) Looking for: $cfg [' Servers '[$i] [' bookmarktable '] ="'; modified to: $cfg [' Servers '[$i] [' bookmarktable '] =' Pma__bookmark ';3) Looking for: $cfg [' Servers '[$i] [' relation '] ="'; modified to: $cfg [' Servers '[$i] [' relation '] =' Pma__relation ';4) Looking for: $cfg [' Servers '[$i] [' Table_info '] ="'; modified to: $cfg [' Servers '[$i] [' Table_info '] =' Pma__table_info ';5) Looking for: $cfg [' Servers '[$i] [' Table_coords '] ="'; modified to: $cfg [' Servers '[$i] [' Table_coords '] =' Pma__table_coords ';6) Looking for: $cfg [' Servers '[$i] [' Pdf_pages '] ="'; modified to: $cfg [' Servers '[$i] [' Pdf_pages '] =' Pma__pdf_pages ';7) Looking for: $cfg [' Servers '[$i] [' Column_info '] ="'; modified to: $cfg [' Servers '[$i] [' Column_info '] =' Pma__column_info ';8) Looking for: $cfg [' Servers '[$i] [' History '] ="'; modified to: $cfg [' Servers '[$i] [' History '] =' Pma__history ';9) Looking for: $cfg [' Servers '[$i] [' Table_uiprefs '] ="'; modified to: $cfg [' Servers '[$i] [' Table_uiprefs '] =' Pma__table_uiprefs ';Ten) Looking for: $cfg [' Servers '[$i] [' Tracking '] ="'; modified to: $cfg [' Servers '[$i] [' Tracking '] =' pma__tracking '; One) Looking for: $cfg [' Servers '[$i] [' Designer_coords '] ="'; modified to: $cfg [' Servers '[$i] [' Designer_coords '] =' Pma__designer_coords '; A) Looking for: $cfg [' Servers '[$i] [' Userconfig '] ="'; modified to: $cfg [' Servers '[$i] [' Userconfig '] =' Pma__userconfig '; -) Looking for: $cfg [' Servers '[$i] [' recent '] ="'; modified to: $cfg [' Servers '[$i] [' recent '] =' Pma__recent '; -) Looking for: $cfg [' Servers '[$i] [' favorite '] ="'; modified to: $cfg [' Servers '[$i] [' favorite '] =' Pma__favorite '; the) Looking for: $cfg [' Servers '[$i] [' users '] ="'; modified to: $cfg [' Servers '[$i] [' users '] =' Pma__users '; -) Looking for: $cfg [' Servers '[$i] [' usergroups '] ="'; modified to: $cfg [' Servers '[$i] [' usergroups '] =' pma__usergroups '; -) Looking for: $cfg [' Servers '[$i] [' navigationhiding '] ="'; modified to: $cfg [' Servers '[$i] [' navigationhiding '] =' pma__navigationhiding '; -) Looking for: $cfg [' Servers '[$i] [' savedsearches '] ="'; modified to: $cfg [' Servers '[$i] [' savedsearches '] =' pma__savedsearches ';

Tips:
In fact, these are the sentences in the config.inc.php file that have been removed//(double slash).

Save and close the config.default.php file.

Re-login phpMyAdmin

To turn on the phpMyAdmin Advanced feature setting method