Connecting to mysql

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
danwguy
Forum Contributor
Posts: 256
Joined: Wed Nov 17, 2010 1:09 pm
Location: San Diego, CA

Connecting to mysql

Post 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.
User avatar
MindOverBody
Forum Commoner
Posts: 96
Joined: Fri Aug 06, 2010 9:01 pm
Location: Osijek, Croatia

Re: Connecting to mysql

Post by MindOverBody »

You must enable remote access to database on server.
User avatar
ganesh_dabhade
Forum Newbie
Posts: 19
Joined: Sun Feb 06, 2011 12:42 am
Contact:

Re: Connecting to mysql

Post 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.
User avatar
MindOverBody
Forum Commoner
Posts: 96
Joined: Fri Aug 06, 2010 9:01 pm
Location: Osijek, Croatia

Re: Connecting to mysql

Post 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
Post Reply