Mysql permission

[12345FOBEY12345]

Hi all,

My DB is hosted locally along with the server and the CMS is hosted on cPanel hosting.

Just wondering how I add permissions for my CMS to connect to the DB?

This is the error code I get when I view the site...

Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'ip of the VPS' (4) in /home/*****/public_html/cms/app/class.engine.php on line 48
MySQL Engine - RevCMS:

Thanks for any help in advance!

EDIT: I've added the permissions to PhpMyAdmin for the Ip of the do main what I obtained by pinging the domain. Still no luck.

[MentaL]

[12345FOBEY12345]

bump.

[MikeDavies]

This makes absolutely no sense, please try and speak proper English.

[12345FOBEY12345]

This makes absolutely no sense, please try and speak proper English.

Right, My database is being hosted on my VPS along with the EMU.

The CMS however is hosted on a cPanel. Now, the CMS is unable to connect to the database as I don't get how I add permission for it meaning it is able to connect.

That better? :S

[TPStudios]

I'll tell you why..

Now, 100% of the Free Hosting website with CPANELs, DBs and other have their Databases Remote Connection Disabled...
Which means that only the Website you created can access the Database..
The solution is to look for a website host with Database Remote Connection Enabled (I guarantee that you won't find one for free) or to look for a Database host with also remote connection enabled (You won't find for free..)

That's all

[MikeDavies]

I'll tell you why..

Now, 100% of the Free Hosting website with CPANELs, DBs and other have their Databases Remote Connection Disabled...
Which means that only the Website you created can access the Database..
The solution is to look for a website host with Database Remote Connection Enabled (I guarantee that you won't find one for free) or to look for a Database host with also remote connection enabled (You won't find for free..)

That's all

It's a security risk to hosts with Remote MySQL, so yes as this guy has said, they block it.

[12345FOBEY12345]

I'll tell you why..

Now, 100% of the Free Hosting website with CPANELs, DBs and other have their Databases Remote Connection Disabled...
Which means that only the Website you created can access the Database..
The solution is to look for a website host with Database Remote Connection Enabled (I guarantee that you won't find one for free) or to look for a Database host with also remote connection enabled (You won't find for free..)

That's all

I pay for my hosting...