Home  >  Article  >  Database  >  Detailed explanation of phpMyAdmin configuration to connect to remote database

Detailed explanation of phpMyAdmin configuration to connect to remote database

藏色散人
藏色散人forward
2021-02-28 16:20:513136browse

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!

Detailed explanation of phpMyAdmin configuration to connect to 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:
Detailed explanation of phpMyAdmin configuration to connect to remote database

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

Detailed explanation of phpMyAdmin configuration to connect to remote database

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:
Detailed explanation of phpMyAdmin configuration to connect to remote database

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!

Statement:
This article is reproduced at:segmentfault.com. If there is any infringement, please contact admin@php.cn delete