How to configure phpmyadmin to connect to the remote mysql database

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, database external links have been allowed, MySQL database username: admin Password: 123456

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

The specific operations are as follows:

1. Download phpmyadmin to http://192.168 .1.1/phpmyadmin directory

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

1. Find $cfg['PmaAbsoluteUri'] and change it Set the value to http://192.168.1.1/phpmyadmin

2. Find $cfg['Servers'][$i]['host'] and set its value to 192.168.1.2

3. Search for $cfg['Servers'][$i]['user'] and set its value to admin

4. Search for $cfg['Servers'][$i][' password'], set its value to 123456

3. Configuration is complete, now enter the database user name: admin Password: 123456 through http://192.168.1.1/phpmyadmin to access the server 192.168.1.2 MySQL database.

Note: The MySQL database cannot use the root account. You need to create a new account in advance and set the account to remotely connect to the database.

Recommended related articles and tutorials: phpmyadmin tutorial

The above is the detailed content of How to configure phpmyadmin to connect to the remote mysql database. For more information, please follow other related articles on the PHP Chinese website!