PHPMyadmin configuration file (configuration ),

PHPMyadmin configuration file (configuration ),
The content of the PHPMyadmin configuration file config. inc. php is as follows. Related comments are added to the configuration. It is very suitable for database managers who are unfamiliar with database operation commands. Next I will explain how to install the tool:
1. First download from the InternetPhpmyadmin, decompress it to the accessible web directory (if it is a virtual space, decompress it and upload it to the web directory through ftp). Of course, you can modify the name of the file after decompression.
2. Configure the config fileOpen the config. default. PHP file, find the following items in sequence, and configure according to instructions:. access URL reference: $ cfg ['pmaabsoluteuri '] = ''; enter the phpmyadmin access URL here.
B. mysql host informationReference: $ cfg ['servers'] [$ I] ['host'] = 'localhost'; // enter the IP address of the localhost or MySQL server in the mysql hostname or IP address field, if mysql and phpmyadmin are on the same server, press the default localhost $ cfg ['servers'] [$ I] ['Port'] = ''; // MySQL port-leave blank for default port mysql port. If it is 3306 by default, leave it blank.
C. mysql user name and passwordReference: $ cfg ['servers'] [$ I] ['user'] = 'root '; // MySQL user used by phpmyadmin to access mysql user fg ['servers'] [$ I] ['Password'] = ''; // MySQL password (only needed corresponds to the password of the above mysql user nameD. Authentication MethodReference: $ cfg ['servers'] [$ I] ['auth _ type'] = 'cookies'. There are four modes available here: cookie, http, HTTP, 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 use the data username and password for verification to log on to phpmyadmin. For details, refer to the following: PHP installation mode is Apache, and http and cookie can be used; the PHP installation mode is CGI and cookie can be used.
E. Set the phrase password (blowfish_secret)Reference: $ cfg ['blowfish _ secret '] = ''; if the authentication method is set to cookie, you need to set the phrase password and the setting password. It is up to you to decide, however, you cannot leave it blank. Otherwise, an error will be prompted when you log on to phpmyadmin. By now, you have successfully installed phpmyadmin. Make it easy. log on to the console and try again.
Note: This document only describes the basic configuration for installing phpmyadmin. For details about the configuration parameters in the config. default. php file, you can
PhpMyAdmin is a MySQL database management tool. After the tool is installed, you can directly manage MySQL Data in the form of web, instead of executing system commands, it is very suitable for database managers who are unfamiliar with database operation commands. The following describes the installation method of this tool in detail.1. Download1. first go to the official site to download phpMyAdmin installation package: http://www.phpmyadmin.net/(installation contains all-languages) 2, and then decompress the web can access the directory, if it is a virtual space, you can decompress the package and upload it to the web directory using the ftp tool. You can also modify the name of the extracted file (you can customize the directory name ).
Ii. Configuration3. Open/libraries/config. default. PHP file (the old version is config in the root directory. inc. PHP file), use a WordPad (do not use Notepad, this is UTF8 encoding) for editing, follow the instructions to configure. 4. Search for $ cfg ['pmaabsoluteuri '] = ''; // modify the phpMyAdmin URL that will be uploaded to the space, for example, $ cfg ['pmaabsoluteuri'] = 'HTTP: // website domain name/phpmyadmin/'; 5. Search for $ cfg ['servers'] [$ I] ['host'] = 'localhost'; // The default value is usually used, there are also exceptions. You do not need to modify 6. Search for $ cfg ['servers'] [$ I] ['auth _ type'] = 'config '; // debug config in your own machine; if the network space uses cookies. there are four modes to choose from: cookie, http, HTTP, config ① config: You can directly access the phpMyAdmin access URL without entering the user name and password, which is insecure, it is not recommended. ② Set the cookie, http, and HTTP methods. to log on to phpMyAdmin, you need the data username and password for verification. Specifically, the PHP installation mode is Apache, and http and cookie can be used. The PHP installation mode is CGI and cookie can be used. 7. find $ cfg ['servers'] [$ I] ['user'] = 'root '; // MySQL username 8. Search for $ cfg ['servers'] [$ I] ['Password'] = ''; // MySQL password (only leave the value of needed blank) 9. find $ cfg ['servers'] [$ I] ['only _ db'] = ''; // you can set only one data, set your database name. If you want to set up a server, we recommend that you leave 10 blank and search for $ cfg ['defaultlang '] = 'zh'; // select a language, zh stands for the meaning of Simplified Chinese 11. find $ cfg ['blowfish _ secret'] = ''; // If the authentication method is set to cookie, you need to set the phrase password, it is up to you to decide why to set the password. leave it blank. Otherwise, an error as shown in will be prompted when you log on to phpMyAdmin.

12. Save the settings. Now you can upload the file to the network space. View http: // website domain name/phpmyadmin/and test it. (Enter the database user name and password)

If the following error occurs during installation: "phpMyAdmin-error: mysqli extension is missing. Check the PHP configuration ." Error.The solution is as follows:① Find the $ cfg ['servers'] [$ I] ['extension'] = 'mysql'; statement in the \ libraries \ config. default. php file in the phpmyadmin folder. ② If $ cfg ['servers'] [$ I] ['extension'] = 'mysql'; is found, continue to find the following $ cfg ['servers'] [$ I] ['extension'] = 'mysqli'; and remove the comment. ③ 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, make sure that the "mysql" value takes effect)

 

<? Php/* $ Id: config. inc. php, v 1.204.2.1 2003/10/10 14:24:24 nijel Exp $ * // vim: expandtab sw = 4 ts = 4 sts = 4:

/*** PhpMyAdmin Configuration File *** All directives are explained in Documentation.html */

 

/*** Sets the php error reporting-Please do not change this line! */If (! Isset ($ old_error_reporting) {error_reporting (E_ALL); @ ini_set ('display _ errors ', '1 ');}

 

/*** Your phpMyAdmin url ** Complete the variable below with the full url ie * http://www.your _ web.net/path_to_your_phpMyAdmin_directory/ ** It must contain characters that are valid for a URL, and the path is * case sensitive on some Web servers, for example Unix-based servers. ** In most cases you can leave this variable empty, as the correct value * will be detected automatically. however, we recommend that you do * test to see that the auto-detection code works in your system. A good * test is to browse a table, then edit a row and save it. there will be * an error message if phpMyAdmin cannot auto-detect the correct value. ** If the auto-detection code does work properly, you can set to TRUE the * $ cfg ['pmaabsoluteuri _ disablewarning'] variable below. */$ cfg ['pmaabsoluteuri '] = ''; ----- set the URL of your phpmyadmin, for example, http: // localhost/phpmyadmin/