MySQL management tool: phpMyAdmin Introduction

Preface

PhpMyAdmin is a MySQL management tool. It can manage MySQL directly from the web without going to the system for execution.
Installation Steps

1. The only difference between obtaining an archive token is that the latter does not need to be optimized in Chinese.

The so-called Chinese optimization is because the translator of this program may be from the Chinese mainland, so poor translation can be ignored if you think there is nothing to do with it.

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

3. decompress the file to the root directory of the web server, which indicates the location where you placed the web page.

Ex:/usr/local/apache/htdocs/(this is where my webpage is stored)
A. # mv phpMyAdmin_2.0.5.tar.gz/usr/local/apache/htdocs/move to the root directory of the file // from www.w3sky.com
B. # tar zxvf phpMyAdmin_2.0.5.tar.gz decompress phpMyAdmin_2.0.5.tar.gz
C. Path/usr/local/apache/htdocs/phpMyAdmin
D. modify the configuration file.
# Vi config. inc. php3
Find the following section
$ Login servers [1] ['host'] = 'localhost'; // MySQL hostname
$ Define servers [1] ['Port'] = ''; // MySQL port blank indicates default 3306
$ Incluservers [1] ['adv _ auth'] = true; // whether advanced functions are used
$ Login servers [1] ['stduser'] = 'root'; // MySQL Administrator
$ Login servers [1] ['stdpass'] = '000000'; // password of the MySQL Administrator
// I use root as the Administrator, and the password is 123456. You can use your favorite password.

4. Test

Open the browser and enter the http: // URL/phpMyAdmin/done...
Chinese Optimization

If you just use the file is c_phpmyadmin_2.0.5.tar.gz no problem in Chinese, if you do according to my steps, please get the Chinese optimization file (ftp://ohaha.ks.edu.tw/pub/source/php/chinese_big5.inc.php3) put this file in the phpMyAdmin directory. It will replace chinese_big5.inc.php3. If you think it is not safe, you can change the name of the original chinese_big5.inc.php3 file first and then add the new file to it.
A. mv chinese_big5.inc.php3 chinese_big5.inc.php3.old // rename it 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 this as I do, is it true that the phpMyAdmin location of each person is in http: // URL/phpMyAdmin? In this case, you can change the name of the phpMyAmin folder. If I want to change the name to pma (one word for each word to facilitate memory)
A. Path:/usr/local/apache/htdocs/
B. # mv phpMyAdmin pma
In this way, the location of phpMyAdmin cannot be solved by others. You only need to know it...