MySQL Management tools: Introduction to the use of phpMyAdmin

Mysql Preface:

The so-called phpmyadmin is simply a kind of MySQL management tool.
It can be directly from the web to manage MySQL, do not need to go to the system to perform.

Installation steps:

1. Access to Archives ftp://ohaha.ks.edu.tw/pub/source/php/phpMyAdmin_2.0.5.tar.gz
Or ftp://ohaha.ks.edu.tw/pub/source/php/c_phpMyAdmin_2.0.5.tar.gzThe only difference is that the latter do not need to do the Chinese optimization of the action.

2. We first use the former and then add Chinese to the optimization.

3. Unzip this file to the root directory of the Web server. That's where you put the pages.

ex:/usr/local/apache/htdocs/(Location of the Web page stored)
A. # MV Phpmyadmin_2.0.5.tar.gz/usr/local/apache/htdocs/moved to the root directory of the file
B. # tar ZXVF phpmyadmin_2.0.5.tar.gz decompression phpmyadmin_2.0.5.tar.gz
C. Path/usr/local/apache/htdocs/phpmyadmin
D. Modifying profiles
# VI CONFIG.INC.PHP3
Find the following section
$cfgServers [1][' host '] = ' localhost '; MySQL's hostname
$cfgServers [1][' port '] = '; MySQL's port blank indicates preset 3306
$cfgServers [1][' adv_auth '] = true; Whether to use advanced features
$cfgServers [1][' stduser '] = ' root '; The manager of MySQL
$cfgServers [1][' stdpass '] = ' 123456 '; MySQL Manager's password
Use root as manager, password 123456 You can use your favorite

4. Test

Open the browser, enter the http://URL/phpmyadmin/done ...

Chinese optimization

If the file you just used is c_phpmyadmin_2.0.5.tar.gz, then there is no Chinese problem. If you do what I'm doing, please get the Chinese best file (ftp://ohaha.ks.edu.tw/pub/source/php/chinese_ BIG5.INC.PHP3) put this file into the phpMyAdmin directory he will replace chinese_big5.inc.php3 this file if you don't think it's safe, you can start with the original Chinese_ Big5.inc.php3 renamed and then put the new file into
A. MV chinese_big5.inc.php3 chinese_big5.inc.php3.old//renamed Chinese_big5.inc.php3.old
B. MV chinese_big5.inc.php3/usr/local/apache/htdocs/phpmyadmin/

Small Tips

Notice what's wrong with it? If everyone does this then is not everyone's phpmyadmin position in the http://URL/phpmyadmin here? This situation can be changed. Just rename the Phpmyamin folder. If I want to change the name to PMA (one word for each, easy to remember)
A. Path:/usr/local/apache/htdocs/
B. # mv phpMyAdmin PMA

So others can not go to solve the position of the phpmyadmin ... You're the only one that's left.