Configure phpMyAdmin and linuxphpmyadmin on the Linux Server

Configure phpMyAdmin and linuxphpmyadmin on the Linux Server

Phpmyadmin is a friendly mysql management tool developed using php and mysql, and is free and open-source. Many domestic virtual hosts come with such a management tool, which is easy to configure, next, configure phpmyadmin on the linux server to manage the MySQL database.

First, visit the homepage of the phpmyadmin website:

　　

Download the package and upload it to the server. Then run the following command to decompress the package:

tar -xvzf phpMyAdmin-4.5.5.1-all-languages.tar.gz

After decompression, we put it in a directory that can be accessed by the web, and facilitate subsequent management, such as/home/wwwroot.

mv phpMyAdmin-4.5.5.1-all-languages /home/wwwroot/

Then run cd/home/wwwroot/and rename the phpmyadmin directory. Try not to let others guess the portal, for example:

mv phpMyAdmin-4.5.5.1-all-languages phpmyAdmina4689f

Then execute cd phpmyAdmina4689f to enter the installation directory, the latest phpmyadmin support quick configuration, do not execute the installation script, the official quick installation of Chinese documents: http://docs.phpmyadmin.net/zh_CN/latest/setup.html#quick-install

At this time, we can see a configuration file in the directory: config. sample. inc. php

Copy this file:

cp config.sample.inc.php config.inc.php

Then execute EDIT:

vim config.inc.php

Find the $ cfg ['blowfish _ secret'] configuration item, which is left blank by default. Here we can set a complicated string for encryption:

　　

Then, $ cfg ['servers'] [$ I] ['auth _ type'] is a cookie by default, indicating that every login is required. We do not need to modify it, which is safer, then $ cfg ['servers'] [$ I] ['host'] = '2017. 0.0.1 '; we recommend that you set this parameter to an IP address, so that no problem occurs for both local and remote mysql authorization, the default localhost may cause errors such as #2002-Permission denied-The server is not responding. Note that The IP address is recommended.

　　

If local debugging is performed, set it to config, and enter the user name and password here. the user name and password will automatically enter each time, making debugging easier.

In general, the above login authentication type and IP address are set in total. After the setting is complete, save and exit, and then access the phpmyadmin directory address through the web, for example, put it under www.xxxx.com, in this case, we need to access: Ingress