For the gradual popularity of PHP, we can see: whether the blog program in the WordPress, or CMS program in the DEDECMS, or BBS program in the discuz!, are described as classic.
With different programming language choices, the database used by Web applications has changed and is learning from the MySQL camp instead. The study of phpMyAdmin is essential.
phpMyAdmin (PMA) is a PHP-written, can be online control and operation of MySQL via the internet. He is the MySQL administrator and webmaster's preferred database maintenance tool, through phpMyAdmin can be completely to the MySQL database operation.
One, phpMyAdmin download
Open phpMyAdmin's official site:
http://www.phpmyadmin.net/, select "Download" in the page, the latest version is phpMyAdmin 2.10.1, select "all-languages.zip" File download
The downloaded zip file extracts the local disk by decompressing the software. If you have MySQL locally, you can test it locally, or upload it to a Web server that supports MySQL, such as uploading all the uncompressed files to Leosn.com's phpMyAdmin folder.
Http://leosn.com/phpmyadmin"For access.
Second, the installation of phpMyAdmin
Of course, whether you are testing locally or on a remote server, you will need to do the following file configuration to work with phpMyAdmin.
First of all, in the download unzipped file has a file "config.sample.inc.php", this is the phpMyAdmin configuration file sample file, we need to copy all the code in the file, create a new file.
config.inc.php, and paste the code. File config.inc.php is a phpmyadmin configuration file that must be uploaded when uploading the server.
For config.inc.php files, the most important thing is to modify the username and password to join the phpMyAdmin connection MySQL. Find the line of code:
$cfg [' Servers '] [$i] [' controluser '] = ' PMA ';
$cfg [' Servers '] [$i] [' controlpass '] = ' pmapass ';
|
Delete the "//" annotation number and enter the username and password configured in MySQL (please contact your space service provider for the remote server), such as:
$cfg [' Servers '] [$i] [' controluser '] = ' leosn_com ';
$cfg [' Servers '] [$i] [' controlpass '] = ' ********* ';
|
Note:If you need to use phpMyAdmin through remote server debugging, you need to add a Blowfish_secret content definition cookie to find the line of code:
$cfg [' blowfish_secret '] = ';
|
Set content to Cookies
$cfg [' blowfish_secret '] = ' leosn ';
|
Third, the use of phpMyAdmin
Open the server directory where phpMyAdmin is located, such as
http://www.leosn.com/phpmyadmin/, continue to enter the user name and password of the MySQL user.
Select the relevant database can be seen in the database tables, can be table, field additions and deletions, you can import, export database information. In short, choose the Chinese language family of phpMyAdmin, you can quickly get started.
