How to install and configure phpMyAdmin. PhpMyAdmin is a good WEB version of mysql database management software. you only need to perform simple configuration and use it. next I will introduce phpMyAdmin installation and configuration methods. phpMyAdmi phpMyAdmin is a good WEB version of mysql database management software. it can be used after simple configuration. next I will introduce how to install and configure phpMyAdmin.
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. php, and 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:
The code is as follows: |
|
// $ 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:
The code is as follows: |
|
$ 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:
The code is as follows: |
|
$ Cfg ['blowfish _ secret'] = ''; |
Set content to COOKIE
The code is as follows: |
|
$ Cfg ['blowfish _ secret'] = 'leosn '; |
III. Use of phpMyAdmin
Open the phpMyAdmin server directory, such as http://www.xxx. ccc/phpmyadmin/, continue to enter the MySQL User name 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.
Metadata. phpMyAdmi...