Detailed explanation of how to enable advanced features of phpMyAdmin

The following column phpmyadmin tutorial will introduce to you how to set up the advanced functions of phpMyAdmin. I hope it will be helpful to friends in need!

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

Question:

Log in tophpMyAdmin Later, at the bottom of the main interface, we found two prompt messages:

One prompt message is "phpMyAdmin advanced functions have not been fully set up, and some functions are not activated. Please click here to view the reason", and the other message It's "The configuration file now requires a phrase password."

Once these two messages appear, it means that some functions in phpMyAdmin cannot be used.

The steps to solve this problem are divided into three parts:

Upload the create_tables.sql file, configure the config.inc.php file and modify it config.default.phpFile, etc.

Solution:

1. phpmyadmin database creation:

Open the phpMyAdmin directory and find create_tables.sql

cd ./sql

to see Go to create_tables.sql, then copy the sql statement inside, and then execute it. In this way, the phpmyadmin database is created successfully

2. Configure the config.inc.php file

Open the phpMyAdmin folder and find config.sample.inc.php file, rename it to 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';

Replace the // (double italic) in front of each statement below the /* Storage database and tables */ statement All bars) and spaces are removed.

Note:

Above the /* Storage database and tables */ sentence, there are the following two lines of sentences:

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

If necessary, you can modify it For:

$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.

In the config.default.php file

1) Find:

$cfg['Servers'][$i]['pmadb'] = '';

Modify to:

$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';

2) Find:

$cfg['Servers'][$i]['bookmarktable'] = '';

Modify to:

$cfg['Servers'][$i ]['bookmarktable'] = 'pma__bookmark';

3) Find:

$cfg['Servers'][$i]['relation'] = '';

Modify to:

$cfg['Servers'][$i]['relation'] = 'pma__relation';

4) Find:

$ cfg['Servers'][$i]['table_info'] = '';

is modified to:

$cfg['Servers'][$i]['table_info'] = 'pma__table_info';

5) Find:

$cfg['Servers'][$i]['table_coords'] = '';

Modify to:

$cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';

6) Find:

$cfg['Servers'] [$i]['pdf_pages'] = '';

Modify to:

$cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';

7) Find:

$cfg['Servers'][$i]['column_info'] = '';

Modify to:

$cfg['Servers'][$i]['column_info'] = 'pma__column_info';

8) Find:

$cfg['Servers'][$i][' history'] = '';

Modify to:

$cfg['Servers'][$i]['history'] = 'pma__history';

9 ) Find:

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

Modify to:

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

10) Find:

$cfg['Servers'][$i]['tracking'] = '' ;

Modify to:

$cfg['Servers'][$i]['tracking'] = 'pma__tracking';

11) Find:

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

Modify to:

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

12) Find:

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

Modify to:

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

13) Find:

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

Modify to:

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

14) Find:

$cfg['Servers'][$i]['favorite'] = '';

Modify to:

$cfg['Servers'][$i]['favorite'] = 'pma__favorite';

15) Find:

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

Modify to:

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

16) Find:

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

Modify to:

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

17) Find:

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

Modify to:

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

18) Find:

$cfg[ 'Servers'][$i]['savedsearches'] = '';

Modified to:

$cfg['Servers'][$i]['savedsearches'] = ' pma__savedsearches';

Tips:

Actually, the above sentences are the // (double italic) that have been removed from the config.inc.php file (bar) sentences.

Save and close the config.default.php file.

Log in to phpMyAdmin again.

The above is the detailed content of Detailed explanation of how to enable advanced features of phpMyAdmin. For more information, please follow other related articles on the PHP Chinese website!