Home >Backend Development >PHP Tutorial >PHPMYADMIN concise installation tutorial recommended_PHP tutorial
1. First download phpmyadmin from the Internet, and then decompress it to an accessible web directory (if it is a virtual space, you can decompress it and upload it to the web directory through ftp, etc.). Of course, you can modify the name of the decompressed file.
2. 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:
A. Visit the URL
$cfg[ 'PmaAbsoluteUri'] = ''; Fill in the access URL of phpmyadmin here
B.mysql host information
$cfg['Servers'][$i]['host'] = 'localhost'; / /MySQL hostname or IP address
Fill in the ip address of localhost or 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 for default port
mysql port, if it is the default 3306, leave it blank
C.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 neededThe password corresponding to the above mysql user name
D. Authentication method
$cfg['Servers'][$i]['auth_type'] = 'cookie';
here There are four modes to choose from, cookie, http, HTTP, 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 is 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:
PHP installation mode is Apache, you can use http and cookies;
PHP installation mode is CGI, you can Using cookies
E. Phrase password (blowfish_secret) setting
$cfg['blowfish_secret'] = '';
If the authentication method is set to cookie, you need to set the phrase password, which is placed in settings The password is up to you, but it cannot be left blank, otherwise an error will be prompted when logging in to phpmyadmin
Ok, so far, you have successfully installed phpmyadmin, it’s easy, log in and experience it now
Note:
This document only explains the basic configuration of installing phpmyadmin. For detailed description of each configuration parameter in the config.default.php file, please refer to the next article of Script House.