How to install and configure phpMyAdmin in a VM

PhpMyAdmin is a set of PHP programs that can manage MySQL-server and a single database through the WEB. For some virtual space sites, it should be indispensable !!!

PhpMyAdmin is a set of PHP programs that can manage MySQL-server and a single database through the WEB. For some virtual space sites, it should be indispensable !!!

First download can be from its official site point http://www.phpmyadmin.net/download. Different program compression methods are provided for download on the site. Here I select bzip2 for download (because the file size is smaller, other formats can also be used ).

Set phpmyadmin.
Decompress the package and obtain a directory. Go to the relevant directory and open the config. inc. php file,
Find $ cfg ['pmaabsoluteuri ']
Modify the phpMyAdmin URL that you will upload to the space
For example, $ cfg ['pmaabsoluteuri '] = 'HTTP: // your site/phpmyadmin /';

And the following
$ Cfg ['servers'] [$ I] ['host'] = 'localhost'; (by default, there are exceptions)

$ Cfg ['servers'] [$ I] ['auth _ type'] = 'cooker'; // Authentication method (config, http or cookie based )?
Debug config in your own machine, if you use cookies on the Internet. Because it is a virtual host, we can select cookies here.

$ Cfg ['servers'] [$ I] ['user'] = 'root'; // MySQL user (user name, root in your machine, set your mysql user name on the Internet)
$ Cfg ['servers'] [$ I] ['Password'] = ''; // MySQL password (only needed
You do not need to set it in your own machine
$ Cfg ['servers'] [$ I] ['only _ db'] = ''; // If set to a db-name, only (you have only one data set)

Note: $ cfg ['blowfish _ secret'] = '';
You do not need to set the local machine, but you need to set the network to cookie:
$ Cfg ['blowfish _ secret'] = 'cooker ';

After the settings are complete, you can upload them to the Internet.

Visit http: // your site/phpmyadmin/which is used if you set it differently.
If you set $ cfg ['servers'] [$ I] ['auth _ type'] = 'cooker', the account password is required, the account and password here are the account and password of the mysql database you obtained from the provider.