phpMyAdmin configuration file Servers configuration options Description

After introducing the phpMyAdmin configuration file partial configuration option, say the use method and description of the servers option in the phpMyAdmin configuration file. Because the installation configuration of the phpMyAdmin necessarily involves the configuration of the Servers option in the phpMyAdmin configuration file, phpMyAdmin cannot access it properly.

The servers option in the phpMyAdmin configuration file appears as an array because phpMyAdmin can manage multiple MySQL servers as needed. $cfg [' Servers '] array is used to hold login information for different MySQL servers. The first $cfg[' Servers ' [$i] [' Host '] contains the hostname of the first server, the second $cfg[' Servers '] [$i] [' Host '] contains the host name of the second server, and so on. You can copy the configuration of the server in the phpMyAdmin default profile config.default.php in the Libraries directory multiple times to the config.inc.php configuration file in the root directory.

　　phpMyAdmin configuration file Servers configuration options Detailed description

　　$cfg [' Servers '] [$i] [' Host '] : The host name or IP address of the MySQL server. If the PHP environment is configured and the MySQL server is a machine, you can use localhost or 127.0.0.1

　　$cfg [' Servers '] [$i] [' Port ']: The port number of the MySQL server. The default null value represents Port 3306. If you use localhost as the hostname, MySQL will ignore the port number to use the socket connection, so if you want to connect to a Non-default port, you need to set the $cfg[' Servers ' [$i] [' host '] to 127.0.0.1 or to the real host name.

　　$cfg [' Servers '] [$i] [' socket '] : The default value is NULL, and if you want to know the correct socket, you can view the MySQL configuration or execute the status command on the MySQL client command line.

　　$cfg [' Servers '] [$i] [' SSL '] : Configure whether SSL secure connections are used when connecting to the MySQL server.

　　$cfg [' Servers '] [$i] [' Connect_type '] : Configure the type of connection to the MySQL server. Optional sockets and TCP. Default is TCP

　　$cfg [' Servers '] [$i] [' extension ']: Configure the database type of the PHP extension connection, Need to correspond to the database extensions enabled in the php.ini configuration file, you can choose MySQL or mysqli, and the current default extension is MySQL.

　　$cfg [' Servers '] [$i] [' Compress '] : Configure whether to use the compression protocol to connect to the MySQL server (PHP 4.3.0 and above).

　　$cfg [' Servers '] [$i] [' Controluser '] and $cfg[' Servers '] [$i] [' Controlpass '] : This account function I did not use, next time after the introduction of the introduction.

　　$cfg [' Servers '] [$i] [' Auth_type ']: Configure phpMyAdmin Login authentication method, a total of four kinds: config, cookies, HTTP, signon authentication. Cookie authentication, username and password are stored in the cookies, the session will be deleted after the end. $cfg[' Allowarbitraryserver '] is used in conjunction with the previous introduction to log on to any server. Signon certification I have no use, next time to see scripts/signon.php again to introduce.

　　$cfg [' Servers '] [$i] [' Auth_http_realm ']: This configuration option is related to the phpMyAdmin authentication method HTTP, you can customize the HTTP authentication when the user received the prompt information.

　　$cfg [' Servers '] [$i] [' Auth_swekey_config ']: null by default, mainly for hardware certification.

　　$cfg [' Servers '] [$i] [' User '] and $cfg[' Servers '] [$i] [' Password ']: Config authentication method to connect the MySQL server username and password. The password is to fill in config authentication, others as long as left blank.

　　$cfg [' Servers '] [$i] [' signonsession ']: Session at the time of signon authentication.

　　$cfg [' Servers '] [$i] [' Signonurl ']: The URL address of the signon when the login is certified.

　　$cfg [' Servers '] [$i] [' Logouturl ']: The URL address to jump when phpMyAdmin exits.

　　$cfg [' Servers '] [$i] [' Nopassword ']: Configure whether to allow logon with a blank password when phpMyAdmin logon fails.

　　$cfg [' Servers '] [$i] [' only_db ']: Configure the name of one or a set of databases displayed on the left, which appears as a string or array, and is visible only to users.

　　$cfg [' Servers '] [$i] [' hide_db '] : Configure a database that needs to be hidden.

The configuration options defined in the two phpMyAdmin configuration files can be defined by wildcard ambiguity, which is introduced next time.

　　$cfg [' Servers '] [$i] [' Verbose '] : Configure the detailed name of this host, and the host name will be displayed if the configuration is empty. When the configuration uses HTTP authentication, all non-ASCII characters are deleted.

　　$cfg [' Servers '] [$i] [' pmadb ']: Mainly used to activate the phpMyAdmin of the additional features of the linked table, specific reference to the phpMyAdmin installation configuration tutorial. The next introduction to the PMADB feature in the phpMyAdmin configuration file.

　　$cfg [' Servers '] [$i] [' Verbose_check '] : If you know that your pma_* table is up to date, you can configure it to false to improve performance.

　　$cfg [' Servers '] [$i] [' Allowroot ']: Configure whether root user access is allowed.

　　$cfg [' Servers '] [$i] [' Allownopassword ']: Configure whether to allow logon with a blank password.

　　$cfg [' Servers '] [$i] [' Allowdeny '] [order ']: Configure the sequence of host authentication, empty is not available. Can be configured in two order, ' Deny,allow ', that is, any client that is not blocked or the allowed client will be allowed access to the server. ' Allow,deny ', that is, any client that is not allowed or a blocked client will be barred from accessing the server.

　　$cfg [' Servers '] [$i] [' Allowdeny '] [' rules ']: corresponding to the host authentication order configuration option, which is used to define the specific rules, is introduced separately next time.

　　$cfg [' Servers '] [$i] [' Disableis ']: Configure whether to prohibit the use of information_schema

　　$cfg [' Servers '] [$i] [' Showdatabasescommand ']: It may be slow to display a specific database name through the default show DATABASES command when the database is quite large, You can then configure additional command commands to replace it. There are examples in the phpMyAdmin configuration file config.default.php, such as using like.

　　$cfg [' Servers '] [$i] [' Counttables ']: Configure whether the total number of data tables in each database is displayed in the database list on the left.

　　$cfg [' Servers '] [$i] [' tracking_version_auto_create ']: Configure whether the version of the table and view is automatically created.

　　$cfg [' Servers '] [$i] [' tracking_default_statements '] : Configure a list of commands that automatically create a new version.

　　$cfg [' Servers '] [$i] [' Tracking_add_drop_view '] : Configure whether the drop view if EXISTS statement is added to the first line of the journal when the view is created.

　　$cfg [' Servers '] [$i] [' tracking_add_drop_table '] : Configure whether the drop table if EXISTS statement is added to the first line of the log when the datasheet is created.

　　$cfg [' Servers '] [$i] [' Tracking_add_drop_database '] : Configure whether to add a drop database if EXISTS statement to the first line of the journal when the database is created.

The above several phpMyAdmin configuration options are essentially confirmation of whether to add the corresponding DROP statement when importing the exported data using phpMyAdmin.

At this point, the phpMyAdmin configuration file in the Servers option description and use of the method is done, in fact, if you carefully study the phpMyAdmin configuration file, the use of phpMyAdmin will have great benefits, Additional configuration options in the phpMyAdmin configuration file will be introduced in the future.

　　Note : PHP Web Development Tutorials-leapsoul.cn Copyright, reproduced in the form of links to indicate the original source and this statement, thank you.