Configuration of phpmyadmin connecting to remote database under wamp

Introduction:

1. The server where the phpmyadmin program is located: 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. External links to the database have been allowed. MySQL database username:adminPassword: 123456

3. Now you need to passhttp://192.168.1.1/phpmyadminTo manage the MySQL database on server 192.168.1.2

The specific steps are as follows:

1. Download phpmyadmin tohttp: //192.168.1.1/phpmyadminDirectory

2. Modify theconfig.default.phpfile

1 in the libraries folder in the phpmyadmin directory , search for $cfg['PmaAbsoluteUri'], set its value tohttp://192.168.1.1/phpmyadmin

2, search for $cfg['Servers'][$i] ['host'] , set its value to 192.168.1.2

3, find $cfg['Servers'][$i]['user'] , set its value to admin

4. Find $cfg['Servers'][$i]['password'] and set its value to 123456

3. The configuration is completed, now through http://192.168.1.1/phpmyadmin Enter the database username: admin and password: 123456 to access the MySQL database on server 192.168.1.2.

But when I want to use phpmyadmin, I found the following prompt:

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

Solution:

1. Open the following file:

c:\wamp\alias\phpmyadmin.conf　　　　//这个就是你的wamp的安装目录下的内容

is not modified, such as Picture:

After modification, picture:

After modifying and saving, restart wamp!

Recommended related articles and tutorials:phpmyadmin tutorial

The above is the detailed content of Configuration of phpmyadmin connecting to remote database under wamp. For more information, please follow other related articles on the PHP Chinese website!