Special detailed PHPMYADMIN concise installation tutorial_PHP tutorial

It is very suitable for database managers who are not familiar with database operation commands. Let me tell you how to install this tool:

1. First download phpmyadmin online, and then unzip it to an accessible web page 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 website
Quote:
$cfg['PmaAbsoluteUri'] = ''; Fill in the access URL of phpmyadmin here

B.mysql host information
Quote:
$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, Then press the default localhost
$cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port
mysql port, if it is the default 3306, keep it as Just leave it empty

C.mysql username and password
Quote:
$cfg['Servers'][$i]['user'] = 'root'; // The mysql user name 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
Quote:
$cfg['Servers'][$i]['auth_type'] = 'cookie';
There are four modes available here Select, 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 not recommended.
When this item is set to cookie, When http or HTTP is used, 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 use cookies

E. Phrase password (blowfish_secret) setting
Quote:
$cfg['blowfish_secret'] = '';
If the authentication method is set to cookie, you need to set the phrase Password, it is up to you to decide what password to set, but it cannot be left blank, otherwise an error will be prompted when logging in to phpmyadmin
Okay, so far, you have successfully installed phpmyadmin, it’s easy, log in to experience it

Note:
This document only describes the basic configuration of installing phpmyadmin. Detailed descriptions of each configuration parameter in the config.default.php file can be found

phpMyAdmin is a MySQL database Management tool. After installing this tool, you can directly manage MySQL data through the web form without the need to execute system commands. It is very suitable for database managers who are not familiar with database operation commands. The installation method of this tool is explained in detail below. .
1. Download
1. First go to the official website to download the phpMyAdmin installation package: http://www.phpmyadmin.net/ (the installation includes all-languages)
2 , and then decompress it to a directory that can be accessed by the web. If it is a virtual space, you can decompress it and upload it to the web directory through the ftp tool. At the same time, you can modify the name of the decompressed file (you can customize the directory name).

2. Configuration
3. Open the /libraries/config.default.php file (the old version is the config.inc.php file in the root directory), use WordPad ( Do not use Notepad (this is UTF8 encoding) to edit, just follow the instructions to configure it.
4. Find $cfg['PmaAbsoluteUri']=''; // Change it to the URL of phpMyAdmin that you will upload to the space
For example: $cfg['PmaAbsoluteUri'] ='http: // Website domain name /phpmyadmin/';
5. Search $cfg['Servers'][$i]['host'] ='localhost'; // Usually use the default, there are exceptions, you don’t need to modify it
6. Search $cfg['Servers'][$i]['auth_type'] ='config'; // Use config for debugging on your own machine; if you use cookies on the network, there are four modes here.
Available options: 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 not recommended.
② Set cookie, http, HTTP method, log in to phpMyAdmin and need data user name and password for verification.
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.
7. Search for $cfg['Servers'][$i]['user'] = 'root'; // MySQL user name
8. Search for $cfg['Servers'][$i][ 'password'] = ''; // MySQL password (only needed, just leave it blank)
9. Find $cfg['Servers'][$i]['only_db'] = ''; // You If there is only one data, set it to your database name; if you want to set up a server, it is recommended to leave it blank
10. Find $cfg['DefaultLang'] = 'zh'; // Here is the language selection, zh Represents the meaning of Simplified Chinese
11. Search $cfg['blowfish_secret'] =''; // If the authentication method is set to cookie, you need to set a phrase password. It is up to you to decide what password to set. You cannot leave it blank here. , otherwise the error shown in the figure below will be prompted when logging in to phpMyAdmin.

12. Save after setting up. Now you can upload it to the network space. Browse http://website domain name/phpmyadmin/ to test it. (Just enter the username and password of the database)

If an error occurs during the installation process: "phpMyAdmin - Error The mysqli extension is missing. Please check the PHP configuration." error.
The solution is as follows:
①Go to the librariesconfig.default.php file in the phpmyadmin folder and find: $cfg['Servers'][$i]['extension']='mysql '; statement.
②If you find the sentence $cfg['Servers'][$i]['extension']='mysql';, continue to search for the following sentence $cfg['Servers'][$i][' extension']='mysqli'; and remove its comments.
③If the sentence $cfg['Servers'][$i]['extension']='mysql'; is not found, just put $cfg['Servers'][$i]['extension']= 'mysqli'; statement, changed to $cfg['Servers'][$i]['extension']='mysql'; statement. (That is, make sure the " mysql " value is valid)

http://www.bkjia.com/PHPjc/319331.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/319331.htmlTechArticleIt is very suitable for database managers who are not familiar with database operation commands. Let me tell you how to install this tool: 1 .First download phpmyadmin from the Internet, and then unzip it to an accessible web directory...