i have to database server one with Postgresql and the other with MySQL on the same network.I established a connection from my machine to the server hosting mysql database and i want to connect between the other server hosting my application with the postgresql database but it fails. I allowed connection from all IP addresses in the machine hosting the mysql database by granting all access with the wildcard %.
Any help on what is preventing the application in the postgresql server machine from connecting to the one with the mysql server while the connection from local machine's XAMPP to the mysql in the other mysql server is successfully?
Thanks in advance