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

In this issue, the editor will bring you the installation and configuration steps of phpMyAdmin. The article is rich in content and analyzes and describes for you from a professional point of view. I hope you can get something after reading this article.

PhpMyAdmin is a MySQL database management tool. After installing this tool, you can directly manage MySQL data in the form of web without the need to execute system commands. It is very suitable for database managers who are not familiar with database operation commands.

Step 1: download

Baidu search and download phpMyAdmin, you can also download it from the official website of phpMyAdmin, and then decompress it to a directory that can be accessed by web. If it is a virtual space, you can upload it to the web directory through the ftp tool. At the same time, you can modify the name of the decompressed file.

Step 2: configure

Open the config.default.php file in the libraries directory, find the following items in turn, and follow the instructions to configure.

Step 3: location access to the web site

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

Step 4: MySQL host information

$cfg ['Servers'] [$I] [' host'] = 'localhost'; / / MySQL hostname or IP address fill in the ip address of the server where localhost or 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 for default port MySQL port, default is 3306, leave it blank. If you used another port when installing MySQL, you need to enter it here.

Step 5: MySQL username and password

$cfg ['Servers'] [$I] [' user'] = 'root'; / / fill in the MySQL user name used by MySQL to access phpMyAdmin. The default is root.

Fg ['Servers'] [$I] [' password'] =''; / / fill in the password corresponding to the above MySQL user name.

Step 6: 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 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

The PHP installation mode is CGI, and you can use cookie.

Step 7: 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 it is up to you to decide why the password is set. You can't leave it blank here, otherwise it will cause an error when logging in to phpMyAdmin.

Note: phpMyAdmin is best downloaded from the official website to ensure the integrity of the content.

After the configuration is completed, if the browser enters http://127.0.0.1/phpmyadmin to log in

These are the steps for the installation and configuration of phpMyAdmin shared by the editor. If you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are 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.