How to install and configure PHPmyadmin under Windows?

How to install and configure PHPmyadmin under Windows?

1. Install the phpMyAdmin graphical management tool

Extract the downloaded "phpMyAdmin-2.11.5-all-languages.rar" file to the Apache home directory. The decompressed name is "phpMyAdmin-2.11. 5-all-languages", where 2.11.5 is the version number of phpMyAdmin. For ease of use, you can rename the decompressed folder to phpMyAdmin.

2. Configuring the phpMyAdmin graphical management tool

Copy config.default.php in the libraries directory under the phpMyAdmin installation directory to the phpmyAdmin root directory and rename it to config.inc.php. Then use the Dreamweaver development tool to open the config.inc.php file and position the cursor at the specified identification line. The initial value setting of the config.inc.php file is as shown in the figure below:

Before configuration:

##After configuration:

$cfg['PmaAbsoluteUri'] is to set the phpMyAdmin URL.

$cfg['blowfish_secret'] sets the access method to cookie. This machine does not need to be set, but the network needs to be set to cookie.

$cfg['Servers'][$i]['auth_type'] is used to set the login method of phpMyAdmin. There are three login methods that can be set:

config, http and cookie. Among them, config is the default login method, which means that the user can log in directly after correctly entering the user name and password; if you use http to log in, a dialog box will pop up, prompting you to enter the user name and password; if you use cookie to log in, after accessing phpMyAdmin A login page will open, prompting the user to enter the username and password, and saving the username and password in the system's cookies. The username and password will automatically be displayed in the text box and password input box the next time they visit, usually used on the Internet. .

$cfg['Servers'][$i]['user'] is used to set the user name of the MySQL database.

$cfg['Servers'][$i]['password'] is used to set the password for the MySQL database.

The username and password set here are the username and password that already exist in the database. If the username and password set do not exist in the database, they will not be used.

Note:

If the reader does not use the Dreamweaver tool to open the config.inc.php file, the corresponding line numbers will be different. The reader can search for related keywords, such as, "[ 'auth_type']" to search and locate, and then change the corresponding configuration file.

After the setting is completed, save the config.php file and enter "localhost/phpMyAdmin" in the browser. The user login dialog box will pop up, as shown below:

Enter the correct user name and password at this time (when we install MySQL here, set the user name of the MySQL database to "root" and the password to "root") to enter the main page of phpMyAdmin.

This is all about installing and configuring PHPmyadmin under Windows. Now we will introduce to you the installation of PHPmyadmin. For details, please read "

How to install and configure PHPmyadmin under Linux?" 》

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