phpMyAdmin program installation explanation

[Introduction] phpMyAdmin program installation explanation is a MySQL database management tool. After installing this tool, you can directly manage MySQL data through the web without the need to execute system commands. It is very suitable for those who are not familiar with database operation commands. Database manager, detailed explanation below

phpMyAdmin program installation explanation is a MySQL database management tool. After installing this tool, you can directly manage MySQL data through the web without the need to execute system commands. It is very suitable For database administrators who are not familiar with database operation commands, the installation method of this tool is explained in detail below.

1. Download

First, download phpMyAdmin program installation explanation from Duote Software Station, or you can download it from the phpMyAdmin program installation explanation official website, and then unzip it to a directory that can be accessed by the web. If It is a virtual space that can be decompressed and uploaded to the web directory through the ftp tool. At the same time, you can modify the name of the decompressed file.

2. Configuration

Open the config.default.php file in the libraries directory, find the following items in order, and configure them according to the instructions.

1. Access URL

$cfg['PmaAbsoluteUri'] = '';Fill in the access URL of phpMyAdmin program installation explanation here.

2. MySQL host information

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

Fill in the ip address of localhost or the server where MySQL is located. If MySQL and the phpMyAdmin program installation explanation are on the same server, press the default localhost

$cfg['Servers'][$i]['port '] = ''; // MySQL port - leave blank for default port

MySQL port, the default is 3306, just leave it blank. If you use other ports when installing MySQL, you need to fill it in here .

3. MySQL user name and password

$cfg['Servers'][$i]['user'] = 'root'; // Fill in MySQL access The MySQL username used by phpMyAdmin program installation explanation, which defaults to root.

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

4. Authentication method

$cfg['Servers'][$i]['auth_type'] = 'cookie'; taking into account security factors, it is recommended Fill in cookies here.

There are four modes to choose from, cookie, http, HTTP, config

The config mode means entering the access URL of phpMyAdmin program installation explanation to enter directly without entering the user name and password. Safe, not recommended.

When this item is set to cookie, http or HTTP, logging in to phpMyAdmin program installation explanation requires a data username and password for verification, as follows:

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

PHP installation mode is CGI and cookies can be used.

5. Setting of phrase password (blowfish_secret)

$cfg['blowfish_secret'] = ''; If the authentication method is set to cookie, you need to set the phrase password , it is up to you to decide what password to set. It cannot be left blank, otherwise an error will be prompted when logging in to phpMyAdmin program installation explanation.

After the installation is completed, we can access it in the browser, as shown below:

The above is the detailed content of phpMyAdmin program installation explanation. For more information, please follow other related articles on the PHP Chinese website!