Complete guide to phpMyAdmin configuration and installation_PHP tutorial

Complete guide to phpMyAdmin configuration and installation. phpMyAdmin installation and configuration tutorial for fools. It mainly configures and installs phpMyAdmin 2.11.X. The installation method is the same for other versions.

1. First download the phpMyAdmin installation package (the one we use is normal)

2. Unzip it in a separate directory (you can customize the directory name)

3 , find the /libraries/config.default.php file (the old version is the config.inc.php file in the root directory), and edit it with WordPad (do not use Notepad, this is UTF8 encoding).

4. Find $cfg['PmaAbsoluteUri']

and change it to the URL of phpMyAdmin that you will upload to the space

For example: $cfg['PmaAbsoluteUri'] = ' http://www.phpq.net/phpmyadmin/';

5. Find $cfg['Servers'][$i]['host'] = 'localhost'; (usually the default is used, but there are also Exception, no need to modify)

6. Find $cfg['Servers'][$i]['auth_type'] = 'config';

Use config for debugging in your own machine ; If cookies are used in the Internet space, since we have added the URL before, we will change it to cookie. It is recommended to use cookies here.

7. Find $cfg['Servers'][$i] ['user'] = 'root'; // MySQL user (user name, usually just fill in a few letters here; in special cases, use root on your own machine, which is usually your ftp user name on the Internet, virtual The hosting provider will tell you, generally do not modify it.)

8. Find $cfg['Servers'][$i]['password'] = ”; // MySQL password (only needed, leave it blank OK)

9. Find $cfg['Servers'][$i]['only_db'] = ”; // If set to a db-name, only (set it if you only have one data) , set to your database name; if you want to set up a server, it is recommended to leave it blank)

10. Find $cfg['DefaultLang'] = 'zh'; (Here is the language selection, zh represents Simplified Chinese means)

11. Find $cfg['blowfish_secret'], please set the cookie of your website in the equal sign of $cfg['blowfish_secret'] = ' '; (the cookie is the domain name used to access phpmyadmin ), for example: $cfg['blowfish_secret'] = 'www.xinnethz.net';.

12. Save after setting up, now you can upload to the network space