Shulou(Shulou.com)06/01 Report--

Editor to share with you how to manually install phpmyadmin under windows, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

1. Download files directly to the official website, phpMyAdmin-4.3.7-all-languages.zip

2. Extract it to the web directory and name it phpMyAdmin (I use the nginx,web root directory here and configure it as E:\ webroot)

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

(1) visit the website

$cfg ['PmaAbsoluteUri'] =''; fill in the visiting URL of phpmyadmin here, and here is http://localhost:8088/phpMyAdmin

(2) mysql host information

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

Enter the ip address of the server where the localhost or mysql resides. If the mysql and the phpmyadmin are on the same server, press the default localhost

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

The mysql port, if default is 3306, can be left blank.

(3) mysql username and password

$cfg ['Servers'] [$I] [' user'] = 'root'; / / the mysql username used by MySQL user to access phpmyadmin fg [' Servers'] [$I] ['password'] =''; / / MySQL password (only needed corresponds to the password of the above mysql username

(4) Authentication method

$cfg ['Servers'] [$I] [' auth_type'] = 'cookie'

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

In config mode, you can enter the URL of phpmyadmin directly without entering a user name and password, which is not safe and is not recommended.

When this item is set to cookie,http or HTTP, login to phpmyadmin requires data username and password for authentication, as follows:

PHP installation mode is Apache, you can use http and cookie

PHP installation mode is CGI, you can use cookie

(5) the setting of phrase password (blowfish_secret)

$cfg ['blowfish_secret'] =''

If the authentication method is set to cookie, you need to set the phrase password, which is up to you to decide why to set the password, but you can't leave it blank, otherwise you will get an error when logging in to phpmyadmin.

Installation complete!

The above is all the contents of this article entitled "how to install phpmyadmin manually under windows". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.