MySQL Management tools: phpMyAdmin

Preface:


the so-called phpmyadmin is simply a MySQL management tool.


through this program, you can directly from the web to manage MySQL, do not need to go to the system to perform.


Installation steps:


1. Obtain 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.gz





The only difference is that the latter do not need to do the Chinese optimization of the action.


's so-called Chinese optimization is because the translator of this program may be mainland. So poor translation


If you think it's not relevant, you can ignore it.


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


3. Extract this file to the root directory of the Web server


The white is where you put the Web page


ex:/usr/local/apache/htdocs/(This is where my web site resides)


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. Modify Profile


# VI Config.inc.php3


Find the following section


$cfgServers [1][' host '] = ' localhost '; MySQL's hostname


$cfgServers [1][' port '] = '; MySQL's port blank indicates a preset 3306


$cfgServers [1][' adv_auth '] = true; Whether to adopt advanced function


$cfgServers [1][' stduser '] = ' root '; MySQL's manager


$cfgServers [1][' stdpass '] = ' 123456 '; MySQL Manager's password


I use root as the manager, the password is 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 it my way, please get the Chinese best file ( ftp://ohaha.ks.edu.tw/pub/source/php/chinese_big5.inc.php3 )


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 rename the original chinese_big5.inc.php3 and put the new file in
.

A. MV chinese_big5.inc.php3 Chinese_big5.inc.php3.old


//renamed to Chinese_big5.inc.php3.old


B. MV chinese_big5.inc.php3/usr/local/apache/htdocs/phpmyadmin/


Tips


Smart Do you find anything wrong with it? If everyone does what I do


So what? is not everyone's phpmyadmin location 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 that others can not be able to solve the position of phpmyadmin ... You're the only one that's left.