Simply put, phpmyadmin is a mysql management tool. After installing the tool, you can directly manage mysql data through web form, without having to manage by executing system commands. It is very suitable for database administrators who are not familiar with database operation commands. Below, I will say how to install the tool: 1. First download phpmyadmin online, and then extract it to the web directory that can be accessed (if it is a virtual space, you can extract it and upload it to the web directory via ftp, etc.), of course you can Modify the name of the file after unzipping. 2. Configure the config file to open the config.default.php file under the libraries, and then find the following items, and then follow the instructions to configure: A. Access URL reference: $cfg['PmaAbsoluteUri'] = ''; Fill in the phpmyadmin access here URL B.mysql host information reference: $cfg['Servers'][$i]['host'] = 'localhost'; //MySQL hostname or IP address fill in the IP address of the localhost or mysql server, if mysql and If phpmyadmin is on the same server, press default localhost$cfg['Servers'][$i]['port'] = ''; //MySQL port - leave blank for default portmysql port. If it is default 3306, leave it blank. C.mysql username and password reference: $cfg['Servers'][$i]['user'] = 'root'; //MySQL user access phpmyadmin using mysql username fg['Servers'][$i ]['password'] = ''; //MySQL password (only needed corresponds to the above mysql username password D. Authentication method reference: $cfg['Servers'][$i]['auth_type'] = 'cookie' There are four modes to choose from, cookie, http, HTTP, configconfig way to enter phpmyadmin's access URL to enter directly, no need to input Name and password are not safe and are not recommended. When the item is set to cookie, http or HTTP, login phpmyadmin requires data username and password for verification, as follows: PHP installation mode is Apache, you can use http and cookie; PHP installation mode is CGI, you can use the cookieE. phrase password (blowfish_secret) setting reference: $cfg['blowfish_secret'] = ''; If the authentication method is set to cookie, you need to set the phrase password, put the setting password, by You decide, but you can't leave it blank, otherwise you will be prompted to log in when you log in to phpmyadmin. So far, you have successfully installed phpmyadmin, simply, log in and experience it. Description: This document only describes the basics of installing phpmyadmin. Configuration, detailed description of each configuration parameter in the config.default.php file. phpMyAdmin is a MySQL database management tool. After installing the tool, you can directly manage MySQL data through web form without executing system commands. Management, ideal for data that is not familiar with database manipulation commands Manager, the following detailed description of the tool mounting method. First, download 1, first go to the official site to download the phpMyAdmin installation package: http://www.phpmyadmin.net/(installation contains all-languages in various languages) 2, and then extract to the directory that the web can access, if it is a virtual space , can be extracted and uploaded to the web directory through the ftp tool, and you can modify the name of the file after decompression (you can customize the directory name). Second, configuration 3, open /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) for editing, follow the instructions Configuration can be. 4. Find $cfg['PmaAbsoluteUri']=‘'; //Change to the URL of the phpMyAdmin you will upload to the space: $cfg['PmaAbsoluteUri'] =‘http: //Website Name/phpmyadmin/' 5, find $ cfg ['Servers'] [$i] ['host'] = & lsquo; localhost '; //usually with the default, there are exceptions, you can not modify 6, find $ cfg ['Servers'] [$ i]['auth_type'] =‘config'; //Debug with config on your own machine; if you use cookies on the network space. There are four modes to choose from: cookie, http, HTTP, config1 The config mode is entered directly into the phpMyAdmin access URL. It is not safe to enter the username and password. It is not recommended. 2 Set the cookie, http, HTTP mode, login phpMyAdmin requires data username and password for verification. The details are as follows: PHP installation mode is Apache, you can use http and cookie; PHP installation mode is CGI, you can use cookies. 7. Find $cfg['Servers'][$i]['user'] = ‘root'; //MySQL username 8, find $cfg['Servers'][$i]['password'] = ''; //MySQL password (only needed to leave blank) 9, find $cfg['Servers'][$i]['only_db'] = ''; //You only have one data to set it up, set For your database name; if you want to set up the server, then it is recommended to leave 10, find $cfg['DefaultLang'] = ‘zh'; //Here is the language of choice, zh means 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. It is up to you to set the password. It can't be left blank. Otherwise, it will prompt when you log in to phpMyAdmin. error. 12, save after the settings, can now be uploaded to the network space, browse http://website domain name /phpmyadmin /test it. (Enter the database user name and password on it)
If you want to appear in the installation process: & ldquo; phpMyAdmin - Error lack mysqli extension. Please check the PHP configuration. ”Error. The solution is as follows: 1 Go to the \\libraries\\config.default.php file in the phpmyadmin folder and look for: $cfg['Servers'][$i]['extension']='mysql'; 2 If you find $cfg['Servers'][$i]['extension']='mysql'; this sentence, continue to find the following $cfg['Servers'][$i]['extension'] ='mysqli'; and remove its comment. 3 If you don't find $cfg['Servers'][$i]['extension']='mysql'; this sentence, put $cfg['Servers'][$i]['extension']='mysqli' ; statement, changed to $cfg['Servers'][$i]['extension']='mysql'; statement. (ie to ensure that the " mysql " value can take effect)