Page 1 of 1

Connecting to mysql

Posted: Fri Feb 04, 2011 7:02 pm
by danwguy
I have a website set up on ipower.com and everything is running fine, I set up IIS locally and installed php so I can run and test code locally before making it live on the server but my problem is I can't seem to connect to the mysql database from my computer. If I run the php on their server it runs fine, but when I do it locally I get the message "Could not Connect: php_network_getaddresses: getaddrinfo failed: No such host is known." I am not using localhost in my php connection script I am using the address they gave me which was "*******.ipowermysql.com" any ideas on how I can connect to that db from my computer so I can run all my tests and such without having to go through the stupid console everytime and uploading everything? Thank you in advance.

Re: Connecting to mysql

Posted: Fri Feb 04, 2011 8:07 pm
by MindOverBody
You must enable remote access to database on server.

Re: Connecting to mysql

Posted: Sun Feb 06, 2011 3:23 am
by ganesh_dabhade
Yes. MindOverBody is right.

The another way is that If u set your mind for making live changes, u can use notepad++ which has inbuilt ftp client. U can edit ur code as u edit and save on local computer. It will automatically be uploaded to the server when u save the file.

But don't forget to take backup / download of your work.

Significance of being LIVE is that you can work from anywhere.

Re: Connecting to mysql

Posted: Sun Feb 06, 2011 9:21 am
by MindOverBody
ganesh_dabhade wrote:Yes. MindOverBody is right.

The another way is that If u set your mind for making live changes, u can use notepad++ which has inbuilt ftp client. U can edit ur code as u edit and save on local computer. It will automatically be uploaded to the server when u save the file.

But don't forget to take backup / download of your work.

Significance of being LIVE is that you can work from anywhere.
Yap, that is also solution. I am working with PSpad, and it is doing great job. It have implemented FTP and million of other functionalities for developing PHP, C++, XML, CSS, HTML, Python... and many more. :D