Find the configincphp file in your phpmyadmin directory and open it with DW (note that you must never use notepad to open it. if it is a uft8-encoded file, you may be afraid of problems)
Find the config. inc. php file in your phpmyadmin directory and open it with DW (note that you must never 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.