from my post as regards web site reviews, the equityportal site was yanked off by the hosts claiming it was probably illegal, so im back to hosting the site locally but i need to connect the site to another remote server for the MySQL database, but it just refuses to work... Any techie in the house woth an idea or two

Can you provide more details about what exactly you've done to try to connect?

You need to set the permisions properly to allow connection to a MySQL database from a remote host, but then the site will be very slow. In addition, a good web host would have a firewall setup such that it won't be possible to connect to their MySQL servers from outside their network.

So why not download MySQL server and run it locally, too? And when you say you're running it locally, do you mean on your PC?

About equityportal, I'm going to take another look at it when it's back up to verify that it's legitimate.

You tried connecting. and it refuse.. are u sure the host support Mysql. and if it does.. can you post your codes here, with that we could easly see wat is wrong. or better still use this code to check if that is enabled.. <?phpinfo();?> save that and check it out.

its not about permissions.. its more of ip routing.. most host use "localhost as deafualt server address or 127.0.0.1 but any other ip should do if the mysql is hosted on that gateway, but if its not then what else.. tried some php5 tricks but the didnt work..

@Seun "About equityportal, I'm going to take another look at it when it's back up to verify that it's legitimate."

well its very legitimate, ive been handling their designs for two tyrs now, all we wanted to do was do creat a dynamic site using a mysql site but remotely hosted so we wouldnt tamper with the existing service on the site...

Well some host allow you to connect to there server from anoda. If are using cpanel its easier to do. Click mysql->scroll down to see allow ip to connect.

A Seun said you may download Mysql and run locally. All you need do is go to the phpmyadmin and export the database then run it on mysql and all the data will be transfered.

You may go www.easyphp.org  to download and install apache,php,phpMyadmin and mysql with clicks.  Then its going to work.

Timmy Tried what Skima said there

hmm really, Seun is very right, many hosts dissallow remote mysql connection for obvious reasons. Just install it locally and fire it on.

guys i already know skima's lessons, what i needed was a remote connection, the local system(server) runs a pws service and i can tamoer with that. ill rather just chill. anyway tank God they've merged pheeww!! ill just escape from that.. tanks all the same guys.. u all r cool

Im just praying my proposal for the mega merger clicks

If and when you know if your server supports MySQl server, find out the IP name or the URL you can connect with either also. all these with the localhost naming are supported,generally