How to install phpmyadmin in Linux

Article Title: how to install phpmyadmin in Linux. Linux is a technology channel of the IT lab in China. Includes basic categories such as desktop applications, Linux system management, kernel research, embedded systems, and open source.

When installing fedora, select all the components to be selected, including Appache, mysql, and php. But when we manage the database, it is easier to have a graphical interface, so we have installed phpmyadmin on our own and it is easy to install.

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/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 to the Administrator. Therefore, we assume/var/www/onlyyouknow

A. download the latest phpMyAdmin program from the official website of phpMyAdmin.

Http://superb-east.dl.sourceforge.net/sourceforge/phpmyadmin/phpMyAdmin-2.11.3-all-languages.tar.gz

Download phpMyAdmin-2.11.3-all-languages.tar.bz2 to/var/www/

# Cd/var/www/

# Wget http://superb-east.dl.sourceforge.net/sourceforge/phpmyadmin/phpMyAdmin-2.11.3-all-languages.tar.gz

Of course, you can also go to your own windows machine, and upload it to the web server after editing.

B. Decompress this file

# Tar zxvf phpMyAdmin-2.11.3-all-languages.tar.gz

Path/var/www/phpMyAdmin-2.11.3-all-languages

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/

Personal Opinion

We believe that it is not a safe way to control mysql through the root user of mysql on the web. Therefore, my suggestion is that if you are using your own server, you can put the phpadmin Directory into a directory inaccessible to the web. When you want to use it, use the mv command to move the entire directory back to its original location.