The popularity of PHP is obvious to all: WordPress in the BLOG program, DEDECMS in the CMS program, and Discuz In the BBS program !, Both are classic.
With different programming languages, the databases used by WEB applications have also changed, and they have switched to the MySQL camp. PhpMyAdmin learning is essential.
PhpMyAdmin (PMA for short) is written in PHP and can be used to control and operate MySQL online over the Internet. It is the preferred database maintenance tool for many MySQL administrators and website administrators. You can use phpMyAdmin to operate the MySQL database completely.
1. Download phpMyAdmin
Open phpMyAdmin official site: http://www.phpmyadmin.net/, select "Download" on the page, the latest version is phpMyAdmin 2.10.1,select “all-languages.zip File Download
The downloaded ZIP file is a local disk that is decompressed by the decompression software. If MySQL exists locally, you can test it locally. Otherwise, you can upload it to a WEB server that supports MySQL. For example, you can upload all the extracted files to the phpmyadmin folder of leosn.com, you can access through http://leosn.com/phpmyadmin.
2. phpMyAdmin Installation
Of course, you must configure the following files to use phpMyAdmin normally, whether you are testing locally or on a remote server.
First, there is a file "config. sample. inc. php ", this is a sample file of the phpMyAdmin configuration file. We need to copy all the code in this file and create a new file"Config. inc. phpAnd paste the code. The config. inc. php file is the configuration file of phpMyAdmin, which must be uploaded to the server.
For the config. inc. php file, the most important thing is to modify the username and password used by phpMyAdmin to connect to MySQL. Find the code line:
// $ Cfg ['servers'] [$ I] ['controluser'] = 'pma '; // $ Cfg ['servers'] [$ I] ['controlpass'] = 'pmapass ';
|
Delete the "//" comment and enter the username and password configured in MySQL (contact your space service provider for remote servers). For example:
$ 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 blowfish_secret content to define the Cookie and find the code line:
$ Cfg ['blowfish _ secret'] = '';
|
Set content to COOKIE
$ Cfg ['blowfish _ secret'] = 'leosn ';
|
Iii. Use of phpMyAdmin
Open the server directory where phpMyAdmin is located, such as the http://www.leosn.com/phpmyadmin/, continue entering the MySQL user's username and password to enter.
Select a database to View tables in the database. You can add, delete, modify, and import and export database information. In short, you can select phpMyAdmin from the Chinese language family to get started soon.