Detailed explanation of phpMyAdmin configuration to connect to remote database

The following tutorial column of phpmyadmin will introduce to you how to configure phpMyAdmin to connect to a remote database. I hope it will be helpful to friends in need!

phpMyAdmin configuration to connect to the remote database

Background

• wampserver 3.1.7, Apache 2.4.37, PHP 7.2.14, MySql 5.7.24, thinkcmf 5.0

Configuration

Search config.inc in the wampserver installation directory and find this php file:

Note that is the one in the phpmyadmin directory. Don’t find it wrong, because there are other files with the same name!

Because the project uses mysql database, so what is changed is this host, user, password. So if the project uses, for example, mariadb, you need to find here to change the corresponding domain, username and password:

Then restart wampserver, click phpmyadmin and enter the username and password to enter. Now, you can see the remote database you are connected to.

The above is the detailed content of Detailed explanation of phpMyAdmin configuration to connect to remote database. For more information, please follow other related articles on the PHP Chinese website!