Remote MySQL Connections

[user-7256]

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]

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.

 

[user-7256]

Hm, okay, thanks!

 

[Kate]

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]

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.

 

[user-7256]

Ah okay... thanks!