Explanation of phpMyAdmin configuration methods-PHP Tutorial

Source: Internet
Author: User
Describe how to configure phpMyAdmin. Starting from version 1.4.2 for the $ login servers array, phpMyAdmin supports managing multiple MySQL-servers. Therefore, the $ login servers array is added to store login information of different servers. We are

$ Worker servers array

PhpMyAdmin supports managing multiple MySQL-servers from version 1.4.2. Therefore, the $ login servers array is added to store the login information of different servers. $ Incluservers [1] ["host"] contains the host name of the first server, $ incluservers [2] ["host"] is the host of the second server, and so on. If you only have one server to manage, you can simply ignore the host name of the other $ login servers entry.

$ Incluservers [n] ["port"] string

The port number of the nth MySQL server. The default value is 3300 (the null value is retained ).

$ Pipeline servers [n] ["host"] string configured in phpMyAdmin

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

$ Incluservers [n] ["adv_auth"] boolean value

The basic or advanced authentication method should be used for this server. The basic authentication method ($ adv_auth = false) is a common practice:

The account name and password are stored in config. inc. php3. Advanced Authentication ($ adv_auth = true) is introduced from version 1.3.0, allowing you to log on as a legal MySQL User through HTTP-Auth. In config. in inc, you only need to provide a standard user who can connect to MySQL and read the user/db table of the mysql database (see $ login servers [n] ["stduser"]).

We recommend that you use advanced management:

When phpMyAdmin is running in a multi-user environment and people have shell processing permissions, you do not want to know the MySQL User name/password.

When you want users to access their own databases and do not want them to interfere with others.

Advanced Authentication is secure because standard users only need read-only permissions on the mysql database. The MySQL password cannot be easily cracked, so a common user has no chance to see the plaintext password of other users.

$ Incluservers [n] ["user"] string

$ Login servers [n] ["password"] string

When you use the basic authentication method, phpMyAdmin configuration will use the user name/password to connect to the MySQL server. This is not required when advanced authentication is used.

$ Incluservers [n] ["stduser"] string

$ Incluservers [n] ["stdpass"] string

When advanced authentication is used, the user name/password pair is used to verify the real user name/password pair. This user must be able to connect to MySQL and read the user table of the mysql database. This parameter is not required when basic authentication is used.

$ Incluservers [n] ["only_db"] string

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

$ Incluservers [n] ["verbose"] string

PhpMyAdmin configuration is useful only when multiple server entries are configured. If this parameter is set, the string is displayed to replace the host name in the context menu on the home page. For example, if you want to display only some databases in the system, this may be useful.

$ CfgManualBase string

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

$ Define persistentconnections Boolean value

Whether to use persistent connection (mysql_connect or mysql_pconnect ).

$ Define confirm Boolean value

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

$ CfgMaxRows integer in phpMyAdmin configuration

The number of records displayed when you browse a result set. If the result set contains more data, the link to the previous or back pages is displayed.

$ CfgMaxInputsize integer

When you add a new record to a table, edit the field size.

$ CfgBorder integer

The size of the table boundary.

$ CfgThBgcolor string [HTML color]

Used in the color of the header.

$ CfgBgcolorOne string [HTML color]

The color of the first row of the table.

$ CfgBgcolorTwo string [HTML color]

The color of the second row of the table.

$ CfgOrder string configured in phpMyAdmin ["DESC" | "ASC"]

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

$ Empty showblob Boolean value

Determines whether the BLOB field is displayed when you browse the content of a table.

$ Explain showsql Boolean value

Determines whether to display the SQL query statements generated by phpMyAdmin.

$ Columntypes array

All possible MySQL column types. In most cases, you do not need to edit it.

$ CfgFunctions array configured in phpMyAdmin

List of functions supported by MySQL. In most cases, you do not need to edit it.

$ CfgAttributeTypes array configured in phpMyAdmin

Possible attributes of a field. In most cases, you do not need to edit it.


Starting from version 1.4.2, phpMyAdmin supports managing multiple MySQL-servers. Therefore, the $ login servers array is added to store login information of different servers ....

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.