Remote MySQL Connections

mholt · 12-17-2005, 01: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, 05: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, 05:59 PM

Hm, okay, thanks!

sdsinc · 12-18-2005, 01: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, 06: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, 04:32 PM

Ah okay... thanks!

12-17-2005, 01:35 PM	#1 (permalink)
mholt DNOA Member Join Date: May 2004 Location: Utah Posts: 5,041 18.01 NP$ (Donate)	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 __________________ codeboards A high-quality community of programmers -- Join today and post! We want new members!

12-17-2005, 05:59 PM	#3 (permalink)
mholt DNOA Member Join Date: May 2004 Location: Utah Posts: 5,041 18.01 NP$ (Donate)	Hm, okay, thanks! __________________ codeboards A high-quality community of programmers -- Join today and post! We want new members!

12-18-2005, 01:44 AM	#4 (permalink)
sdsinc Domains my Dominion Join Date: Aug 2005 Location: Web 1.0 Posts: 6,285 1,095.94 NP$ (Donate)	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 __________________ Buy now - MassDeveloper.com $500

12-18-2005, 04:32 PM	#6 (permalink)
mholt DNOA Member Join Date: May 2004 Location: Utah Posts: 5,041 18.01 NP$ (Donate)	Ah okay... thanks! __________________ codeboards A high-quality community of programmers -- Join today and post! We want new members!

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 01:24 PM
Great Scripts for Sale With Resale Rights!	Zeeble	Scripts For Sale	20	01-04-2006 01:39 AM
Tutorial: How to Install Apache2 MySQL and PHP on Windows	deadserious	Webmaster Tutorials	35	09-21-2005 09:46 PM
HOW TO: Use shell to control MySQL.	abdulmueid	Webmaster Tutorials	16	08-27-2005 08:17 AM
Tutorial: Getting Started With MySQL (The Basics)	deadserious	Webmaster Tutorials	3	04-18-2004 01:17 PM

12-17-2005, 05:26 PM	#2 (permalink)
mch NamePros Regular Join Date: Nov 2005 Location: EU Posts: 248 99.25 NP$ (Donate)	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-18-2005, 06:19 AM	#5 (permalink)
Peter Senior Member Join Date: Nov 2003 Location: Scotland Posts: 4,900 0.60 NP$ (Donate)	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.

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