This article describes how to set up a remote access connection from a specified ip address in mysql. the instance describes how to access a remote MySQL database from any host and a specified ip address. the code is simple and practical, for more information about how to set up a remote access connection from a specified ip address in mysql, see the following example. The specific implementation method is as follows:
1. authorize the user root to use the password jb51 to connect to the mysql server from any host:
The code is as follows:
Grant all privileges on *. * TO 'root' @ '%' identified by 'jb51 'with grant option;
Flush privileges;
2. authorize the root user to use the jb51 password to connect to the mysql server from the host with the specified ip address 218.12.50.60:
The code is as follows:
Grant all privileges on *. * TO 'root' @ '2017. 12.50.60 'identified by 'jb51' with grant option;
Flush privileges;
I hope this article will help you design MySQL database programs.