Connect MySQL using phps on different network

[cjagdish69]

The mysql server is running on 172.x.x.x:3306 and the phps are on server having 192.x.x.x. The database on 172.x.x.x is to be accessed for read/write on 172.x.x.x but the same database is required to be accessed for read only on 192.x.x.x.

Presently one proxy is running in between these 2 networks.

How to connect the database on 172.x.x.x from phps on 192.x.x.x ?

[johny10151981]

If you have proper routing between two network then

create a user with the host 192.x.x.x. Set the privileges properly and you will get the access