Interpret the specific method of phpMyAdmin configuration_PHP tutorial

We are working on the

$cfgServers array

Starting from version 1.4.2, phpMyAdmin supports multiple MySQL- Server management. Therefore, the $cfgServers array was added to store the login information of different servers. $cfgServers[1]["host"] contains the host name of the first server, $cfgServers[2]["host"] is the host of the second server, etc., etc. If you only have one server to manage, you can simply ignore the hostnames of the other $cfgServers entries.

$cfgServers[n]["port"] String

The port number of the nth MySQL server. The default value is 3300 (leave empty).

phpMyAdmin configuration $cfgServers[n]["host"] string

The host name of the nth MySQL server. For example, localhost.

$cfgServers[n]["adv_auth"] Boolean value

Basic or advanced authentication should be used for this server. Basic authentication ($adv_auth = false) is plain old:

The username and password are stored in config.inc.php3. Advanced authentication ($adv_auth = true), introduced in version 1.3.0, allows you to log in as a legitimate MySQL user via HTTP-Auth. In config.inc you only need to provide a standard user who can connect to MySQL and read the user/db table of the mysql library (see $cfgServers[n]["stduser"]).

Occasions where advanced management methods are recommended:

When phpMyAdmin is running in a multi-user environment and people have shell processing rights, you don’t want to know the MySQL username/ Password.

When you want users to access their own database and don't want them to interfere with others.

The advanced authentication method is safe because standard users only need read-only permissions to the mysql library. MySQL passwords cannot be easily cracked, so there is no chance for an ordinary user to see other users' clear text passwords.

$cfgServers[n]["user"] string

$cfgServers[n]["password"] string

When using basic authentication, the phpMyAdmin configuration will use the username/password pair to connect to this MySQL server. Not required when using advanced authentication methods.

$cfgServers[n]["stduser"] string

$cfgServers[n]["stdpass"] string

When using advanced authentication, the username/password pair is used to verify the real username/password pair. This user must be able to connect to MySQL and read the user table of the mysql library. Not required when using basic authentication.

$cfgServers[n]["only_db"] string

If a database name is set, only this database will be displayed to the user.

$cfgServers[n]["verbose"] String

This is only useful for phpMyAdmin configuration when using multiple server entries. If set, this string will be displayed in place of the hostname in the drop-down menu on the main page. For example, this might be useful if you want to display only certain databases on your system.

$cfgManualBase string

If set to a URL (which points to the MySQL documentation), the corresponding help link will be created.

$cfgPersistentConnections Boolean value

Whether to use persistent connections (mysql_connect or mysql_pconnect).

$cfgConfirm Boolean

Whether a warning message ("Are you really sure you want to...") should be displayed when you are about to lose data.

phpMyAdmin configuration $cfgMaxRows integer

The number of records displayed when browsing a result set. If the result set contains more data, links to previous/next pages will be displayed.

$cfgMaxInputsize integer

The size of the edit field when adding a new record to a table.

$cfgBorder integer

The size of the table border.

$cfgThBgcolor string [HTML color]

The color used in the table header.

$cfgBgcolorOne string [HTML color]

The color of the first row of the table row.

$cfgBgcolorTwo string [HTML color]

The color of the second row of the table row.

phpMyAdmin configuration $cfgOrder string ["DESC"|"ASC"]

defines that when you click the field name, the fields are in ascending order ("ASC ") is displayed in descending order ("DESC").

$cfgShowBlob Boolean value

defines whether to display BLOB fields when browsing the contents of a table.

$cfgShowSQL Boolean value

defines whether to display the sql query statement generated by phpMyAdmin.

$cfgColumnTypes array

All possible types of MySQL columns. In most cases you won't need to edit it.

$cfgFunctions array of phpMyAdmin configuration

List of functions supported by MySQL. In most cases you won't need to edit it.

$cfgAttributeTypes array of phpMyAdmin configuration

Possible attributes of the field. In most cases you won't need to edit it.