I can't connect Joomla! remotely with MySQL

[Abdusalam]

I have two hosting (1 and 2), and I have Joomla website files on hosting 1, Joomla mysql database on hosting 2, both hosting 1 and 2 have Cpanel administration. I want run Joomla website on host1 by linked it remotely to mysql database on host 2

Steps that I made:

- In hosting 2 added IP address for hosting 1 in (Remote MySQL).
- In Joomla configuration.php file I have changed database section like:

var $host = '74.116.84.169';
var $user = 'artjour';
var $password = 'abc@123';
var $db = 'apuser';

- I also have changed the host name by server name like:

var $host = 'servername.mydomainname.com';

But unfortunately , Could not connect to MySQL, please it's very important for me to know what's my wrong here.

Thanks in advance.

[sander_v_bergen]

In Cpanel, did you add the correct address under Remote MySQL? Try adding % (=wildcard) and see if that helps.
If so, change % to the correct address.

[Tonie]

Is the mysql user allowed to connect to the database on a remote server? Often, it's only allowed to connect to the server the database is running on.