phpMyAdmin installation Configuration Method Illustrated tutorial

Profiling

Locate the/libraries/config.default.php file (the old version is a config.inc.php file under the root) and edit it using WordPad (not Notepad, which is UTF8 encoding).
4, find $cfg [' Pmaabsoluteuri ']
Modify the URL of the phpmyadmin you will upload to the space
such as: $cfg [' pmaabsoluteuri '] = ' http://www.xxx.com/ Phpmyadmin/';
5, find $cfg [' Servers '] [$i] [' host '] = ' localhost '; (usually with the default, there are exceptions, can not be modified)
6, find $cfg [' Servers '] [$i] [' auth_type '] = ' Config ';
Debug in your own machine with config; if the space on the network uses cookies, here we have added the URL before, modify it to cookies, here we recommend using cookies.
7, find $cfg [' Servers '] [$i] [' user '] = ' root ';//MySQL User (username, General here casually fill in a few letters on it; Under special circumstances, you can use root in your own machine, in general for your FTP username, Virtual host provider tell you, do not generally modify.)
8, find $cfg [' Servers '] [$i] [' password '] = "; MySQL password (only needed left blank)
9, find $cfg [' Servers '] [$i] [' only_db '] = "; If set to a db-name, only (you only have one data set, set to your database name, if you want to build the server, then the recommendation is left blank)
10, find $cfg [' defaultlang '] = ' en ' (here is the choice of language, ZH representative
11, find $cfg[' Blowfish_secret '], please set your website's cookie in the equal sign of $cfg[' blowfish_secret ' = '; Cookies are access to phpMyAdmin domain names, for example: $cfg [' blowfish_secret '] = ' www.xinnethz.net ';.

phpMyAdmin the additional features of the linked table have not been activated how to solve the problem?

Back to the diagram above we see that although the phpMyAdmin configuration is complete, but the bottom is still a hint that some of the configuration work is not complete, one of the tips: The additional features of the linked table have not been activated, so how to solve it?

First, click on the import link, upload scripts/create_tables.sql and execute, create the phpMyAdmin database.

Second, in the phpMyAdmin configuration file config.default.php found

The code is as follows

Copy Code

? $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] [' designer_coords '] = ' pma_designer_coords '; $cfg [' Servers '] [$i] [' tracking '] = ' pma_tracking '; ?>

These variables are empty by default in the phpMyAdmin configuration file, and you only need to assign values to the variables based on the annotations.

After you complete the configuration, turn off the browser and log on again.

phpMyAdmin configuration file now needs a phrase password how to solve?

Found in the phpMyAdmin configuration file config.default.php

The code is as follows	Copy Code
? $cfg [' blowfish_secret '] = ' leapsoul.cn ' ?>

Here I assign the value to leapsoul.cn, which is used for the encryption of cookies

phpMyAdmin Login Mode Description

In Phpmyadmin3, there are four types of logins in total

Config: Directly enter phpMyAdmin remote login address, as long as the user name password in the configuration file can be set.

http: Pop-up dialog box, enter user name and password

Signon: Similar to the page jump login mode, at the same time need to set $cfg[' Servers ' [$i] [' Signonurl '], when you enter the phpMyAdmin remote login address will automatically jump to the Signonurl set URL.

Cookie: That is, the phpMyAdmin configuration when the login method.

Now that the entire phpmyadmin3 installation and configuration work is complete, you can experience the new features of phpMyAdmin new version.