Shulou(Shulou.com)06/02 Report--

This article mainly explains "the configuration steps of phpmyadmin". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Next, let the editor take you to learn the "phpmyadmin configuration steps"!

1. Install LEMP first

Https://www.digitalocean.com/community/tutorials/how-to-install-linux-nginx-mysql-php-lemp-stack-ubuntu-18-04

two。 Install phpmyadmin

Https://www.digitalocean.com/community/tutorials/how-to-install-and-secure-phpmyadmin-on-ubuntu-18-04

There may be multiple configuration files after installation

/ usr/share/phpmyadmin/config.inc.php

/ etc/phpmyadmin/config.inc.php

The first one that has been changed all the time, it always doesn't take effect after the change, and I was killed. I finally found that I used the configuration file under the second path, probably because I installed it with the apt command.

If you want to connect to multiple databases, you can configure multiple addresses in config.inc.php

Refer to the following configuration and note to comment out the I variables defined in the source file

Don't forget to add an account to the database that needs to be connected and authorize it, otherwise the connection will report an error.

Mysql creates an account and authorizes:

CREATE USER 'phpmyadmin'@'xx' IDENTIFIED BY' 123456 users / create users

GRANT all ON *. * TO 'phpmyadmin'@'192.168.1.100';// authorization

Flush privileges;// update permissions

At this point, I believe that everyone on the "phpmyadmin configuration steps" have a deeper understanding, might as well to the actual operation of it! Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.