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

Editor to share with you the wamp phpmyadmin connection to the remote database configuration method, I believe that most people do not know much about it, so share this article for your reference, I hope you will learn a lot after reading this article, let's go to know it!

Introduction:

1. The server where the phpmyadmin program resides: 192.168.1.1, and the access address is: http://192.168.1.1/phpmyadmin.

2. The server where the MySQL database is located: 192.168.1.2, which has been allowed to link outside the database. MySQL database user name: admin password: 123456

3. Now you need to manage the MySQL database on server 192.168.1.2 through http://192.168.1.1/phpmyadmin.

The specific steps are as follows:

Download phpmyadmin to the http://192.168.1.1/phpmyadmin directory

Modify the config.default.php file under the libraries folder in the phpmyadmin directory

1. Look for $cfg ['PmaAbsoluteUri'] and set its value to http://192.168.1.1/phpmyadmin

2. Look for $cfg ['Servers'] [$I] [' host'] and set its value to 192.168.1.2

3. Find $cfg ['Servers'] [$I] [' user'] and set its value to admin

4. Look for $cfg ['Servers'] [$I] [' password'] and set its value to 123456

Third, the configuration is complete, now enter the database user name: admin password: 123456 through http://192.168.1.1/phpmyadmin to access the MySQL database above the server 192.168.1.2.

But when you want to use phpmyadmin, the discovery prompts you as follows:

You don't have permission to access / phpmyadmin/ on this server.

Solution:

1. Open the following file:

C:\ wamp\ alias\ phpmyadmin.conf / / this is the content of your wamp installation directory

Unmodified, as shown in the figure:

After modification, as shown in the figure:

After modifying and saving, restart wamp!

These are all the contents of the article "how to configure phpmyadmin to connect to a remote database in wamp". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.