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

This article mainly introduces the method of configuring phpmyadmin to connect to the remote mysql database, which is very detailed and has a certain reference value. Interested friends must read 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 operations 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.

Note: MySQL database cannot use root account, you need to create a new account in advance, and set up this account to connect to the database remotely.

These are all the contents of the article "how to configure phpmyadmin to connect to a remote mysql database". Thank you for reading! Hope to share the content to help you, more related 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.