The phpMyAdmin configuration file config.inc.php content as follows, adding relevant comments where it needs to be set. Ideal for database administrators who are unfamiliar with database operations commands, here's how to install the tool:
1. First to download onlinephpMyAdmin, and then extracted to the Web directory can be accessed (if it is virtual space, can be extracted via FTP and so upload to the web directory), of course, you can modify the name of the file after decompression.
2. Configure config file
Open the config.default.php file under libraries, locate the following, and then follow the instructions to configure it:
A. Access to the Web site
Reference:
$cfg [' pmaabsoluteuri '] = '; Fill in phpMyAdmin's access URL here
B.mysql Host Information
Reference:
$cfg [' Servers '] [$i] [' host '] = ' localhost '; MySQL hostname or IP address
Fill in the IP address of localhost or MySQL server, and if MySQL and the 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 the default 3306, leave it blank
c.mysql user name and password
Reference:
$cfg [' Servers '] [$i] [' user '] = ' root '; MySQL user access phpmyadmin using the MySQL username
fg[' Servers ' [$i] [' password '] = '; MySQL password (only needed password corresponding to the above MySQL username
D. Authentication methods
Reference:
$cfg [' Servers '] [$i] [' auth_type '] = ' cookie ';
There are four different modes to choose from, Cookie,http,http,config
The Config method is to enter the phpMyAdmin access URL directly, no need to enter the user name and password, is not safe, is not recommended to use.
When the entry is set to Cookie,http or HTTP, the login phpMyAdmin requires a data user name and password for authentication, as follows:
PHP installation mode is Apache, you can use HTTP and cookies;
PHP installation mode is CGI, you can use cookies
E. Setting of the phrase password (blowfish_secret)
Reference:
$cfg [' blowfish_secret '] = ';
If the authentication method is set to a cookie, you will need to set the phrase password, put in the setting why the password, it is up to you to decide, but can not be left blank, or you may be prompted with error when logging in phpMyAdmin
OK, so far, you have successfully installed the phpMyAdmin, simple, quickly login experience it
Description
This document describes only the basic configuration for installing phpMyAdmin, and detailed instructions on each configuration parameter in the config.default.php file can be
PhpMyAdmin is a MySQL database management tool, after the installation of the tool, you can directly manage the MySQL data through the web, without the need to execute system commands to manage, is very suitable for database Operations Command unfamiliar Database manager, the following details the installation method of the tool.
First, download
1, first to the official site Download phpMyAdmin installation package: http://www.phpmyadmin.net/(Installation contains various languages all-languages)
2, re-extract to the Web can access the directory, if it is virtual space, can be extracted through the FTP tool upload to the Web directory, and you can modify the extracted file name (you can customize the directory name).
Second, the configuration
3, open the/libraries/config.default.php file (the old version is the root directory of the config.inc.php file), with WordPad (do not use Notepad, which is UTF8 encoding) for editing, follow the instructions to configure.
4, find $cfg [' Pmaabsoluteuri ']= '; Modify the URL of the phpmyadmin that you will upload to the space
such as: $cfg [' pmaabsoluteuri '] = ' http://website domain name/phpmyadmin/';
5. Find $cfg [' Servers '] [$i] [' host '] = ' localhost '; Usually with the default, there are exceptions, you can not modify
6, find $cfg [' Servers '] [$i] [' auth_type '] = ' config '; Debug in your own machine with config, if the space on the network with a cookie.
Here are four modes to choose from: Cookie,http,http,config
①config mode is to enter the phpMyAdmin access URL directly to enter, no need to enter the user name and password, is not safe, is not recommended to use.
② set cookie,http,http mode, login phpMyAdmin require data user name and password to authenticate.
The following: PHP installation mode for Apache, you can use the HTTP and cookie;php installation mode for CGI, you can use cookies.
7. Find $cfg [' Servers '] [$i] [' user '] = ' root '; MySQL User name
8. Find $cfg [' Servers '] [$i] [' password '] = '; MySQL password (only needed left blank)
9. Find $cfg [' Servers '] [$i] [' only_db '] = '; You only have one data set up, set as your database name, if you want to build a server, then suggest leave blank
10, find $cfg [' defaultlang '] = ' zh '; Here is the language of choice, en stands for Simplified Chinese meaning
11, find $cfg[' blowfish_secret '] = "; If the authentication method is set to a cookie, you will need to set the phrase password, set why the password, by your own discretion, this can not be left blank, otherwise you will be prompted as shown when logging in PhpMyAdmin.
12, set up after the save, can now be uploaded to the network space, browse http://website domain name/phpmyadmin/test. (Enter the user name and password for the database to do so)
If the installation process occurs: "PhpMyAdmin-Error missing mysqli extension. Please check your PHP configuration. Error
Here's how to fix it:
① to the \libraries\config.default.php file in the phpMyAdmin folder: $cfg [' Servers '] [$i] [' extension ']= ' MySQL '; statement.
② If there is found $cfg[' Servers ' [$i] [' extension ']= ' MySQL ', this sentence continues to find the following sentence $cfg[' Servers ' [$i] [' extension ']= ' mysqli '; and remove the notes.
③ if not found $cfg[' Servers ' [$i] [' extension ']= ' MySQL ', this sentence $cfg[' Servers ' [$i] [' extension ']= ' mysqli '; statement, change to $cfg[' Servers '] [$i] [' extension ']= ' MySQL '; Statement. (that is, ensure that the "MySQL" value is valid)
Error Resolution
PhpMyAdmin-Error
The mysqli extension is missing. Please check your PHP configuration. <a href= "Documentation.html#faqmysql" target= "Documentation" >class= "icon" src= "./themes/pmahomme/img/b_help.png" width= "one" height= "one" alt= "document" title= "document"/></a>
Steps to resolve:
1. See if there are php_mysqli.dll files in the ext directory of PHP
If so, continue with the steps below. If you don't have one, reload PHP ^_^
2. Open php.ini, check php.ini, Extension=php_mysqli.dll is not enabled, that is, remove the front; Found it
; Extension=php_mysqli.dll
Put the preceding semicolon ";" Remove, change to
Extension=php_mysqli.dll
3. Find
; extension_dir= "./ext"
Put the preceding semicolon ";" Remove, change to
Extension_dir = "E:\php\ext"
e:\php for PHP storage directory
4, check Lib_mysql.dll has not been copied to the Windows/system32 directory (64-bit system also support) This DLL file has a variety of forms have not underlined libmysql_d.dll so pay attention to their own look
5. View php Details page <?php phpinfo ();?, and see if MySQL and mysqli have been started this step is to check if you have turned on mysqli
4. Restart IIS (not Web site)
6. Login phpMyAdmin Success
phpMyAdmin configuration and Error missing mysqli extension. Please check the PHP configuration
