MySQL management tool: phpMyAdmin

PhpMyAdmin is a MySQL management tool. Through this program, you can directly manage MySQL from the web without running it on the system.

Installation steps:

1. The only difference between obtaining the archive samples // ohaha.ks.edu.tw/pub/source/php/c_phpMyAdmin_2.0.5.tar.gz is that the latter does not need to perform the Chinese optimization. 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 this 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 the location 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

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. 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)

Place this file in the phpMyAdmin Directory, which replaces chinese_big5.inc.php3.

If you think it is not safe, you can change the name of the original chinese_big5.inc.php3 and then put the new file

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, is the phpMyAdmin location of each person at 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, you can only know the location of phpMyAdmin that others cannot solve.