How to enable advanced phpMyAdmin Functions

Note: This article is based on phpMyAdmin5.5 and uses LNMP environment problems: After logging on to phpMyAdmin, at the bottom of the main interface, we found two prompts: one message is "phpMyAdmin advanced features have not been fully set, some features are not activated. Click here to view the reason. The other information is "the configuration file now requires a phrase password.

Note: This article is based on phpMyAdmin5.5 and uses LNMP environment problems: After logging on to phpMyAdmin, at the bottom of the main interface, we found two prompts: one message is "phpMyAdmin advanced features have not been fully set, some features are not activated. Click here to view the reason. The other information is "the configuration file now requires a phrase password.

Note: This article uses the LNMP Environment Based on phpMyAdmin5.5.

Problem:

After logging on to phpMyAdmin, at the bottom of the main interface, we found two prompts: one is "phpMyAdmin advanced function is not fully set, and some features are not activated. Click here to view the reason. The other information is "the configuration file now requires a phrase password ."

Once these two messages are displayed, some functions in phpMyAdmin cannot be used. The steps to solve this problem include uploading the create_tables. SQL file, configuring the config. inc. php file, and modifying the config. default. php file.

Solution: 1. Create a phpmyadmin database:

Open the phpMyAdmin directory and find create_tables. SQL.
Cd./SQL
You can see create_tables. SQL, copy the SQL statement in it, and execute it. In this way, the phpmyadmin database is created successfully.

2. Configure the config. inc. php file

Open the phpMyAdmin folder, find the config. sample. inc. php file, and rename it as the config. inc. php file.

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

/* Storage database and tables */// $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 slash (/) and space before each statement under the/* Storage database and tables */statement.

Note:
In the/* Storage database and tables */sentence, there are two sentences:

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

If needed, you can modify it:

$ Cfg ['servers'] [$ I] ['controluser'] = 'username '; $ cfg ['servers'] [$ I] ['controlpass'] = 'Password ';

4. Modify the config. default. php file.

Open the config. default. php file in the phpMyAdmin \ libraries \ folder.
In the config. default. php file

1) Search: $ cfg ['servers'] [$ I] ['pmadb'] = ''; changed: $ cfg ['servers'] [$ I] ['pmadb'] = 'phpmyadmin'; 2) Search: $ cfg ['servers'] [$ I] ['bookmarktable'] = ''; changed: $ cfg ['servers'] [$ I] ['bookmarktable'] = 'pma _ bookmark'; 3) Search: $ cfg ['servers'] [$ I] ['relation'] = ''; changed: $ cfg ['servers'] [$ I] ['relation'] = 'pma _ relation'; 4) Search: $ cfg ['servers'] [$ I] ['table _ info'] = ''; changed: $ cfg ['servers'] [$ I] ['table _ info'] = 'pma _ table_info '; 5) Search: $ cfg ['servers'] [$ I] ['table _ coords '] = ''; changed: $ cfg ['servers'] [$ I] ['table _ coords '] = 'pma _ table_coords'; 6) Search: $ cfg ['servers'] [$ I] ['pdf _ page'] = ''; changed: $ cfg ['servers'] [$ I] ['pdf _ page'] = 'pma _ Ma _pages '; 7) Search: $ cfg ['servers'] [$ I] ['column _ info'] = ''; changed: $ cfg ['servers'] [$ I] ['column _ info'] = 'pma _ column_info '; 8) Search: $ cfg ['servers'] [$ I] ['History '] = ''; changed: $ cfg ['servers'] [$ I] ['History '] = 'pma _ history'; 9) Search: $ cfg ['servers'] [$ I] ['table _ uiprefs '] = ''; changed: $ cfg ['servers'] [$ I] ['table _ uiprefs '] = 'pma _ table_uiprefs'; 10) Search: $ cfg ['servers'] [$ I] ['tracking'] = ''; changed: $ cfg ['servers'] [$ I] ['tracking'] = 'pma _ tracking '; 11) Search: $ cfg ['servers'] [$ I] ['designer _ coords '] = ''; changed: $ cfg ['servers'] [$ I] ['designer _ coords '] = 'pma _ designer_coords'; 12) query: $ cfg ['servers'] [$ I] ['userconfig'] = ''; changed: $ cfg ['servers'] [$ I] ['userconfig'] = 'pma _ userconfig'; 13) Search: $ cfg ['servers'] [$ I] ['recent '] = ''; changed: $ cfg ['servers'] [$ I] ['recent '] = 'pma _ recent'; 14) Search: $ cfg ['servers'] [$ I] ['favorite '] = ''; changed: $ cfg ['servers'] [$ I] ['favorite '] = 'pma _ favorite'; 15) Search: $ cfg ['servers'] [$ I] ['users'] = ''; changed: $ cfg ['servers'] [$ I] ['users'] = 'pma _ users'; 16) Search: $ cfg ['servers'] [$ I] ['usergroupup'] = ''; changed: $ cfg ['servers'] [$ I] ['usergroupup'] = 'pma _ usergroupup'; 17) Search: $ cfg ['servers'] [$ I] ['navigationing ing '] = ''; changed: $ cfg ['servers'] [$ I] ['navigationing ing '] = 'pma _ navigationing ing'; 18) Search: $ cfg ['servers'] [$ I] ['savedsearches'] = ''; changed: $ cfg ['servers'] [$ I] ['savedsearches'] = 'pma _ savedsearches ';

Tip:
In fact, the above sentences are the sentences that have been removed from the config. inc. php file // (double slash.

Save and close the config. default. php file.

Log on to phpMyAdmin again.