PhpMyAdmin is a MySQL management tool. It can manage MySQL directly from the web without going to the system for execution. Installation steps: 1. obtain the file ftp: ohaha.ks.edu.twpubsourcephpmyadmin_2.0.5.tar.gz or ftp: ohaha.ks.edu. twpubsourcephpc_phpMyAdmin_2 phpmyadminmysql management tool
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. 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, which indicates the location where the web page is stored.
Ex:/usr/local/apache/htdocs/(website storage location)
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
// Use the root account as the administrator and the password as 123456. you can use your favorite password.
4. test
Open the browser and enter the http: // URL/phpMyAdmin/done...
Chinese optimization
If the file you just used is c_phpmyadmin_2.0.5.tar.gz, there is no problem with the Chinese language. if you do it 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
What's wrong with the above? If everyone does this, is the position of phpMyAdmin in http: // URL/phpMyAdmin? In this case, you can change the name of the phpMyAmin folder. 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 location of phpMyAdmin cannot be solved by others. you only need to know it...
