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

Editor to share with you how to configure phpmyadmin, I believe that 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!

Download phpMyAdmin and extract it, open the config.default.php file in the libraries directory, find the following items in turn, and configure according to the instructions.

(1) visit the website

$cfg ['PmaAbsoluteUri'] =''; / / fill in the URL of phpMyAdmin here

(2) MySQL host information

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

Enter the ip address of the server where 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, which defaults to 3306, can be left blank. If you used another port when installing MySQL, you need to enter it here.

(3) MySQL username and password

$cfg ['Servers'] [$I] [' user'] = 'root'; / / enter the MySQL user name used by MySQL to access phpMyAdmin. The default is rootfg [' Servers'] [$I] ['password'] ='; / / enter the password corresponding to the above MySQL user name

(4) Authentication method

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

For security reasons, it is recommended to enter cookie here. There are four modes to choose from, 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

The PHP installation mode is CGI, and 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, and it is up to you to decide why. You can't leave it blank here, otherwise you will be prompted with the error shown in the following figure when logging in to phpMyAdmin.

The above is all the contents of the article "how to configure phpmyadmin". 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.