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.
