Ideal for database managers unfamiliar with database operation commands, let me just say how to install the tool:
1. First go to the Internet to download phpMyAdmin, and then extract to the access to the Web directory (if it is virtual space, you can extract the FTP after uploading to the web directory), of course, you can modify the extracted after the name of the file.
2. Configure config file
Open the config.default.php file under libraries, locate the following sequence, and follow the instructions to configure it:
A. Visit the Web site
Reference:
$cfg [' pmaabsoluteuri '] = '; here to fill in the phpMyAdmin visit URL
B.mysql Host Information
Reference:
$cfg [' Servers '] [$i] [' host '] = ' localhost '; MySQL hostname or IP address
Fill in the IP address of the localhost or MySQL server, if MySQL and the phpMyAdmin are on the same server, press default localhost
$cfg [' Servers '] [$i] [' port '] = '; MySQL Port-leave blank for default port
MySQL port, if the default is 3306, leave blank
c.mysql user name and password
Reference:
$cfg [' Servers '] [$i] [' user '] = ' root '; MySQL user access phpMyAdmin use MySQL username
fg[' Servers ' [$i] [' password '] = '; MySQL password (only needed the password for the MySQL user name above)
D. Authentication Methods
Reference:
$cfg [' Servers '] [$i] [' auth_type '] = ' cookie ';
Here are four modes to choose from, Cookie,http,http,config
Config mode is to enter the phpMyAdmin access URL can be directly entered, without entering a username and password, is not safe, do not recommend use.
When the entry is set to Cookie,http or HTTP, the login phpMyAdmin requires a data username and password to authenticate, as follows:
PHP installation mode is Apache, you can use HTTP and cookies;
PHP installation mode is CGI, you can use cookies
E. Phrase password (blowfish_secret) settings
Reference:
$cfg [' blowfish_secret '] = ';
If the authentication method is set to a cookie, you need to set the phrase password, set why the password, it is up to you, but you cannot leave it blank, otherwise you will be prompted for error when you log in phpMyAdmin
OK, so far, you have successfully installed the phpMyAdmin, simple, quickly login experience under the
Description
This document describes only the basic configuration of the installation phpMyAdmin, and detailed instructions for each configuration parameter in the config.default.php file can be
phpMyAdmin is a MySQL database management tool, after the installation of the tool, that is, the Web form can directly manage the MySQL data, without the need to execute system commands to manage, is very suitable for database operation commands unfamiliar database managers, the following detailed description of the tool installation method.
First, download
1, first to the official site Download phpMyAdmin installation package: http://www.phpmyadmin.net/(Installation contains a variety of languages all-languages)
2, and then extract to the Web can access the directory, if it is virtual space, can be extracted through the FTP tool uploaded to the Web directory, and you can modify the extracted after the name of the file (you can customize the directory name).
Second, the configuration
3, open the/libraries/config.default.php file (the old version is the root of the config.inc.php file), with WordPad (do not use Notepad, this is UTF8 code) for editing, according to the description configuration can be.
4, find $cfg [' Pmaabsoluteuri ']= ']; Modify the URL for the phpmyadmin 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 cookies.
Here are four modes to choose from: Cookie,http,http,config
①config Way is to enter the phpMyAdmin access URL directly, no need to enter user name and password, is not safe, not recommended.
② set cookie,http,http mode, login phpMyAdmin need data username and password to authenticate.
Specific as follows: The PHP installation mode is 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 to your database name; If you want to build a server, then leave the recommendation blank
10, find $cfg [' defaultlang '] = ' en '; Here is the choice of language, en represents the meaning of Simplified Chinese
11, find $cfg[' blowfish_secret '] = '; If the authentication method is set to a cookie, you need to set the phrase password, set why the password, it is up to you, you can not leave this blank, otherwise you will be prompted as shown in the following image when you log in phpMyAdmin.
12, set up after the save, can now upload to cyberspace, browse http://site domain name/phpmyadmin/test. (Enter the username and password for the database)
If you want to appear during installation: "phpMyAdmin-error is missing mysqli extension." Check your PHP configuration. Error The
workaround is as follows:
① 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, continue to find the following sentence $cfg[' Servers '] [$i] [' extension ']= ' mysqli ' ; and remove its annotations.
③ If no $cfg[' Servers ' [$i] [' extension ']= ' MySQL ' is found, the $cfg[' Servers '] [$i] [' extension ']= ' mysqli '; $cfg [' Servers '] [$i] [' extension ']= ' MySQL '; Statement. (that is, ensure that the "MySQL" value takes effect)
