MySQL Management tools: phpMyAdmin

Source: Internet
Author: User
Tags phpmyadmin
This article comes from: Ohaha's learning experience [ohaha.ks.edu.tw] Author: Blue Bubble (panda@ks.edu.tw)
Objective:
The so-called phpmyadmin is simply a kind of MySQL management tool.
 
Through this program, you can directly from the web to manage MySQL, do not need to go to the system to perform.
 
Installation steps:
1. Obtain 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.gz
The only difference is that the latter do not need to do the Chinese optimization of the action.
 
The so-called Chinese optimization is because the translator of this program may be the mainland. So poor translation
If you think it's not relevant, you can ignore it.
 
2. We first use the former and then add Chinese to the optimization.
 
3. Unzip this file to the Web server's root directory
You know, that's where you put the pages.
Ex:/usr/local/apache/htdocs/(This is the location of my web site)
A. # MV Phpmyadmin_2.0.5.tar.gz/usr/local/apache/htdocs/moved to the root directory of the file
B. # tar ZXVF phpmyadmin_2.0.5.tar.gz decompression phpmyadmin_2.0.5.tar.gz
C. Path/usr/local/apache/htdocs/phpmyadmin
D. Modifying profiles
# VI CONFIG.INC.PHP3
Find the following section
$cfgServers [1][' host '] = ' localhost '; MySQL's hostname
$cfgServers [1][' port '] = '; MySQL's port blank indicates preset 3306
$cfgServers [1][' adv_auth '] = true; Whether to use advanced features
$cfgServers [1][' stduser '] = ' root '; The manager of MySQL
$cfgServers [1][' stdpass '] = ' 123456 '; MySQL Manager's password
I use root as the manager, the password is 123456 you can use your favorite
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 Chinese problem.
If you do it my way, please get the Chinese best file (ftp://ohaha.ks.edu.tw/pub/source/php/chinese_big5.inc.php3)
Put this file in the phpMyAdmin directory he'll replace chinese_big5.inc.php3 this file
If you don't think it's safe, you can rename the original chinese_big5.inc.php3 and put the new file in
A. MV Chinese_big5.inc.php3 Chinese_big5.inc.php3.old
renamed to Chinese_big5.inc.php3.old
B. MV chinese_big5.inc.php3/usr/local/apache/htdocs/phpmyadmin/

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.