To put it simply, phpmyadmin is a mysql management tool. after installing this tool, you can directly manage mysql data on the web without executing system commands, it is very suitable for database managers who are unfamiliar with database operation commands. next I will explain how phpmyadmin
1. download phpmyadmin from the Internet and decompress it to the accessible web directory (if it is a virtual space, decompress it and upload it to the web Directory through ftp ), of course, you can modify the name of the extracted file.
2. configure the config file
Open the config. default. php file under libraries, find the following items in sequence, and configure the items as instructed:
A. visit the website
$ Cfg ['pmaabsoluteuri '] = ''; enter the phpmyadmin access url here.
B. mysql host information
$ Cfg ['servers'] [$ I] ['host'] = 'localhost'; // MySQL hostname or IP address
Enter the IP address of the localhost or mysql server. if mysql and 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 3306 by default, leave it blank.
C. mysql User name and password
$ Cfg ['servers'] [$ I] ['user'] = 'root'; // MySQL user used by phpmyadmin to access the mysql user name
Fg ['servers'] [$ I] ['password'] = ''; // MySQL password (only needed corresponds to the password of the above mysql User name
D. authentication method
$ Cfg ['servers'] [$ I] ['auth _ type'] = 'cooker ';
There are four modes available here: cookie, http, HTTP, config
In config mode, you can directly access the phpmyadmin access url without entering the user name and password. it is insecure and is not recommended.
When this option is set to cookie, http, or HTTP, you need to verify the data username and password to log on to phpmyadmin. The details are as follows:
The PHP installation mode is Apache, and http and cookie can be used;
The PHP installation mode is CGI and cookie can be used.
E. set the phrase password (blowfish_secret)
$ Cfg ['blowfish _ secret'] = '';
If the authentication method is set to cookie, you need to set the phrase password and the setting password, which is determined by yourself, but cannot be left blank. Otherwise, an error will be prompted when you log on to phpmyadmin.
Okay, so far, you have successfully installed phpmyadmin. easy to use. log on to the console and try again.
Note:
This document describes the basic configuration of installing phpmyadmin. for details about the configuration parameters in the config. default. php file, refer to the next article.
