Home  >  Article  >  Database  >  How to install phpMyAdmin?

How to install phpMyAdmin?

青灯夜游
青灯夜游Original
2019-11-20 13:48:493841browse

phpMyAdmin 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 managers who are not familiar with database operation commands. , the installation method of this tool is explained in detail below.

How to install phpMyAdmin?

Step 1: Download

Search on Baidu to download phpMyAdmin, or you can download it from the official website of phpMyAdmin , and then decompress it to a directory that can be accessed by the web. If it is a virtual space, you can decompress it and upload it to the web directory through the ftp tool. At the same time, you can modify the name of the decompressed file.

How to install phpMyAdmin?

Step 2: Configuration

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

How to install phpMyAdmin?

Step 3: Location access URL

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

How to install phpMyAdmin?

Step 4: MySQL host information

$cfg['Servers'][$i ]['host'] = 'localhost'; // MySQL hostname or IP address fill in localhost or the IP address of the server where MySQL is located. If MySQL and the phpMyAdmin are on the same server, 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 , need to be filled in here.

How to install phpMyAdmin?

How to install phpMyAdmin?

Step 5: MySQL username and password

$cfg['Servers'][$i]['user'] = 'root'; // Fill in the MySQL user name used to access phpMyAdmin. The default is root.

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

How to install phpMyAdmin?

Step 6: Authentication method

$cfg['Servers'][$i] ['auth_type'] = 'cookie'; Considering security factors, it is recommended to fill in cookies here. There are four modes to choose from here, cookie, http, HTTP, config

config mode. Enter the access URL of phpMyAdmin to enter directly. There is no need to enter the user name and password. It is unsafe and not recommended. .

When this item is set to cookie, http or HTTP, logging in to phpMyAdmin 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.

How to install phpMyAdmin?

Step 7: Setting the phrase password (blowfish_secret)

$cfg['blowfish_secret' ] = '';If the authentication method is set to cookie, you need to set a 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.

How to install phpMyAdmin?

Note: It is best to download phpMyAdmin from the official website to ensure the completeness of the content.

After the configuration is completed, if the browser enters http://127.0.0.1/phpmyadmin to log in

The above is the detailed content of How to install phpMyAdmin?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn