Remote MySQL Connections

mholt · 12-17-2005, 02:35 PM

Hi,

I have set an access host in Cpanel so that a remote server can access my MySQL database.

1) What port do I need?

2) What should my PHP connection script look like?

Thanks,
-Matt

mch · 12-17-2005, 06:26 PM

The default port is 3306 according to Google. The script is the same as always, just put the server's name instead of localhost in mysql_connect.

mholt · 12-17-2005, 06:59 PM

Hm, okay, thanks!

sdsinc · 12-18-2005, 02:44 AM

Also bear in mind that the user must have permission to connect from the remote host (name / IP) or any host (*), often users are restricted to localhost

Peter · 12-18-2005, 07:19 AM

when connecting to a remote mysql host if no port is specified then the default port is assumed so as long as the remote host has not changed the port then you have no need to add it to your script.

And as stated the only difference in your script will be the host, instead of using localhost you will use the ip or host name for the new host.

mholt · 12-18-2005, 05:32 PM

Ah okay... thanks!

12-17-2005, 02:35 PM	THREAD STARTER #1 (permalink)
mholt DNOA Member Join Date: May 2004 Posts: 5,040	Remote MySQL Connections Hi, I have set an access host in Cpanel so that a remote server can access my MySQL database. 1) What port do I need? 2) What should my PHP connection script look like? Thanks, -Matt

12-18-2005, 02:44 AM	#4 (permalink)
sdsinc Domains my Dominion Join Date: Aug 2005 Location: Web 1.0 Posts: 9,552	Also bear in mind that the user must have permission to connect from the remote host (name / IP) or any host (*), often users are restricted to localhost __________________ NameNewsletter.com - free lists of available domain names ZoneFiles.net (beta) - ccTLD and gTLD droplists

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
HOWTO: Install the Apache Web Server, Perl, PHP, and MySQL on Windows	deadserious	Webmaster Tutorials	96	05-27-2007 02:24 PM
Great Scripts for Sale With Resale Rights!	Zeeble	Scripts For Sale	20	01-04-2006 02:39 AM
Tutorial: How to Install Apache2 MySQL and PHP on Windows	deadserious	Webmaster Tutorials	35	09-21-2005 10:46 PM
HOW TO: Use shell to control MySQL.	abdulmueid	Webmaster Tutorials	16	08-27-2005 09:17 AM
Tutorial: Getting Started With MySQL (The Basics)	deadserious	Webmaster Tutorials	3	04-18-2004 02:17 PM

12-17-2005, 06:26 PM	#2 (permalink)
mch NamePros Regular Join Date: Nov 2005 Location: EU Posts: 248	The default port is 3306 according to Google. The script is the same as always, just put the server's name instead of localhost in mysql_connect.

12-17-2005, 06:59 PM	THREAD STARTER #3 (permalink)
mholt DNOA Member Join Date: May 2004 Posts: 5,040	Hm, okay, thanks!

12-18-2005, 07:19 AM	#5 (permalink)
Peter NamePros Expert Join Date: Nov 2003 Location: Scotland Posts: 5,069	when connecting to a remote mysql host if no port is specified then the default port is assumed so as long as the remote host has not changed the port then you have no need to add it to your script. And as stated the only difference in your script will be the host, instead of using localhost you will use the ip or host name for the new host.

12-18-2005, 05:32 PM	THREAD STARTER #6 (permalink)
mholt DNOA Member Join Date: May 2004 Posts: 5,040	Ah okay... thanks!

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)