Connecting to mysql
Moderator: General Moderators
Connecting to mysql
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.
- MindOverBody
- Forum Commoner
- Posts: 96
- Joined: Fri Aug 06, 2010 9:01 pm
- Location: Osijek, Croatia
Re: Connecting to mysql
You must enable remote access to database on server.
- ganesh_dabhade
- Forum Newbie
- Posts: 19
- Joined: Sun Feb 06, 2011 12:42 am
- Contact:
Re: Connecting to mysql
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.
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.
- MindOverBody
- Forum Commoner
- Posts: 96
- Joined: Fri Aug 06, 2010 9:01 pm
- Location: Osijek, Croatia
Re: Connecting to mysql
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.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.