Shulou(Shulou.com)06/03 Report--

This article mainly explains "the specific configuration method of phpMyAdmin". The content of the explanation is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "the specific configuration method of phpMyAdmin".

$cfgServers array

Starting with version 1.4.2, phpMyAdmin supports the management of multiple MySQL-server. Therefore, the $cfgServers array is added to store login information for different servers. $cfgServers [1] ["host"] contains the hostnames of * servers, $cfgServers [2] ["host"] is the host of the second server, and so on. If you have only 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 null).

PhpMyAdmin configured $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. The basic authentication method ($adv_auth = false) is a common old practice:

It is stored in config.inc.php3 with the user name and password. Advanced authentication ($adv_auth = true) has been introduced since version 1.3.0, allowing you to log in as a legitimate MySQL user through HTTP- Auth. In config.inc you only need to provide a standard user who can connect to the MySQL and can read the user/db table of the mysql library (see $cfgServers[ n] ["stduser"]).

Situations where advanced management is recommended:

When phpMyAdmin runs in a multi-user environment and people have access to shell, you don't want to know the user name / password of MySQL.

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

Advanced authentication is secure because standard users only need read-only access to the mysql library. MySQL passwords cannot be easily cracked, so there is no chance for an ordinary user to see the plaintext passwords of other users.

$cfgServers [n] ["user"] string

$cfgServers [n] ["password"] string

When using basic authentication, the phpMyAdmin configuration uses a username / password pair to connect to the MySQL server. Not required when using advanced authentication.

$cfgServers [n] ["stduser"] string

$cfgServers [n] ["stdpass"] string

When advanced authentication is used, 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 that database will be displayed to the user.

$cfgServers [n] ["verbose"] string

PhpMyAdmin configuration is useful only when there are multiple server portals. If set, this string will be displayed instead of the hostname in the next menu on the main page. For example, this might be useful if you want to display only certain databases in the system.

$cfgManualBase string

If set to a URL (which points to the MySQL document), a corresponding help link is created.

$cfgPersistentConnections Boolean value

Whether to use a persistent connection (mysql_connect or mysql_pconnect).

$cfgConfirm Boolean value

Whether you should display a warning message when you are about to lose data ("are you sure you want to.").

Integer $cfgMaxRows configured by phpMyAdmin

The number of records displayed when browsing a result set. If the result set contains more data, the link to the front / back page is displayed.

$cfgMaxInputsize integer

Edit the size of the field when a new record is added to a table.

$cfgBorder integer

The size of the boundary of the table.

$cfgThBgcolor string [HTML color]

The color used in the head of the meter.

$cfgBgcolorOne string [HTML color]

The color of the table row.

$cfgBgcolorTwo string [HTML color]

The color of the second row of the table row.

$cfgOrder string configured by phpMyAdmin ["DESC" | "ASC"]

Defines whether the field is displayed in ascending order ("ASC") or descending order ("DESC") when you click on the field name.

$cfgShowBlob Boolean value

Defines whether the BLOB field is displayed when browsing the contents of a table.

$cfgShowSQL Boolean value

Defines whether to display sql query statements generated by phpMyAdmin.

$cfgColumnTypes array

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

$cfgFunctions array of phpMyAdmin configuration

MySQL supports a list of functions. In most cases you don't need to edit it.

$cfgAttributeTypes array of phpMyAdmin configuration

Thank you for your reading, the above is the content of "the specific configuration method of phpMyAdmin", after the study of this article, I believe you have a deeper understanding of the specific configuration method of phpMyAdmin, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.