Install phpMyAdmin in ubuntu Method 1: directly run the source code (1) to install apache, and run sudoapt-getinstallapache (2) phpMyAdmin is a MySQL management tool that manages MySQL directly from the web. Assume that the root directory of your web (web page storage) is varwww. assume that the web access of your host is like this. 192.168. install phpMyAdmin on ubuntu.
Method 1: run the source code directly.
(1) install apache and run sudo apt-get install apache
(2) phpMyAdmin is a MySQL management tool that directly manages MySQL from the web.
Assume that the root directory of your web (web page storage) is/var/www/. suppose that the web access to your host is like this: http: // 192.168.1.11/
You can install it to any sub-directory of/var/www/phpmyadmin.
Note that the directory name should only be known by the administrator. Therefore, we assume it is/var/www/onlyyouknow.
A. download the latest phpMyAdmin program from the official website of phpMyAdmin.
Download phpMyAdmin-2.11.9-all-languages-utf-8-only.tar.gz to/var/www/
# Cd/var/www/
B. decompress this file
# Tar zxvf phpMyAdmin-2.11.9-all-languages-utf-8-only.tar.gz
Path/var/www/phpMyAdmin-2.11.9-all-languages-utf-8-only
C. modify the directory name/var/www/onlyyoukown.
# Mv/var/www/phpMyAdmin-2.11.3-all-languages/var/www/onlyyoukown
D. modify the configuration file.
1. find/libraries/config. default. php file (config. default. copy php to The phpmyadmin directory and rename it config. inc. php), the file has the following items (2-8) must be configured by yourself, windows with a Wordpad (do not use notepad, this is UTF8 encoding) for editing, in linux directly use vim to edit.
2. find $ cfg ['pmaabsoluteuri '] and modify the phpMyAdmin URL to be uploaded to the space.
For example, $ cfg ['pmaabsoluteuri '] = 'http: // 192.168.1.11/onlyyouknow /';
3. search for $ cfg ['servers'] [$ I] ['host'] = 'localhost'; (the default value is usually used, and there are exceptions. you do not need to modify the value)
4. find $ cfg ['servers'] [$ I] ['auth _ type'] = 'config ';
Debug config in your own machine. if you use cookies in the network space, now we have added the Web site before, and then modify it to a cookie. we recommend that you use cookies here.
5. find $ cfg ['servers'] [$ I] ['user'] = 'root'; // MySQL user (mysql user name, use root on your machine ;)
6. find $ cfg ['servers'] [$ I] ['password'] = ''; // MySQL password (mysql User password, your server is generally the root password of the mysql User)
7. find $ cfg ['servers'] [$ I] ['only _ db'] = ''; // If set to a db-name, only (if you only have one data, set it. if you want to set up a server on your local computer, leave it blank)
8. find $ cfg ['defaultlang '] = 'zh)
9. Save the settings
If the following error occurs: "the configuration file now requires a top secret phrase password (blowfish_secret)", set the cookie for your website in the equal sign of $ cfg ['blowfish _ secret'] =, example: $ cfg ['blowfish _ secret'] = 'arbitrary characters '; this is because your "$ cfg ['servers'] [$ I] ['auth _ type'] = 'cookies.
E. test
Open the browser, http: // 192.168.1.11/onlyyoukown/
Method 2: Run sudo apt-get install phpMyAdmin on the terminal. it is automatically installed under/usr/share/phpMyAdmin. then, copy phpMyAdmin to the/var/www directory and run http: // localhost/phpMyAdmin