Introduction:
1, phpmyadmin program server: 192.168.1.1, Access address is: http://192.168.1.1/phpmyadmin
2, MySQL database server: 192.168.1.2, has allowed the database outside the chain, MySQL database user name: admin password: 123456
3, now to manage the server 192.168.1.2 the MySQL database above through http://192.168.1.1/phpmyadmin
System operation and maintenance www.osyunwei.com warm reminder: qihang01 original content? Copyright, reproduced Please indicate the source and the original link
The operation is as follows:
One, download phpMyAdmin to http://192.168.1.1/phpmyadmin directory
: http://www.phpmyadmin.net/home_page/downloads.php, find the version you need
For example:
Http://ncu.dl.sourceforge.net/project/phpmyadmin/phpMyAdmin/3.4.4/phpMyAdmin-3.4.4-all-languages.tar.gz
Second, modify the config.default.php file under the Libraries folder in the phpMyAdmin directory
1. Find $cfg[' Pmaabsoluteuri ') and set its value to Http://192.168.1.1/phpmyadmin
2. Find $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, find $cfg[' Servers ' [$i] [' Password '], set its value to 123456
Three, configuration complete, now through Http://192.168.1.1/phpmyadmin input database user name: admin password: 123456 can access the server 192.168.1.2 above the MySQL database.
System operation and maintenance www.osyunwei.com warm reminder: qihang01 original content? Copyright, reproduced Please indicate the source and the original link
Note: MySQL database cannot use root account, need to create a new account, and set up the account can connect to the database remotely
Configuring phpMyAdmin to connect to a remote MySQL database