A concise installation tutorial for PHPMYADMIN is recommended
- 2020-03-31 20:30:36
- OfStack
1. Download phpmyadmin from the Internet, and then unzip it to the accessible web directory (if it is a virtual space, you can unzip it via FTP and upload it to the web directory). Of course, you can change the name of the file after unzip.
2. Configure the config file
Open the config.default.php file under libraries, find the following items in turn, and follow the instructions to configure:
A. visit the website
The $CFG [' PmaAbsoluteUri] = ' '; Fill in the phpmyadmin access url here
B.mysql host information
The $CFG [' the Servers'] [$I] [' host '] = 'localhost' // MySQL hostname or IP address
Fill in the IP address of the server where localhost or mysql resides. If mysql and phpmyadmin are on the same server, press default localhost
The $CFG [' the Servers'] [$I] [' port '] = ' '; // MySQL port-leave blank for default port
The mysql port, if the default is 3306, is left blank
C.sql user name and password
The $CFG [' the Servers'] [$I] [' user '] = 'root'; // MySQL user accesses the MySQL user name used by phpmyadmin
Fg [' the Servers'] [$I] [' password '] = ' '; // MySQL password (only needed for the above MySQL username
D. methods of authentication
$CFG [' the Servers'] [$I] [' the auth_type] = 'cookies';
There are four modes to choose from: cookie, HTTP, HTTP, config
Config mode is entered phpmyadmin access url can be directly entered, without the need to enter the user name and password, is not safe, is not recommended to use.
When this item is set as cookie, HTTP or HTTP, the login phpmyadmin requires the data user name and password to verify, and the details are as follows:
PHP installation mode is Apache, you can use HTTP and cookies;
PHP installation mode is CGI, you can use cookies
E. Setting of phrase password (blowfish_secret)
The $CFG [' blowfish_secret] = ' ';
If the authentication method is set to cookie, you need to set the phrase password, which is placed in the setting of the password, at your own discretion , but it cannot be left blank, or you will get an error when you log in to phpmyadmin
Ok, so far, you have successfully installed phpmyadmin, simple, just log in and experience it
Description:
This document describes only the basic configuration for installing phpmyadmin, and you can refer to the next article on this site for detailed instructions on the various configuration parameters in the config.default.php file.
2. Configure the config file
Open the config.default.php file under libraries, find the following items in turn, and follow the instructions to configure:
A. visit the website
The $CFG [' PmaAbsoluteUri] = ' '; Fill in the phpmyadmin access url here
B.mysql host information
The $CFG [' the Servers'] [$I] [' host '] = 'localhost' // MySQL hostname or IP address
Fill in the IP address of the server where localhost or mysql resides. If mysql and phpmyadmin are on the same server, press default localhost
The $CFG [' the Servers'] [$I] [' port '] = ' '; // MySQL port-leave blank for default port
The mysql port, if the default is 3306, is left blank
C.sql user name and password
The $CFG [' the Servers'] [$I] [' user '] = 'root'; // MySQL user accesses the MySQL user name used by phpmyadmin
Fg [' the Servers'] [$I] [' password '] = ' '; // MySQL password (only needed for the above MySQL username
D. methods of authentication
$CFG [' the Servers'] [$I] [' the auth_type] = 'cookies';
There are four modes to choose from: cookie, HTTP, HTTP, config
Config mode is entered phpmyadmin access url can be directly entered, without the need to enter the user name and password, is not safe, is not recommended to use.
When this item is set as cookie, HTTP or HTTP, the login phpmyadmin requires the data user name and password to verify, and the details are as follows:
PHP installation mode is Apache, you can use HTTP and cookies;
PHP installation mode is CGI, you can use cookies
E. Setting of phrase password (blowfish_secret)
The $CFG [' blowfish_secret] = ' ';
If the authentication method is set to cookie, you need to set the phrase password, which is placed in the setting of the password, at your own discretion , but it cannot be left blank, or you will get an error when you log in to phpmyadmin
Ok, so far, you have successfully installed phpmyadmin, simple, just log in and experience it
Description:
This document describes only the basic configuration for installing phpmyadmin, and you can refer to the next article on this site for detailed instructions on the various configuration parameters in the config.default.php file.