phpMyAdmin installation and configuration How to use _php tutorial

Source: Internet
Author: User
phpMyAdmin is a good MySQL database management web version of the software, just a simple configuration can be used, let me introduce the phpMyAdmin installation and configuration usage.

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:

The code is as follows Copy 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:

The code is as follows Copy Code
$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:

The code is as follows Copy Code
$cfg [' blowfish_secret '] = ';

Set content to Cookie

The code is as follows Copy Code
$cfg [' blowfish_secret '] = ' leosn ';

Third, the use of phpMyAdmin

Open the phpMyAdmin server directory, such as Http://www.xxx. Ccc/phpmyadmin/, and continue entering the MySQL user's username and password.



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/628932.html www.bkjia.com true http://www.bkjia.com/PHPjc/628932.html techarticle phpMyAdmin is a good MySQL database management web version of the software, just a simple configuration can be used, let me introduce the phpMyAdmin installation and configuration usage. PHPMYADMI

  • 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.