Remote Host mysql

[slice]

I want to open databse used by my one website hosted at shared account at another host from my new website hosted at another host.
I have changed host from "localhost" to ip address of server but there is no success.
Any help please?
Thank You.

[john tindell]

The host needs to open the port on the firewall to allow remote access. As well as this the user premissions for the account need to be changed so that your account has the rights to login from a differnet machine other than localhost.

[kfcSmitty]

You may also have to specify the port in the host address.

IE) 255.255.255.255:3306

[OMITT3D]

I think the SQL server needs to be configured for remote access as well, I am not sure if it is by default.

[slice]

I have programmed a little software in Visual Basic which can connect to my database at remote host.I have also set access to %.%.%.%
But i am unable to open it from another website(hosted at another server).

[slice]

You may also have to specify the port in the host address.

IE) 255.255.255.255:3306

But in visual basic program i have mentioned only server ip address and its working great.
But problem is when i access it from another host website.
Please help me.

[kfcSmitty]

When accessing it on a local server, you're probably already within the firewall, so specifying a port isnt really important.

But, since you're trying to access it from an external site now, you may need to specify the port so it can get past the security on their end.

[slice]

Now i tried with port number but same error message


Warning: mysql_connect(): Access denied for user 'username'@'anyhost' (using password: YES)


When i tried to google that error but unfortunately only few results returned and these pages were indexed with same error not with help.

[slice]

Now this issue is becoming more complicated because i have confirmed from my database host about any restriction on remote database connection and they said no there is no restricion and i have also confirmed from my new host to confirm do they allow remote port connection outside their server and they said there is no problem and we allow it.

I have already added %.%.%.% to allow all ip addresses but still getting error mentioned in upper post.

But more tidious situation is that it has not enough help on google :(