PhpMyAdmin getting started with download, installation, and usage

Source: Internet
Author: User

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.




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.