The best tool for managing MySQL database is phpMyAdmin, now the latest version is phpMyAdmin 2.9.0.2, an international open source software that has been updated and you can download it from the Http://www.phpmyadmin.net official website , the database can be updated remotely after installation (it is actually installed on the server).
Installation method please refer to:
PhpMyAdmin Installation Guide
1, first download PhpMyAdmin installation package, http://www.phpmyadmin.net
2, unzip a separate directory (you can customize the directory name)
3. Locate the/libraries/config.default.php file (the old version is the config.inc.php file under the root directory), and use WordPad (do not use Notepad, which is UTF8 encoding) for editing.
4. Find $cfg [' Pmaabsoluteuri ']
Modify the URL of the phpmyadmin that you will upload to the space
such as: $cfg [' pmaabsoluteuri '] = ' http://www.phpfans.net/phpmyadmin/';
5. Find $cfg [' Servers '] [$i] [' host '] = ' localhost '; (usually with default, with exception, without modification)
6, find $cfg [' Servers '] [$i] [' auth_type '] = ' config ';
Debug in your own machine with config; if the space on the network with a cookie, here we have already added the URL in the previous, the change to a cookie, here is recommended to use cookies.
7. Find $cfg [' Servers '] [$i] [' user '] = ' root '; MySQL User (username, your own machine with root; in the Internet generally for your FTP user name, virtual host provider to tell you; do not modify)
8. Find $cfg [' Servers '] [$i] [' password '] = '; MySQL Password (only needed
You don't have to set it up in your own machine.
9. Find $cfg [' Servers '] [$i] [' only_db '] = '; If set to a db-name, only (you have only one data set up; If you're on this computer or want to build a server, leave the suggestion blank)
10, find $cfg [' defaultlang '] = ' zh '; (This is the language of choice, zh means Simplified Chinese)
11, set up after the save, can now be uploaded to the network space, browse http://www.phpfans.net/phpmyadmin/test a bit.
Of course you set the different to use that URL, here the knowledge examples illustrate.
12. Supplementary explanation:
In fact, if you are buying a virtual host, then these jobs do not need you to do. The reason to set phpMyAdmin estimate everyone is to build a server if the "configuration file now requires top secret phrase password (blowfish_secret)" then please in $cfg[' blowfish_secret '] = "; The equal sign inside the cookie that sets your website, for example: $cfg [' blowfish_secret '] = ' www.phpfans.net ', this is because your "$cfg [' Servers '] [$i] [' auth_type '] = ' The reason for the cookie '.
The above describes the PhpMyAdmin phpMyAdmin installation tutorials, including the phpMyAdmin aspects of the content, I hope that the PHP tutorial interested in a friend helpful.
