Connecting to a remote database

I'd first verify that the MySQL users were created correctly and have proper permissions to access from the specific host.
Then I'd take ColdFusion out of the picture. You could try using the MySQL client on the server that has ColdFusion and try logging in.
My bet is that this is not a ColdFusion problem.

If you are administering MySQL (I'm assuming that you are using MySQL), then quite honestly you should know what port it is using. If it's a vanilla installation, then I can't imagine that it's not using port 3306. You probably have a user issue. Remember that MySQL users can be dependent on the host name. Just because you can logon from the same machine that MySQL is running on, does not mean that the same user will work from a different physical machine.

Manolob wrote:
> Ok so I am really a newbie when it comes to CF. I know how to add DSNs in the
> CF admin locally. The problem I am having is connecting to a database on a
> different server. I know I have the correct IP address, so the problem has to
> be the port. Using the default port will not work I assume, so my question is
> how would I be able to find the right port number to connect to my database?
>


A Database Administer of the remote database tells you.