MySQL administration tool: phpMyAdmin application introduction

PhpMyAdmin is a MySQL administration tool. It can directly govern MySQL from the web, and does not need to be executed on the system. Installation steps: 1. get Archive ftp://ohaha.ks.edu.tw/pub/source/php/phpMyAdmin_2.0.5.tar Preface:

PhpMyAdmin is a MySQL administration tool.
It can directly govern MySQL from the web, and does not need to be executed on the system.

Installation steps:

1. obtain the file 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 does not need to be optimized in Chinese.

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 to clarify the whitelist, that is, the location where the web page is stored.

Ex:/usr/local/apache/htdocs/(website storage status)
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 settings
# Vi config. inc. php3
Find the following section
$ Login servers [1] ['host'] = 'localhost'; // MySQL hostname
$ Export servers [1] ['port'] = ''; // Default port vacancy performance of MySQL 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
// Use root as the administrator and password as 123456. you can use your preferred password.

4. test

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

Chinese optimization

If the application file is c_phpmyadmin_2.0.5.tar.gz, there is no problem with the Chinese title. if you follow 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 feel insecure, you can first rename the original chinese_big5.inc.php3 file and then put the new file into 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

What's wrong with the above? If everyone does this, does phpMyAdmin play a role in http: // URL/phpMyAdmin? In this case, you can change the name of the phpMyAmin clip. If I want to change my name to pma (one word each for easy memory)
A. path:/usr/local/apache/htdocs/
B. # mv phpMyAdmin pma

In this way, the status of phpMyAdmin cannot be understood by others. you only need to know the status of phpMyAdmin...