Configure phpmyadmin to connect to a remote MySQL database

1. phpmyadmin server: 172.16.1.200; access address: http://172.16.1.200/phpmyadmin 2. MySQL database server: 172.16.1.100. the external database chain is allowed. MySQL database username: admin Password: 1234563. http://172.16.1.200/phpmyadmin To manage 1. phpmyadmin program server: 172.16.1.200, access address: http://172.16.1.200/phpmyadmin 2. MySQL database server: 172.16.1.100. the external database chain is allowed. MySQL database username: admin Password: 1234563. http://172.16.1.200/phpmyadmin To manage the MySQL database on the server 172.16.1.100 as follows: 1. download phpmyadmin http://172.16.1.200/phpmyadmin Directory: http://www.phpmyadmin.net/home_page/downloads.php Find the version you need. 2. modify the config. default. php file in the libraries folder in the phpmyadmin Directory. 1. search for $ cfg ['pmaabsoluteuri '] and set its value http://172.16.1.200/phpmyadmin 2. find $ cfg ['servers'] [$ I] ['host'] and set the value to 172.16.1.100 (if Mysql is changed to localhost locally) 3. search for $ cfg ['servers'] [$ I] ['user'], set the value to admin 4, search for $ cfg ['servers'] [$ I] ['password'], and set the value to 123456. 3. the configuration is complete. http://172.16.1.200/phpmyadmin Enter the database username: admin Password: 123456 to access the MySQL database above server 172.16.1.100. Note: the root account cannot be used for MySQL databases. you need to create an account in advance and set this account to remotely connect to the database.