Remote Add Host for Mysql database connection from other domain

[sekhar]

I have a domain www.xyz.org, where mysql database resides. Example IP address is 1:2:3:4
I have a domain www.ebrahma.me, where App software php connection file is present. Example IP address is 10:20:30:40
I have added 10.20.30.40 "ADD HOST" in www.xyz.org [DirectAdmin]

In www.ebrahma.me, php file
@Hostname = 10.20.30.40
@dbuser = admin
@dbpassword = adminp
@dbname = superdb
@port = 3306

https://www.ebrahma.me/argm/conc.php

It throws Error Connection refused.
I am trying to connect the database of www.xyz.org from php of www.ebrahma.me.

Kindly help it

 

[Daniel_Dog]

Did you allow port 3306 though the firewall? By default this port is blocked in the firewall for both inbound and outbound.

 

[Richard G]

In www.ebrahma.me, php file
@Hostname = 10.20.30.40

Seems wrong to me. This should be

@hostname = 1.2.3.4
because that is where your database resides you said. The hostname is the hostname (or ip) for the mysql server, not the hostname (or ip) used for the website.

And what realcryptonight already stated... on both servers.