Remote mySQL Database Connecting Problem

[nakulgoyal]

Hi Guys

I have a problem. I have a database on a server x, and a website hosted on the same server which works perfect.

I am trying to use the same database on server x from server y. When I try to connect remotely, I enter the server domain/IP instead of localhost, and it gives the error below:

Warning:
Warning: mysql_connect(): Access denied for user: 'myusername@newserverip' (Using password: YES) in /home/mydatabaseconnectionfile.php on line 72
Could not connect : Access denied for user: 'mysqlusername@newserverip' (Using password: YES)

What do you recommend? What I understand is this hosting on server X, does not allow remote connections to teh database. Is there some sort of Tunnelling I can use to connect? Both servers are Shared Hosting plans, so I do not have access to do anything except FTP into my accounts.

[Nutter]

You'll need to add newisp.com to the list of allowed hosts. What control panel software do you have on your account (cPanel, Plesk, DirectAdmin)? If it's cPanel, I can help. I haven't used the other two, but I imagine there's a way to do it.

Talk to your host. If they're good, as in good customer support, they should be able to take care of this for you.

- Ryan

[grandpa]

You may also find that this ability is an add-on service, as with my host. I can do it, if I want to pay more per month.

[nakulgoyal]

I have cpanel where the mysql database is located. I want to use it from the newisp, which is not too good in support, but I do not have a choice for some reasons to move away from them.

How do you think I can allow the newisp to be able to access the database from the oldisp which I have cpanel access to.

MANY Thanks for the quick responses.

[nakulgoyal]

Nutter, Thanks for the hint, I was right there, I just did not look. It was right there in cpanel. I allowed the newisp in the allowed hosts in the mysql manager in cpanel and it works. Thanks a ton for your time Nutter. I appreciate it.