phpMyAdmin Installation Tutorial

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

phpMyAdmin software Station to download the first, you can also go to the phpMyAdmin official website download, and then extract to the Web can access the directory, if it is virtual space, you can extract the FTP tool uploaded to the Web directory, at the same time you can modify the name of the file after decompression.

Second, the configuration

Open the Libraries directory of the config.default.php file, in turn, find the following items, according to the instructions configured.

1. Visit the website

$cfg [' pmaabsoluteuri '] = '; here, fill in phpMyAdmin's visit URL.

2, MySQL host information

$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, the default is 3306, leave blank, if you install MySQL using the other port, you need to fill in here.

3, MySQL username and password

$cfg [' Servers '] [$i] [' user '] = ' root '; Fill in the MySQL username used by MySQL access phpMyAdmin, default to root.

fg[' Servers ' [$i] [' password '] = '; Fill in the password corresponding to the MySQL username above.

4. Authentication method

$cfg [' Servers '] [$i] [' auth_type '] = ' cookie '; For security reasons, it is recommended to fill in cookies here.

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;

The PHP installation mode is CGI and you can use cookies.

5, phrase password (blowfish_secret) settings

$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 to decide, you can not leave this blank, otherwise you will be prompted when the login phpMyAdmin error.

Once the installation is complete, we can access it in the browser, as shown in the following illustration: