How to install and configure phpMyAdmin_PHP tutorial-PHP Tutorial-php.cn

How to install and configure phpMyAdmin_PHP tutorial

WBOY

Release： 2016-07-13 17:15:03

Original

939 people have browsed it

phpMyAdmin is a good WEB version of mysql database management software. It only needs simple configuration before it can be used. Below I will introduce the installation, configuration and usage of phpMyAdmin.

Installation of phpMyAdmin

Of course, whether testing locally or on a remote server, the following file configuration is required to use phpMyAdmin normally.

First of all, there is a file "config.sample.inc.php" in the downloaded and decompressed file. This is a sample file of the phpMyAdmin configuration file. We need to copy all the code in the file and create a new file "config .inc.php" and paste the code. The file config.inc.php is the configuration file of phpMyAdmin. This file must be uploaded when uploading to the server.

For the config.inc.php file, the most important thing is to modify the username and password to join phpMyAdmin to connect 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 (for remote servers, please contact your space service provider), such as here:

代码如下	复制代码
$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 the blowfish_secret content definition cookie and look for the line of code:

代码如下	复制代码
$cfg['blowfish_secret'] = '';

Set content as COOKIE

代码如下	复制代码
$cfg['blowfish_secret'] = 'leosn';

3. Use of phpMyAdmin

Open the server directory where phpMyAdmin is located, such as http://www.xxx.ccc/phpmyadmin/, continue to enter the user name and password of the MySQL user, and enter.

Select the relevant database to see the tables in the database, add, delete, and modify tables and fields, and import and export database information. In short, if you choose phpMyAdmin in Chinese language, you can get started quickly.