Home > Backend Development > PHP Tutorial > MySQL management tool: phpMyAdmin_PHP tutorial

MySQL management tool: phpMyAdmin_PHP tutorial

WBOY
Release: 2016-07-13 17:01:49
Original
968 people have browsed it

This article comes from: OHaHa’s learning experience [ohaha.ks.edu.tw] Author: Blue Bubble (panda@ks.edu.tw)
Foreword:
The so-called phpMyAdmin is simply a MySQL management tools.

Through this program, you can manage MySQL directly from the web without having to go to the system to execute it.

Installation steps:
1. Get 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.gz
The only difference is that the latter does not require Chinese optimization.

The so-called Chinese optimization is because the translator of this program may be from Mainland China...so the translation is not good
If you think it is not relevant, you can ignore it.

2. We first adopt the former and then add Chinese optimization.

3. Extract this file to the file root directory of the web server
To be clear, this is where you place the web page
ex:/usr/local/apache/htdocs/ ( This is the location 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 Unzip phpMyAdmin_2.0.5.tar.gz
c. Path/usr/local/apache/htdocs/phpMyAdmin
d. Modify configuration file
# vi config.inc.php3
Found The following part
$cfgServers[1]['host'] = 'localhost'; // MySQL's hostname
$cfgServers[1]['port'] = ''; // MySQL's port is blank. Default 3306
$cfgServers[1]['adv_auth'] = true; // Whether to use advanced features
$cfgServers[1]['stduser'] = 'root'; // MySQL manager
$cfgServers[1]['stdpass'] = '123456'; // MySQL manager's password
// I use root as the manager, and the password is 123456. You can use your favorite
4 .Test
Open the browser and enter the URL of http:///phpMyAdmin/
done...
Chinese Optimization
If the file you just used is c_phpMyAdmin_2.0.5.tar. gz does not have the problem of Chinese language
If you follow my steps, please obtain the Chinese optimized file (ftp://ohaha.ks.edu.tw/pub/source/php/chinese_big5.inc. php3)
Put this file into the directory of phpMyAdmin and it will replace the file chinese_big5.inc.php3
If you feel it is not safe, you can rename the original chinese_big5.inc.php3 first and then Place the new file into
a. mv chinese_big5.inc.php3 chinese_big5.inc.php3.old
// Rename to chinese_big5.inc.php3.old
b. mv chinese_big5.inc.php3 /usr /local/apache/htdocs/phpMyAdmin/

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/631111.htmlTechArticleThis article comes from: OHaHa’s 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...
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template