phpMyAdmin configuration file config.default.php Partial configuration options description

In the previous phpMyAdmin installation configuration tutorial, I mainly introduced the steps of phpMyAdmin installation configuration. A brief description of the relevant configuration options in the phpMyAdmin configuration file config.default.php, in order to make it easier for you to use configuration phpMyAdmin, for phpMyAdmin configuration options in the profile, I intend to introduce them several times, today, in detail under the Phpmya Partial phpMyAdmin configuration options in the DMin configuration file config.default.php.

In the early versions of phpMyAdmin, Installing the configuration requires that the phpMyAdmin default profile config.default.php copied to config.inc.php under the installation root, which is not required at present phpmyadmin3 installation configuration because phpMyAdmin first loads libraries The default settings in the/config.default.php, and then overwrite them with the configuration in config.inc.php. If the default value is what you need, then you do not need to config.inc.php the configuration file, phpMyAdmin the default configuration file config.default.php is stored in the Libraries directory.

　　phpMyAdmin configuration file config.default.php configuration options description

Note that my phpMyAdmin configuration file is based on phpmyadmin3.

　　$cfg [' Pmaabsoluteuri ']: Primarily used to configure the phpMyAdmin installation directory as a URL, such as http://localhost/ path-to-your-phpmyadmin-directory/, when configured, is case sensitive according to the system environment, because some systems are case-sensitive. Because phpmyadmin3 can be automatically detected, the default is a null value.

　　$cfg [' pmanorelation_disablewarning ']: With $cfg[' Servers ' [$i] [' pmadb '] configuration options, if there is no corresponding primary/external datasheet in the database, the database " Structure "page will be prompted with an error, if you do not want to see, you can set it to true, the default is False.

　　$cfg [' suhosindisablewarning ']: set to True to not display a warning when Suhosin is detected.

　　$cfg [' mcryptdisablewarning ']: If no mcrypt extension will display the alarm when the cookie is authenticated, set to True if not shown

　　$cfg [' allowthirdpartyframing ']: Allow phpMyAdmin to be included in a document in another domain, set to true will be a potential security vulnerability

　　$cfg [' Blowfish_secret ']: Cookies are authenticated using the Blowfish algorithm to encrypt the user's password. If you use cookie authentication, you need to set a random key. Maximum length of 46 characters

　　$cfg [' Servers ']: Because phpMyAdmin supports managing multiple MySQL servers. Therefore, the $cfg[' Servers ' array is added to hold the login information for the different servers. More detailed configuration options for my next introduction.

　　$cfg [' Serverdefault ']: If there are more than one configured server, you can configure $cfg[' Serverdefault ' to one of them, phpMyAdmin will automatically connect, if configured to 0, A list of servers that are not logged in will be displayed. If you have only one server setting, $cfg [' serverdefault '] must be configured for that server.

　　$cfg [' maxdblist ']: How many databases are displayed in the list of databases in the navigation framework, with a default value of 100

　　$cfg [' maxtablelist ']: How many data tables are displayed by default, with a default value of 250, after clicking on the relevant database

　　$cfg [' Maxcharactersindisplayedsql ']: A SQL query displays up to a maximum number of characters, with a default value of 1000

　　$cfg [' Obgzip ']: If possible, configure to use gzip compression output cache with a total of three options, True, False, auto

　　$cfg [' persistentconnections ']: Set whether to use a permanent link, that is, mysql_connect or mysql_pconnect in MySQL, the default value is False

　　$cfg [' Forcessl ']: Configure whether to force the use of HTTPS connections

　　$cfg [' Exectimelimit ']: Sets the maximum run time for the script. If set to 0 there is no limit, the default value is 300 seconds

　　$cfg [' Sessionsavepath ']: The Save directory for the session, similar to php.ini the Session_save_path parameter in the configuration file, the default is null

　　$cfg [' memorylimit ']: Set the available memory for the script to run. There is no limit to configure 0, you need to pay attention to the string when setting, such as 32M do not set to 32

　　$cfg [' Skiplockedtables ']: marks a used datasheet from Mysql3.23.30, making it possible to display a locked table

　　$cfg [' Showsql ']: whether to display a running SQL query

　　$cfg [' Allowuserdropdatabase ']: Configure whether the drop database link is allowed to be displayed to ordinary users except for the administrator user, false by default

　　$cfg [' Confirm ']: Configure to display an alert prompt when you are ready to lose data, the default value is True

　　$cfg [' Logincookierecall ']: Configured in the cookie authentication mode to allow recall before the login, if you do not configure $cfg[' Blowfish_secret ', this automatic ban

　　$cfg [' logincookievalidity ']: Configure the valid time of cookie login, note that PHP. INI configuration option Session.gc_maxlifetime may limit the validity of the session, and if the session is lost, the login cookie is invalid. So it's a good idea to set the Session.gc_maxlifetime value to be no lower than the $cfg[' logincookievalidity ' value.

　　$cfg [' Logincookiestore ']: Defines how long the cookie in the viewer can be saved, and the default value of 0 means the end of the current session end Cookie, which is for untrusted environments.

　　$cfg [' Logincookiedeleteall ']: Configure whether to delete all cookies that are logged in when exiting

　　$cfg [' Usedbsearch ']: Configure whether to enable or disable database query attributes

　　$cfg [' ignoremultisubmiterrors ']: Configure when phpMyAdmin executes multiple query statements, if one of the queries fails, whether to continue execution, by default, by discarding the execution

　　$cfg [' Verbosemultisubmit ']: Configure whether to display the results of each query statement in multiple query statements, default to True

　　$cfg [' Allowarbitraryserver ']: Configure whether to allow you to log in to any server using cookies.

At this point, the partial configuration options in the phpMyAdmin configuration file are described here, and the server configuration array in the phpMyAdmin configuration file will be introduced next time.

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