PhpMyAdmin installation instructions

PHP100 is the first professional website in China to share PHP resources. It also provides a PHP Chinese communication community. For PHP study researchers: The latest PHP information, original content, open source code and PHP video tutorials and other related content. [Guide] phpMyAdmin is a MySQL database management tool. after installing this tool, you can directly manage MySQL data on the web without executing system commands, it is very suitable for database managers who are unfamiliar with database operation commands. the following details

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.

:	PHPMyadmin

1. Download

First Download phpMyAdmin from the software station of dout, or download it from the official phpMyAdmin website, and then decompress it to the accessible directory on the web. 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.

II. configuration

Open the config. default. php file under the libraries Directory, find the following items in sequence, and configure them according to the instructions.

1. visit the website

$ Cfg ['pmaabsoluteuri '] = ''; enter the phpMyAdmin access url here.

2. MySQL host information

$ Cfg ['servers'] [$ I] ['host'] = 'localhost'; // MySQL hostname or IP address

Enter the ip address of the localhost or MySQL server. 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. the default value is 3306. leave it blank. if you use another port during MySQL installation, enter it here.

3. MySQL User name and password

$ Cfg ['servers'] [$ I] ['user'] = 'root'; // enter the MySQL user name used to access phpMyAdmin. the default value is root.

Fg ['servers'] [$ I] ['password'] = ''; // enter the password corresponding to the above MySQL User name.

4. authentication method

$ Cfg ['servers'] [$ I] ['auth _ type'] = 'cookies'; for security reasons, we recommend that you enter a cookie here.

There are four modes available here: cookie, http, HTTP, config

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 verify the data username and password to log on to phpMyAdmin. The details are as follows:

The PHP installation mode is Apache, and http and cookie can be used;

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

5. set blowfish_secret

$ Cfg ['blowfish _ secret '] = ''; if the authentication method is set to cookie, you need to set the phrase password and the reason for setting the password, which is determined by yourself. you cannot leave it blank here, otherwise, an error is prompted when you log on to phpMyAdmin.

After the installation is complete, we can access it in a browser, as shown in:

The above describes how to install the phpMyAdmin program. For more information, see other related articles in the first PHP community!