Community Q&A:
PHP mySQL server name for different website
I'm creating a website for a client with a different web host. However, they don't have mySQL support yet. I would like to build a PHP site that can connect to a mySQL database with my host site with the Hub (for now).
mysql_connect("localhost",$user,$pass);
Usually I use "localhost" for the server name when the mySQL db is on my site. However, if this site is on a different web host's server, that won't work. What should be there? I've tried my IP, IP:port, servername:port and servername and it won't connect.
Any suggestions? Thanks
mysql_connect("localhost",$user,$pass);
Usually I use "localhost" for the server name when the mySQL db is on my site. However, if this site is on a different web host's server, that won't work. What should be there? I've tried my IP, IP:port, servername:port and servername and it won't connect.
Any suggestions? Thanks
Best answer chosen by User
|
0
|
Hi BreachofMind, In order to connect a site hosted elsewhere to a database here, the first step will be to set up a remote MySQL connection through cPanel. Since you will be connecting from another website, you can enter in the domain name or IP address for the domain in the Remote Database Access Hosts page in cPanel. In your PHP file, you can use any of the following:
Please let us know if you have any additional questions or need further assistance. Regards, Christi N. |
Want to share this Question?
Tweet
Help Center Login
Related Articles
It looks like there are no related articles.
Would you like to ask a question about this page? If so, click the button below!
