phpMyAdmin installation tutorial guide_PHP tutorial

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 has been updated. You can download it from the official website 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 Directory name)
3. Find the /libraries/config.default.php file (the old version is the config.inc.php file in the root directory) and edit it with WordPad (do not use Notepad, this is UTF8 encoding) .
4. Find $cfg['PmaAbsoluteUri']
Change it 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, no need to modify it)
6. Search $cfg['Servers'][$i]['auth_type'] = 'config';
Use config for debugging in your own machine; if you use cookies in the network space, since we have added them before URL, change it to cookie. It is recommended to use cookies here.
7. Find $cfg['Servers'][$i]['user'] = 'root'; // MySQL user (user name, in your own machine) Use root; it is usually your ftp username on the Internet. The virtual host provider will tell you; generally do not modify it)
8. Search $cfg['Servers'][$i]['password'] = '' ; // MySQL password (only needed
You don’t need to set it in your machine, just leave it blank
9. Search $cfg['Servers'][$i]['only_db'] = ''; // If set to a db-name, only (if you only have one data, set it; 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. After the settings are completed, save it. Now it can be uploaded to the network space. Browse http://www.phpfans.net/phpmyadmin/ to test it.
Of course, you can use that URL if you set it up differently. Here are some examples.
12. Additional explanation:
In fact, if you purchase a virtual host, you don’t need to do any of this work at all. phpmyadmin estimates that everyone needs to set up a server. If "the configuration file now requires a top-secret phrase password (blowfish_secret)" appears, then please set the cookie of your website in the equal sign of $cfg['blowfish_secret'] = ' ';, for example: $cfg['blowfish_secret'] = 'www.phpfans.net'; This is because your "$cfg['Servers'][$i]['auth_type'] = 'cookie'.​

http://www.bkjia.com/PHPjc/318101.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/318101.htmlTechArticleThe best tool for managing MYSQL database is PHPmyAdmin. The latest version is phpMyAdmin2.9.0.2, which is an international Open source software is always being updated. You can download it from http://www.php...