Find the config in your phpmyadmin directory. inc. open the php file with DW (do not use notepad to open it. if it is a uft8-encoded file, you will be afraid of problems) find the [#39; host #39 #... find the config in your phpmyadmin directory. inc. open the php file with DW (do not use notepad to open it. if it is a uft8-encoded file, you may be afraid of problems)
Change 'localhost' after ['host'] to the remote database IP address.
The instance code is as follows:
$ Cfg ['servers'] [$ I] ['host'] = '2017. 168.1.10 ';
Note: 192.168.1.10 is the IP address of the remote database.
Restart mysql again. The command mode is as follows:
After modification, --- start menu ---- run ---- cmd (press enter) ---- net stop mysql (press enter) -------- net start mysql (press enter)
If we do not have the command line, we can enter the service console on the computer, and then find mysql.exe on the application server to restart.
Permanent link:
Reprint at will! Include the article address.