PHPMYADMIN installation tutorial

PHPMYADMIN installation tutorial
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 to install the tool:

1. First download phpmyadmin from the InternetAnd decompress it to the accessible web directory (if it is a virtual space, you can decompress it and upload it to the web directory through ftp). Of course, you can modify the name of the file after decompression.

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
Reference:
$ Cfg ['pmaabsoluteuri '] = ''; enter the phpmyadmin access URL here.

B. mysql host information
Reference:
$ 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
Reference:
$ 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
Reference:
$ 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)
Reference:
$ 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 only describes the basic configuration of installing phpmyadmin. For details about the configuration parameters in the config. default. php file, you can

PhpMyAdmin is a MySQL database management tool. After the tool is installed, you can directly manage MySQL Data in the form of web, instead of executing system commands, it is very suitable for database managers who are unfamiliar with database operation commands. The following describes the installation method of this tool in detail.
1. Download
1. Download phpMyAdmin installation package from official site: http://www.phpmyadmin.net/(install all-programming ages in various languages)
2. decompress the package to a web-accessible directory. If it is a virtual space, decompress the package and upload it to the web directory through ftp, you can also modify the name of the extracted file (you can customize the directory name ).

Ii. Configuration
3. Open/libraries/config. default. PHP file (the old version is config in the root directory. inc. PHP file), use a WordPad (do not use Notepad, this is UTF8 encoding) for editing, follow the instructions to configure.
4. Find $ cfg ['pmaabsoluteuri '] = ''; // modify the phpMyAdmin URL of the space to be uploaded.
For example, $ cfg ['pmaabsoluteuri '] = 'HTTP: // website domain name/phpmyadmin /';
5. Search for $ cfg ['servers'] [$ I] ['host'] = 'localhost'; // The default value is usually used, and there are exceptions. You do not need to modify the value.
6. find $ cfg ['servers'] [$ I] ['auth _ type'] = 'config'; // debug config in your own machine; if a cookie is used for the space on the network.
There are four modes available: cookie, http, HTTP, config
① You can directly enter the phpMyAdmin access URL in config mode without entering the user name and password. It is insecure and is not recommended.
② Set the cookie, http, and HTTP methods. to log on to phpMyAdmin, you need the data username and password for verification.
Specifically, the PHP installation mode is Apache, and http and cookie can be used. The PHP installation mode is CGI and cookie can be used.
7. Search for $ cfg ['servers'] [$ I] ['user'] = 'root'; // MySQL Username
8. find $ cfg ['servers'] [$ I] ['Password'] = ''; // MySQL password (only leave the needed blank)
9. find $ cfg ['servers'] [$ I] ['only _ db'] = ''; // you can set only one data, set your database name. If you want to set up a server, leave it blank.
10. find $ cfg ['defaultlang '] = 'zh'; // select a language. zh indicates the meaning of Simplified Chinese.
11. find $ cfg ['blowfish _ secret'] = ''; // If the authentication method is set to cookie, you need to set the phrase password and the reason for setting the password, you cannot leave this field empty. Otherwise, an error as shown in is prompted when you log on to phpMyAdmin.

12. Save the settings. Now you can upload the file to the network space. View http: // website domain name/phpmyadmin/and test it. (Enter the database user name and password)

If the following error occurs during installation: "phpMyAdmin-error: mysqli extension is missing. Check the PHP configuration ." Error.
The solution is as follows:
① Find the $ cfg ['servers'] [$ I] ['extension'] = 'mysql'; statement in the \ libraries \ config. default. php file in the phpmyadmin folder.
② If $ cfg ['servers'] [$ I] ['extension'] = 'mysql'; is found, continue to find the following $ cfg ['servers'] [$ I] ['extension'] = 'mysqli'; and remove the comment.
③ If $ cfg ['servers'] [$ I] ['extension'] = 'mysql'; is not found, put the $ cfg ['servers'] [$ I] ['extension'] = 'mysqli'; statement, change to $ cfg ['servers'] [$ I] ['extension'] = 'mysql'; statement. (That is, make sure that the "mysql" value takes effect)