Installation configuration of phpmyadmin in win7 environment

1. First download phpmyadmin

2. Unzip it to an accessible web directory (if it is a virtual space, you can unzip it and upload it to the web directory through ftp, etc. ), of course you can also modify the name of the file after decompression.

3. Configure the config file

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

1. Visit the URL

$cfg['PmaAbsoluteUri'] = ''//这里填写phpmyadmin的访问网址

For example:

$cfg['PmaAbsoluteUri'] = '//www.17.com/phpmyadmin';

2, mysql host information

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

Fill in the localhost or the IP address of the server where mysql is located. If mysql and the phpmyadmin are on the same server, press the default localhost

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

mysql port, if it is the default 3306, just leave it empty.

3. mysql username and password

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

4. Authentication method

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

There are four modes to choose from, namely: cookie, http, HTTP and config.

The 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 and cookies can be used.

5. Setting the phrase password (blowfish_secret)

$cfg['blowfish_secret'] = '';

If the authentication method is set to cookie, you need to set the phrase password and cannot leave it blank, otherwise an error will be prompted when logging in to phpmyadmin.

So far, you have successfully installed phpmyadmin.

Recommended related articles and tutorials: phpmyadmin tutorial

The above is the detailed content of Installation configuration of phpmyadmin in win7 environment. For more information, please follow other related articles on the PHP Chinese website!