Manually install phpmyadmin under windows

1. Go directly to the official website to download the file, phpMyAdmin-4.3.7-all-languages.zip

2. Unzip it to the web directory and name it phpMyAdmin (I nginx is used here, and the web root directory is configured as E:\webroot)

3. Configure the config file, open the config.default.php file under libraries, find the following items in turn, and configure them according to the instructions ：

(1) Access URL

$cfg['PmaAbsoluteUri'] = '';这里填写phpmyadmin的访问网址 ,我这里为http://localhost:8088/phpMyAdmin

(2) mysql host information

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

Fill in the localhost or the IP address of the server where mysql is located, if mysql On the same server as the phpmyadmin, use the default localhost

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

mysql port. If it is the default 3306, leave it empty.

(3)mysql username and password

$cfg['Servers'][$i]['user'] = 'root'; // MySQL user 访问phpmyadmin使用的mysql用户名 
fg['Servers'][$i]['password'] = ''; // MySQL password (only needed对应上述mysql用户名的密码

(4) Authentication method

$cfg['Servers'][$i]['auth_type'] = 'cookie';

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

config method is to enter the access URL of phpmyadmin to enter directly without entering 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, you can use cookies

(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, but it cannot be left blank, otherwise an error will be prompted when logging in to phpmyadmin.

The installation is complete!

Recommended related articles and tutorials: phpmyadmin tutorial

The above is the detailed content of Manually install phpmyadmin under windows. For more information, please follow other related articles on the PHP Chinese website!