Phpmyadmin configuration file description

PhpMyAdmin is a software tool written in PHP. With phpmyadmin, we can control and operate MySQL databases on the web. For those who do not know the MySQL Command, using phpMyAdmin is a very good choice. This article will share with you a detailed explanation of the phpmyadmin configuration file.

First, we need to know that the phpmyadmin configuration file is generally named config. inc. php (root directory), config. default. php (in the root directory or in the libraries directory under the root directory) has so many names because phpmyadmin versions are different.

Next, open the phpmyadmin configuration file, find the following items in sequence, and follow the instructions to configure them:

Access URL

$ Cfg ['pmaabsoluteuri '] = ''; enter the phpmyadmin access URL here.

Mysql host information

$ Cfg ['servers'] [$ I] ['host'] = 'localhost'; // enter the IP address of the localhost or mysql server, if mysql and phpmyadmin are on the same server, press the default localhost
$ Cfg ['servers'] [$ I] ['Port'] = ''; // mysql port. If it is 3306 by default, leave it blank.

Mysql user name and password

$ Cfg ['servers'] [$ I] ['user'] = 'root'; // MySQL user used by phpmyadmin to access the mysql user name
Fg ['servers'] [$ I] ['Password'] = ''; // MySQL password (only needed corresponds to the password of the above mysql user name

Authentication Method

$ Cfg ['servers'] [$ I] ['auth _ type'] = 'cooker ';

There are four authentication modes available: cookie, http, HTTP, config

In config mode, you can directly access the phpmyadmin access URL without entering the user name and password. It is insecure and is not recommended.
When this option is set to cookie, http, or HTTP, You need to verify the data username and password to log on to phpmyadmin. The details are as follows:
The PHP installation mode is Apache, and http and cookie can be used;
The PHP installation mode is CGI and cookie can be used.

Set the phrase password (blowfish_secret)

$ Cfg ['blowfish _ secret'] = '';

If the authentication method is set to cookie, you need to set the phrase password and set the password, which is determined by yourself, but cannot be left blank. Otherwise, an error will be prompted when you log on to phpmyadmin.

In addition, if the following error occurs during phpmyadmin installation: "phpMyAdmin-error: mysqli extension is missing. Check the PHP configuration ." Error. The general solution is as follows:

(1) Find the phpmyadmin configuration file and find the statement $ cfg ['servers'] [$ I] ['extension'] = 'mysql' in the code.

(2) If $ cfg ['servers'] [$ I] ['extension'] = 'mysql' is found, continue to find the following $ cfg ['servers'] [$ I] ['extension'] = 'mysqli'; and remove the comment.

(3) If $ cfg ['servers'] [$ I] ['extension'] = 'mysql'; is not found, put the $ cfg ['servers'] [$ I] ['extension'] = 'mysqli'; statement, change to $ cfg ['servers'] [$ I] ['extension'] = 'mysql'; Statement (that is, ensure that the "mysql" value takes effect ).

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

$ Cfg ['pmanorelation _ DisableWarning ']: it is related to the configuration options of $ cfg ['servers'] [$ I] ['pmadb, if no primary or external data table exists in the database, an error is displayed on the "Structure" page of the database. If you do not want to see it, 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 is displayed. If no mcrypt extension is displayed, set it to True.

$ Cfg ['allowthirdpartyframing ']: whether to allow phpmyadmin to be included in documents in other domains. Setting it 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. 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, use Gzip to compress the output cache. There are three options in total: 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 an HTTPS connection

$ Cfg ['exectimelimit ']: sets 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']: The Session storage directory. It is similar to the session_save_path parameter in the PHP. INI configuration file. It is empty by default.

$ Cfg ['memorylimit ']: sets 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, so that the locked table may be displayed.

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

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

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

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

$ Cfg ['logincookievalidity ']: configures the cookie logon validity period. Note that. INI configuration option session. gc_maxlifetime may limit 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']: Indicates whether to delete all the cookies that are logged in when you exit.

$ 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 the execution is disabled by default.

$ Cfg ['verbosemultisubmit ']: determines 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.

Articles you may be interested in

• How to Set automatic login for phpmyadmin
• PhpMyAdmin Cannot start session without errors error Solution
• Where is the CMS database configuration file?
• How to Set automatic phpmyadmin login and cancel Automatic Login
• Php. ini configuration Manual
• Php uses the ZipArchive function to compress and decompress files.
• PhpMyAdmin does not allow empty password login Solution
• Php error_log () writes error messages to a file