raj555 Posted April 17, 2007 Share Posted April 17, 2007 I am facing an issue over MySQL database. I have a client whose website (PHP based) is hosted on a linux server located in UK. We are planning to install several features like link exchange directory (PHP), Forums(PHP) etc etc, but the hosting provider is asking for a hefty amount to create simple databases. I am having several hosting accounts in Godaddy Hosting which provides me around 50-100 free MySql Databases. Is it possible to install application like link exchange directory (PHP) on a server "ABC" (MySql Version 5), but having MySql Database using a different service provider "XYZ" (MySql Version 5). What is the procedure to install application using remote MySQL Server rather than a local MySql purchased from the hosting provider itself ?? When I install the application using remote mysql database ,it throws an error Could not connect to MySQL server: Can't connect to MySQL server on 'https' (10061) Could not select database datinghawk: Can't connect to MySQL server on 'https' (10061) I am using Hostname as : https://mysqladmin2.secureserver.net/m50/11 username : datinghawk Password : Do let me know what is the procedure to install a PHP application on a server using a remote MySQL located on different server. I am not an expert in Mysql so please post simple explanation if possible along with technical explanation Kindly Help me Out ??? Quote Link to comment https://forums.phpfreaks.com/topic/47390-need-help-regarding-configuration-of-remote-mysql-database/ Share on other sites More sharing options...
Wildbug Posted April 17, 2007 Share Posted April 17, 2007 I'm no expert when it comes to MySQL not on 127.0.0.1, but I don't think the hostname should be given as an HTTP URL, as it isn't -- it's MySQL. It should be something like: mysqladmin2.securesever.net:3306 ...assuming standard the MySQL port. You'll have to check with your service provider for the proper port otherwise. $0.02? Quote Link to comment https://forums.phpfreaks.com/topic/47390-need-help-regarding-configuration-of-remote-mysql-database/#findComment-231248 Share on other sites More sharing options...
gluck Posted April 19, 2007 Share Posted April 19, 2007 Well you need to check with the Database Server hosting people if they allow remote connection or not. If they do then ask them the exact configuration (IP, port etc). Quote Link to comment https://forums.phpfreaks.com/topic/47390-need-help-regarding-configuration-of-remote-mysql-database/#findComment-233653 Share on other sites More sharing options...
Guest prozente Posted April 19, 2007 Share Posted April 19, 2007 As was said before, you need to use the correct hostname. Using http:// won't cut it. You will also need to grant permissions for your MySQL user to allow connections from your other server. If you are using phpMyAdmin it is located under the "Privileges" link. Quote Link to comment https://forums.phpfreaks.com/topic/47390-need-help-regarding-configuration-of-remote-mysql-database/#findComment-233657 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.