Description of some configuration options in the phpmyadmin configuration file config. default. php

In the previous phpmyadmin installation and configuration tutorial, I mainly introduced the steps for installing and configuring phpmyadmin, this section briefly involves phpmyadmin configuration. in the previous phpmyadmin installation and configuration tutorial, I mainly introduced the steps for installing and configuring phpmyadmin, which simply involves the phpmyadmin configuration file config. default. descriptions of related configuration options in php. in order to make it easier for you to use phpmyadmin, I plan to introduce the configuration options in the phpmyadmin configuration file several times, the phpmyadmin configuration file config is described in detail today. default. some phpmyadmin configuration options in php.

In earlier phpmyadmin versions, you must set the default configuration file config. default. copy php to the installation root directory and rename it config. inc. php. Currently, phpmyadmin3 is not required for installation and configuration, because phpmyadmin first loads libraries/config. default. php default settings, and then use config. inc. the configuration in php overwrites. If the default value is what you need, you do not need the config. inc. php configuration file. the default configuration file config. default. php of phpmyadmin is stored in the libraries Directory.

　　Phpmyadmin configuration file config. default. php configuration option description

Note that my phpmyadmin configuration file is based on phpmyadmin3.

　　$ Cfg ['pmaabsoluteuri ']: Mainly used to configure the phpmyadmin installation directory in URL mode, such as http: // localhost/path-to-your-phpmyadmin-directory/. pay attention to case sensitivity during configuration, because some systems are case sensitive. Phpmyadmin3 can be automatically detected, so the default value is null.

　　$ Cfg ['pmanorelation _ DisableWarning ']: It depends on the configuration options of $ cfg ['servers'] [$ I] ['pmadb']. If no corresponding primary/external data table exists in the database, the "Structure" page of the database prompts an error. if you do not want to see it, you can set it to True. the default value is False.

　　$ Cfg ['suhosindisablewarning']: If it is set to True, no warning is displayed when Suhosin is detected.

　　$ Cfg ['mcryptdisablewarning']: If no mcrypt extension is available for cookie authentication, an alarm will be displayed. if not, set it to True.

　　$ Cfg ['allowthirdpartyframing ']: Whether to allow phpmyadmin to be included in documents of other domains. setting phpmyadmin to True is a potential security vulnerability.

　　$ Cfg ['blowfish _ secret']: Use the blowfish algorithm to encrypt users' passwords during cookie authentication. If you use cookie authentication, you need to set a random key. The maximum length is 46 characters.

　　$ Cfg ['servers']: Phpmyadmin supports managing multiple Mysql servers. Therefore, the $ cfg ['servers'] array is added to save logon information for different Servers. I will introduce more detailed configuration options next time.

　　$ Cfg ['serverdefault']: If there are multiple configured servers, you can configure $ cfg ['serverdefault'] as one of them, and phpmyadmin will automatically connect. if it is set to 0, A list of servers without logon is displayed. If you only have one server, $ cfg ['serverdefault'] must be set to that server.

　　$ Cfg ['maxdblist']: Maximum number of databases displayed in the database list of the navigation framework. the default value is 100.

　　$ Cfg ['maxtablelist']: After you click the relevant database, the maximum number of data tables is displayed by default. the default value is 250.

　　$ Cfg ['maxcharactersindisplayedsql']: Maximum number of characters displayed in an SQL query. the default value is 1000.

　　$ Cfg ['obgzip ']: If possible, the configuration uses Gzip to compress the output cache. a total of three options are available: True, False, and auto.

　　$ Cfg ['persistentconnections']: Sets whether to use permanent links, that is, mysql_connect or mysql_pconnect in Mysql. the default value is False.

　　$ Cfg ['forcessl ']: Configure whether to force HTTPS connection

　　$ Cfg ['exectimelimit ']: Set the maximum running time of the script. If it is set to 0, there is no limit. the default value is 300 seconds.

　　$ Cfg ['sessionsavepath']: Session storage directory, similar to the session_save_path parameter in the PHP. INI configuration file. the default value is null.

　　$ Cfg ['memorylimit ']: Set the memory available for script running. If it is set to 0, there is no restriction. when setting it, note that it is a string. for example, do not set 32 m to 32

　　$ Cfg ['skiplockedtables ']: Mark the used data table from Mysql3.23.30 to display the locked table.

　　$ Cfg ['showsql']: Whether to display running SQL queries

　　$ Cfg ['allowuserdropdatabase']: Configure whether to allow display of Drop database links to common users except administrator users. the default value is False.

　　$ Cfg ['firm']: Configure to display an alarm prompt when preparing for data loss. the default value is True.

　　$ Cfg ['logincookierecall']: Configure whether to allow the previous login in cookie authentication mode. if you do not configure $ cfg ['blowfish _ secret'], this item is automatically disabled.

　　$ Cfg ['logincookievalidity ']: Configure the valid time for cookie login. Note that the session. gc_maxlifetime option configured in PHP. INI may restrict the validity of the Session. if the Session is lost, the logon cookie will also be invalid. Therefore, it is a good idea to set the session. gc_maxlifetime value not lower than the $ cfg ['logincookievalidity '] value.

　　$ Cfg ['logincookiestore']: Defines how long the cookie can be stored in the browser. the default value is 0, which means that the cookie ends at the end of the current session. this is for untrusted environments.

　　$ Cfg ['logincookiedeleteall']: Whether to delete all logon cookies when you exit the configuration.

　　$ Cfg ['usedbsearch']: Configure whether to enable or disable the database query feature

　　$ Cfg ['ignoremultisubmiterrors ']: When phpmyadmin executes multiple query statements, if one of the query statements fails, whether to continue execution is disabled by default.

　　$ Cfg ['verbosemultisubmit ']: Whether to display the results of each query statement in multiple query statements. the default value is True.

　　$ Cfg ['allowarbitraryserver']: Configure whether to allow you to log on to any server using cookies.

At this point, some configuration options in the phpmyadmin configuration file are described here. next time, we will introduce the Server configuration array in the phpmyadmin configuration file.