phpMyAdmin concise installation tutorial_PHP tutorial

phpMyAdmin concise installation tutorial_PHP tutorial 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.

下载地址：

PHPMyadmin

1. Download

First, download phpMyAdmin concise installation tutorial_PHP tutorial from Duote Software Station, or you can download it from the phpMyAdmin concise installation tutorial_PHP tutorial official website, and then unzip it to the web In an accessible directory, 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.

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 concise installation tutorial_PHP tutorial 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 concise installation tutorial_PHP tutorial 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 username and password

$cfg['Servers'][$i]['user'] = 'root'; // Fill in MySQL access The MySQL username used by phpMyAdmin concise installation tutorial_PHP tutorial, 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 here, cookie, http, HTTP, config

The config method is to enter the access URL of phpMyAdmin concise installation tutorial_PHP tutorial 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 concise installation tutorial_PHP tutorial requires a data username and password for verification, as follows:

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 concise installation tutorial_PHP tutorial.

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

http://www.bkjia.com/PHPjc/446945.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/446945.htmlTechArticlephpMyAdmin concise installation tutorial_PHP tutorial 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 to manage, non...