For the gradual popularity of PHP, we can be seen: whether it is in the blog program WordPress, or CMS program in the DEDECMS, or BBS program in the discuz!, are classic.
With the choice of programming language, the database used by the Web application has changed, and is learning from the MySQL camp instead. The study of phpMyAdmin is essential.
PhpMyAdmin (PMA) is a PHP program that can control and operate MySQL online via the internet. He is the preferred Database maintenance tool for many MySQL administrators and webmasters, and the MySQL database can be fully manipulated by phpMyAdmin.
One, phpMyAdmin's download
Open the official site of phpMyAdmin: http://www.phpmyadmin.net/, select "Download" on the page, currently the latest version is phpMyAdmin 2.10.1, select "All-languages.zip" File download
Download the zip file to unzip the local disk by extracting the software. If you have MySQL locally, you can test it locally, or upload it to a MySQL-enabled Web server, such as uploading all the extracted files to the leosn.com phpMyAdmin folder, via "Http://leosn.com/phpmyadmin" For access.
Second, the installation of phpMyAdmin
Of course, whether you are testing locally or on a remote server, you need to configure the following files to use phpMyAdmin properly.
First, in the download of the extracted files there is a file "config.sample.inc.php", which is a sample file of the phpMyAdmin configuration file, we need to copy all the code in the file, create a new file "
config.inc.php", and paste the code. The file config.inc.php is a phpmyadmin configuration file that must be uploaded when the server is uploaded.
For config.inc.php files, the most important thing is to modify the username and password to join the phpMyAdmin connection to MySQL. Find the line of code:
$cfg [' Servers '] [$i] [' controluser '] = ' PMA ';
$cfg [' Servers '] [$i] [' controlpass '] = ' pmapass ';
|
Delete the "//" comment number and enter the username and password configured in MySQL (please contact your space service provider for the remote server), for example:
$cfg [' Servers '] [$i] [' controluser '] = ' leosn_com ';
$cfg [' Servers '] [$i] [' controlpass '] = ' ********* ';
|
Note:If you need to use phpMyAdmin with remote server debugging, you need to add the Blowfish_secret content definition cookie to find the line of code:
$cfg [' blowfish_secret '] = ';
|
Set content to Cookie
$cfg [' blowfish_secret '] = ' leosn ';
|
Third, the use of phpMyAdmin
Open phpMyAdmin Server directory, such as http://www.leosn.com/phpmyadmin/, continue to enter the user name and password of the MySQL user, enter.
Select the relevant database to see the tables in the database, you can change tables, fields and additions, you can import and export database information. In short, choose the Chinese language phpmyadmin, you can quickly get started.
http://www.bkjia.com/PHPjc/318302.html www.bkjia.com true http://www.bkjia.com/PHPjc/318302.html techarticle for the gradual popularity of PHP, we can be seen: whether it is in the blog program WordPress, or CMS program in the DEDECMS, or BBS program in the discuz!, are classic. With program language ...
