PhpMyAdmin-3.5.2.2-all-languages.zip installation Configuration

Document directory

• 2. Configure Default Server access.
• 3. Configure multi-server access

PhpMyAdmin-3.5.2.2-all-languages.zip installation Configuration

1. Download The phpmyadmin-3.5.2.2-all-languages.zip file and click Download.
2. Configure Default Server access.

A. decompress the file to the website directory.

B.

C. Enter

Open the config. Default. php file.

D. find $ cfg ['pmaabsoluteuri ']

Modify the phpMyAdmin URL that you will upload to the space
For example, $ cfg ['pmaabsoluteuri '] = 'HTTP: // www.piaoyi.org/phpmyadmin /';
Here, because I am local debugging, I changed it to $ cfg ['pmaabsoluteuri '] = 'HTTP: // localhost/PHPmyAdmin /';
Note: Do not miss the last backslash (/) and HTTP at the beginning.

E. find $ cfg ['servers'] [$ I] ['host'] = 'localhost)

F. find $ cfg ['servers'] [$ I] ['auth _ type'] = 'config ';

Debug config in your own machine; if the space on the network uses cookies, now that we have added a URL before, we will change it to a cookie.
My personal suggestion: both on the local network and on the network, we recommend that you set the cookie to be the first in security.
At the same time, when the auth_type value is set to cookie, there is also a need to make the appropriate changes:
$ Cfg ['blowfish _ secret'] = '';
Change to: $ cfg ['blowfish _ secret'] = 'www .piaoyi.org ';
Www.piaoyi.org can be defined at will, with no more than 46 characters. If this field is left blank, the above 2nd error will occur: "the configuration file now requires a top secret phrase password (blowfish_secret )".

G. find $ cfg ['servers'] [$ I] ['user'] = 'root'; // MySQL user (user name, root in your machine; this is generally your FTP user name on the Internet, which the VM provider will tell you. Do not change it)

H. find $ cfg ['servers'] [$ I] ['Password'] = '000000'; // MySQL password (123456 changed to the user password used to connect to your MySQL database)

J. find $ cfg ['defaultlang '] = 'zh _ cn'. (select the language here. zh_cn indicates the meaning of Simplified Chinese)

H. find $ cfg ['servers'] [$ I] ['allownopassword'] = true; (the function here is to check whether empty passwords are allowed for Logon)

I. Now you can access the website!

3. Configure multi-server access

A. Create the config folder in the phpMyAdmin directory. Copy config. sample. Inc. php to the config file and change it to config. Inc. php.

B. Open Web site: http://www.xxxxxx.com/phpMyAdmin-3.5.2.2-all-languages/setup/index.php

C. load configuration: Click the Load button!

The server List displays the corresponding information!

D. Click the edit button to configure the server. Be sure to save the configuration!

E. If the configuration is complete, copy the config/config. Inc. php file to the phpMyAdmin root directory and delete the config folder.

F. The configuration is complete. Let's take a look at the effect:

4. of course, we can also directly use the code to modify the config under the phpMyAdmin root directory. inc. PHP (if not, copy config. simple. inc. PHP is renamed config. inc. PHP) format:

<?php/* * Generated configuration file * Generated by: phpMyAdmin 3.5.2.2 setup script * Date: Thu, 30 Aug 2012 07:53:35 +0000 *//* Servers configuration */$i = 0;/* Server: localhost [1] */$i++;$cfg['Servers'][$i]['auth_type'] = 'cookie';$cfg['Servers'][$i]['host'] = 'localhost';$cfg['Servers'][$i]['connect_type'] = 'tcp';$cfg['Servers'][$i]['compress'] = false;$cfg['Servers'][$i]['extension'] = 'mysqli';$cfg['Servers'][$i]['AllowNoPassword'] = false;/* Server: 192.168.2.109 [2] */$i++;$cfg['Servers'][$i]['auth_type'] = 'cookie';$cfg['Servers'][$i]['host'] = '192.168.2.109';$cfg['Servers'][$i]['connect_type'] = 'tcp';$cfg['Servers'][$i]['compress'] = false;$cfg['Servers'][$i]['extension'] = 'mysqli';$cfg['Servers'][$i]['AllowNoPassword'] = false;/* End of servers configuration */$cfg['blowfish_secret'] = 'a8b7c6d';$cfg['UploadDir'] = '';$cfg['SaveDir'] = '';$cfg['DefaultLang'] = 'zh_CN';$cfg['ServerDefault'] = 2;?>