Connect To Mysql Db From Outside Tch?

[Geuis]

I have another website that's not hosted from TCH. I'm trying to run a script on that website that connects to a database I have on our TCH account.

 

Instead of 'localhost' I used server52.totalchoicehosting.com. Its giving me this error, w/ our username blanked of course.

 

Warning: mysql_connect(): Access denied for user '******'@'64.49.***.***' (using password: YES) in /index.php on line 278

Could not connect: Access denied for user '********'@'64.49.***.***' (using password: YES)

 

How can I do this?

[TCH-Don]

As I see it you need to give access to the remote site in your cpanel > MySQL Databases,

I did find a post by TCH-David that may help.

[j2k4b]

Not that I need this information but it was nice to learn something.

[TCH-Tom]

Yes as Don has suggested, you need to add the IP from which you are trying to connect to the 'Access Hosts' list .

[anand4linux]

I think Geuis wants the script to access the remote mysql database, not himself from his local machine. In that case he needs to grant permission for the "mysqluser" to access the database from the "ip of the server which has the php script"

 

something like this...

 

mysql> grant all privileges on dbname.* to 'mysqluser'@'<ipaddress or servername' identified by 'password' with grant option;

 

 

Anand S