This article from: OHaHa learning experience [ohaha.ks.edu.tw] Author: blue bubble (panda@ks.edu.tw) Preface: The so-called phpMyAdmin is simply a MySQL management tool. Through this program, you can directly manage MySQL from the web without running it on the system. Installation steps: 1. obtain the file ftp: ohaha.ks.edu. twpubsource phpmyadminmysql management tool
From: OHaHa learning experience [ohaha.ks.edu.tw] by: blue bubble (panda@ks.edu.tw)
Preface:
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. obtain the archive token
The only difference 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.
You can ignore it if you think it is okay.
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.
It means that the place where you place 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
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 the file you just used is c_phpmyadmin_2.0.5.tar.gz, there is no problem with Chinese characters.
If you do what I do, 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 what I do
So... is it because everyone's phpMyAdmin location is 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, the location of phpMyAdmin cannot be solved by others. you only need to know it...
