Introduction to MySQL management tools: 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). # 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. in php3, locate the following section $ pipeline servers [1] ['host'] = 'localhost'; // MySQL hostname $ pipeline servers [1] ['Port'] = ''; // MySQL port blank indicates the default value of 3306 $ login servers [1] ['adv _ auth '] = true; // whether advanced functions are used $ schemservers [1] ['stduser'] = 'root '; // MySQL administrator $ login servers [1] ['stdpass'] = '000000'; // MySQL administrator password // I use root as the administrator, the password is 123456. You can use your favorite password. open the browser and enter the http: // URL/phpMyAdmin/done...Chinese OptimizationIf 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 put the new file into. 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/TipsSmart 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, it is easy to remember). path:/usr/local/apache/htdocs/B. # mv phpMyAdmin pma so that others cannot solve the phpMyAdmin location... only you know it...