phpmyadmin phpMyAdmin installation tutorial guide

The best tool for managing MYSQL databases is PHPmyAdmin. The latest version is phpMyAdmin 2.9.0.2. This is an international open source software that is constantly being updated. You can download it from the official website at http://www.phpmyadmin.net , the database can be updated remotely after installation (actually installed on the server).
Please refer to the installation method:
phpMyAdmin Installation Guide
1. First download the phpMyAdmin installation package, http://www.phpmyadmin.net
2. Unzip it in a separate directory (you can customize the directory name)
3. Find / libraries/config.default.php file (the old version is the config.inc.php file in the root directory), edit it with WordPad (do not use Notepad, this is UTF8 encoding).
4. Find $cfg['PmaAbsoluteUri']
Change to the URL of phpMyAdmin that you will upload to the space
For example: $cfg['PmaAbsoluteUri'] = 'http://www.phpfans.net/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 in the network space, since we have added the URL before, we will change it to cookies. It is recommended to use cookies here.
7. Search $cfg['Servers'][$i]['user'] = 'root'; // MySQL user (user name, use root on your machine; on the Internet, it is usually your ftp user name, virtual The hosting provider will tell you; generally do not modify it)
8. Search $cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed
No need to set it in your own machine, leave it in Just leave it empty
9. Search $cfg['Servers'][$i]['only_db'] = ''; // If set to a db-name, only (if you only have one data, set it; if you If you are on this machine or want to set up a server, it is recommended to leave it blank)
10. Search $cfg['DefaultLang'] = 'zh'; (Here is the language selection, zh means Simplified Chinese)
11. Save after setting. Now you can upload it to the network space. Browse http://www.phpfans.net/phpmyadmin/ to test it.
Of course, use that URL if your settings are different.
12. Additional explanation:
In fact, if you have different settings. If you purchased a virtual host, you don’t need to do any of this work at all. The reason why you need to set up phpmyadmin is that everyone needs to set up a server. If "the configuration file now requires a top-secret phrase password (blowfish_secret)" appears, please set it in $cfg[ 'blowfish_secret'] = ' '; Set the cookie of your website in the equal sign, for example: $cfg['blowfish_secret'] = 'www.phpfans.net'; This is because your "$cfg['Servers'][ The reason why $i]['auth_type'] = 'cookie'.​

The above introduces the complete guide to the phpmyadmin phpMyAdmin installation tutorial, including the content of phpmyadmin. I hope it will be helpful to friends who are interested in PHP tutorials.