Phpmyadmin configuration file Servers configuration option description

After introducing some of the configuration options in the phpmyadmin configuration file, let's talk about how to use the Servers option in the phpmyadmin configuration file, phpmyadmin installation configuration must involve the configuration of the Servers option in the phpmyadmin configuration file. otherwise, phpmyadmin cannot normally access the configuration options in the phpmyadmin configuration file, for more information, see the usage and description of the Servers option in the phpmyadmin configuration file. the installation and configuration of phpmyadmin must involve the configuration of the Servers option in the phpmyadmin configuration file. otherwise, phpmyadmin cannot be accessed normally.

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 save logon information of different Mysql Servers. The first $ cfg ['servers'] [$ I] ['host'] contains the host name 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 default phpmyadmin configuration file config. default. php under the libraries Directory multiple times to the config. inc. php configuration file under the root directory.

　　Phpmyadmin configuration file Servers configuration options

　　$ Cfg ['servers'] [$ I] ['host']: The host name or IP address of the Mysql server. If the PHP environment configuration and Mysql server are 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 indicates port 3306. If localhost is used as the host name, Mysql will ignore the port number and use socket connection instead. Therefore, if you want to connect to a non-default port, you need to set $ cfg ['servers'] [$ I] ['host'] to 127.0.0.1 or a real host name.

　　$ Cfg ['servers'] [$ I] ['socket']: The default value is null. if you want to know the correct socket, you can view the Mysql configuration or execute the status command in the Mysql client command line.

　　$ Cfg ['servers'] [$ I] ['SSL ']: Configure whether to use SSL secure connection when connecting to the Mysql server.

　　$ Cfg ['servers'] [$ I] ['connect _ type']: Configure the type of connection to the Mysql server. Optional socket and tcp. The default value is tcp.

　　$ Cfg ['servers'] [$ I] ['extension']: Configure the database type for the PHP extension connection. it must correspond to the database extension enabled in the PHP. INI configuration file. you can select Mysql or Mysqli. the current default extension is Mysql.

　　$ Cfg ['servers'] [$ I] ['compus']: Configure whether to use the compression protocol to connect to the Mysql server (PHP 4.3.0 or later ).

　　$ Cfg ['servers'] [$ I] ['controluser'] and $ cfg ['servers'] [$ I] ['controlpass']: I have never used this account function. I will introduce it next time.

　　$ Cfg ['servers'] [$ I] ['auth _ type']: Configure the authentication method for phpmyadmin logon. There are four authentication methods in total: config, cookie, http, and signon. Cookie authentication. the user name and password are stored in cookies and will be deleted after the session ends. You can log on to any server with $ cfg ['allowarbitraryserver. I have never used signon authentication. next time, let's take a look at scripts/signon. php.

　　$ Cfg ['servers'] [$ I] ['auth _ http_realm']: This configuration option is related to The phpmyadmin authentication method http. you can customize the prompt message that the user receives during http authentication.

　　$ Cfg ['servers'] [$ I] ['auth _ swekey_config ']: Null by default. it is mainly used for Hardware Authentication.

　　$ Cfg ['servers'] [$ I] ['user'] and $ cfg ['servers'] [$ I] ['password']: The username and password used to connect to the Mysql server during config authentication. The password is entered during config authentication, and you only need to leave it blank.

　　$ Cfg ['servers'] [$ I] ['signonsession ']: Session for signon authentication.

　　$ Cfg ['servers'] [$ I] ['signonurl']: The URL to jump to During signon login authentication.

　　$ Cfg ['servers'] [$ I] ['logouturl']: The URL to jump to when phpmyadmin exits.

　　$ Cfg ['servers'] [$ I] ['nopassword']: Configure whether to allow empty password logon when phpmyadmin logon fails.

　　$ Cfg ['servers'] [$ I] ['only _ db']: One or a group of database names displayed on the left side of the configuration. this configuration option appears as a string or array. you can only see these databases.

　　$ Cfg ['servers'] [$ I] ['hide _ db']: Configure the database to be hidden.

When defining configuration options in the above two phpmyadmin configuration files, you can use wildcard characters to fuzzy define them. next time, we will introduce them again.

　　$ Cfg ['servers'] [$ I] ['verbo']: Configure the detailed name of this host. if the configuration is null, the host name is displayed. When http authentication is configured, all non-ASCII characters are deleted.

　　$ Cfg ['servers'] [$ I] ['pmadb']: It is mainly used to activate the additional features of the phpmyadmin chain table. for details, refer to the phpmyadmin installation and configuration tutorial. NeXT Introduction to the pmadb function in the phpmyadmin configuration file.

　　$ Cfg ['servers'] [$ I] ['verbose _ check']: If you know that your pma _ * table is up-to-date, you can set it to false to improve performance.

　　$ Cfg ['servers'] [$ I] ['allowroot']: Configure whether to allow access by the root user.

　　$ Cfg ['servers'] [$ I] ['allownopassword']: Configure whether to allow logon with a blank password.

　　$ Cfg ['servers'] [$ I] ['lowdeny'] ['order']: Configure the host authentication sequence. if it is left empty, it is unavailable. You can configure two sequence: 'deny, allow', that is, any client that is not prohibited or permitted will be allowed to access the server. 'Allow', deny', that is, any client that is not allowed or that is forbidden will be forbidden to access the server.

　　$ Cfg ['servers'] [$ I] ['lowdeny'] ['rules']: Corresponds to the host authentication sequence configuration option, which is used to define specific rules and will be introduced separately next time.

　　$ Cfg ['servers'] [$ I] ['disableis ']: Whether to disable INFORMATION_SCHEMA.

　　$ Cfg ['servers'] [$ I] ['showdatabasescommand']: When there are quite a few DATABASES, it may be slow to display the specific database name using the default show databases command. in this case, you can configure other command commands to replace it. In The phpmyadmin configuration file config. default. php, there is an example Like ).

　　$ Cfg ['servers'] [$ I] ['counttables ']: Whether to display the total number of data tables in each database in the left-side database list.

　　$ Cfg ['servers'] [$ I] ['tracking _ version_auto_create ']: Configure whether to automatically create tables and views.

　　$ Cfg ['servers'] [$ I] ['tracking _ default_statements']: Configure to automatically create a new command list.

　　$ Cfg ['servers'] [$ I] ['tracking _ add_drop_view ']: Configure whether to add the drop view if exists statement to the first line of the log when the VIEW is created.

　　$ Cfg ['servers'] [$ I] ['tracking _ add_drop_table ']: Configure whether to add the drop table if exists statement to the first line of the log when the data TABLE is created.

　　$ Cfg ['servers'] [$ I] ['tracking _ add_drop_database ']: Configure whether to add the drop database if exists statement to the first line of the log when the DATABASE is created.

The above phpmyadmin configuration options are mainly used to check whether the corresponding DROP statement is added when you use phpmyadmin to import and export data.

At this point, the descriptions and usage of the Servers option in the phpmyadmin configuration file are described. In fact, if you carefully study the phpmyadmin configuration file, it will be very good to use phpmyadmin, other configuration options in the phpmyadmin configuration file will be introduced in the future.