Detailed phpMyAdmin Simple Installation tutorial

Simply put, phpMyAdmin is a MySQL management tool that, when installed, can directly manage MySQL data through the web, without the need to perform system commands to manage it,

is ideal for database managers unfamiliar with database operation commands, Next I'll say how to install the tool:





1. First to the Internet to download phpMyAdmin , and then extract to the Web directory can be accessed (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 Libraries under the config.default.php file, locate the following sequence, according to the description of the configuration can be:


A. Visit Web site


Reference:


$cfg [' pmaabsoluteuri '] = '; here to fill out phpMyAdmin's visit URL





b.mysql host information


Reference:


$cfg [' Servers '] [$i] [' host '] = ' localhost '; MySQL hostname or IP address


fill in the IP address of the server where localhost or MySQL resides, 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 the default is 3306, leave blank to





c.mysql username and password


Reference:


$cfg [' Servers '] [$i] [' user '] = ' root '; MySQL user access phpMyAdmin used MySQL username


fg[' Servers ' [$i] [' password '] = '; MySQL password (only needed corresponds to the above MySQL username password


D. Authentication method
Reference:


$cfg [' Servers '] [$i] [' auth_type '] = ' cookie ';


Here are four modes to choose from, Cookie,http,http,config


Config mode that is to enter the phpMyAdmin access URL can directly enter, without entering user name and password, is not safe, do not recommend use.


when the entry is set to Cookie,http or HTTP, the login phpMyAdmin requires the 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, you decide, but you can not leave blank, otherwise you will be prompted to log in phpMyAdmin error


OK, so far, you have successfully installed phpMyAdmin, simple, and quickly login experience under the bar





Description:


This document describes only the basic configuration of the installation phpMyAdmin, the 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, very suitable for database operation commands unfamiliar database managers, The installation method for the tool is described in detail below.


One, download
1, first to the official site Download phpMyAdmin installation package: http://www.phpmyadmin.net/(Installation contains various 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).





II, 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 the UTF8 encoding) for editing, according to the instructions configured.


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 the


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: 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 can be)


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 it is recommended to leave 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://website domain name/phpmyadmin/test. (Enter the username and password for the database)

If you are in the process of installing: "phpMyAdmin-error is missing mysqli extension." Check your PHP configuration. Error
The workaround is as follows:
① to the librariesconfig.default.php file in the phpMyAdmin folder: $cfg [' Servers '] [$i] [' extension ']= ' MySQL ';
② 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 is valid)