Ubuntu Assembly phpMyAdmin

Ubuntu Installation phpMyAdmin
method One: direct operation of the source code
(1) Install Apache, run sudo apt-get install Apache
(2) phpMyAdmin is a MySQL management tool that manages MySQL directly from the web.
Assuming your web (web hosting) root directory is/var/www/assume that your host Web Access is such http://192.168.1.11/

You can install him into/var/www/phpmyadmin, of course, but/var/www/'s arbitrary sub-directory.

Note that this directory name is best known only by the administrator. So we're assuming/var/www/onlyyouknow.

A. Go to phpMyAdmin's official station to download the latest phpMyAdmin program

Download the phpmyadmin-2.11.9-all-languages-utf-8-only.tar.gz to/var/www/

#cd/var/www/

B. Unzip this file

# tar ZXVF phpmyadmin-2.11.9-all-languages-utf-8-only.tar.gz

This is the path/var/www/phpmyadmin-2.11.9-all-languages-utf-8-only

C. Modify the directory named/var/www/onlyyoukown

# Mv/var/www/phpmyadmin-2.11.3-all-languages/var/www/onlyyoukown

D. Modify the settings file

1. Locate the/libraries/config.default.php file (config.default.php copied to the phpMyAdmin directory and rename it to config.inc.php), which has the following items (2-8) to be configured on its own , Windows uses WordPad (do not use Notepad, which is UTF8 encoding) for editing, directly under Linux with Vim.

2. Find $cfg [' Pmaabsoluteuri '] to modify the URL of the phpmyadmin you will upload to the space

such as: $cfg [' pmaabsoluteuri '] = ' http://192.168.1.11/onlyyouknow/';

3. Find $cfg [' Servers '] [$i] [' host '] = ' localhost '; (usually with default, with exception, without modification)

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

Debug in your own machine with config; if the space on the network with a cookie, here we have already added the URL in the previous, the change to a cookie, here is recommended to use cookies.

5. Find $cfg [' Servers '] [$i] [' user '] = ' root '; MySQL user (MySQL username, root in his machine)

6. Find $cfg [' Servers '] [$i] [' password '] = '; MySQL password (mysql user's password, their server is generally the password of the MySQL user root)

7. Find $cfg [' Servers '] [$i] [' only_db '] = '; If set to a db-name, only (you have only one data set up; If you're on this computer or want to build a server, leave the suggestion blank)

8. Find $cfg [' defaultlang '] = ' zh '; (Here is the choice of language, zh for Simplified Chinese meaning, here do not know to fill GBK to No)

9. Save when Setup is complete

If "configuration file now requires top secret phrase password (blowfish_secret)" then please set your website's cookie in the equal sign of $ cfg[' blowfish_secret '] = ", for example: $cfg [' Blowfish_ Secret '] = ' any character '; This is because of your "$cfg [' Servers '] [$i] [' auth_type '] = ' cookie '.

E. Testing

Open Browser, http://192.168.1.11/onlyyoukown/

Method Two: Running sudo apt-get install phpMyAdmin at the terminal will automatically be installed under/usr/share/phpmyadmin, then copy phpMyAdmin to the/var/www directory and run HTTP// Localhost/phpmyadmin can

