phpMyAdmin Installation Method

phpMyAdmin

phpMyAdmin is a database management tool for MySQL based on PHP, web-base architecture on the Web site host.

You can manage the entire MySQL server (requiring superuser), or you can manage a single database. To implement the latter, you will need to properly set up the MySQL user, who can only read/write to the allowed database. That's until you've read the relevant parts of the MySQL manual.

Installation and Configuration

1, the official download site http://www.phpmyadmin.net/Currently the latest version is phpMyAdmin 3.0.0-rc1.

The site provides a different program compression for us to download, here I choose the bzip2 way to download (because this file size smaller, the other format can also).

Here we start to set up the phpMyAdmin.

2, after decompression to get a directory, into the relevant directory of the Libraries directory, find config.default.php file copy to the superior directory, and named config.inc.php;

In the config.inc.php

Find $cfg [' Pmaabsoluteuri ']

Modify the URL of the phpMyAdmin that you will use to access the virtual machine user

such as: $cfg [' pmaabsoluteuri '] = ' http://ip/phpmyadmin/'; or $cfg[' pmaabsoluteuri '] = ' http://ip:8899 ' (write out the absolute URL of the access phpMyAdmin)

There are also these changes in place:

$cfg [' Servers '] [$i] [' host '] = ' localhost ';(usually with default, with exceptions)

$cfg [' Servers '] [$i] [' auth_type '] = ' cookie '; authentication method (config, HTTP or cookie based)?

with cookies. Because it is used on the network, so select cookies here

$cfg [' Servers '] [$i] [' user '] = ' root '; MySQL User

$cfg [' Servers '] [$i] [' password '] = '; MySQL password (only needed not set in your own machine)

Note: $cfg [' blowfish_secret '] = ';

This machine does not need to be set, but the network needs to be set to cookies:

$cfg [' blowfish_secret '] = ' cookie ';

Setup is complete.

3, open IE, input http://ip/phpmyadmin/(of course you set a different use of that Web site.) , enter user name and password, use phpMyAdmin to browse the corresponding MySQL database;

If set $cfg[' Servers ' [$i] [' auth_type '] = ' cookie '; So the display will require an account entry.

4, $cfg [' defaultlang '] = ' en '; (This is the choice of language, en represents the meaning of Simplified Chinese)