I am trying to register my database with coldFusion. The coldFusion
admin page throws one of the two following errors depending on how I
define the address of the server.
1. If I define the server with parenthesis ie; (localhost) as
recommended in the CF admin guide. I receive this error:
Connection verification failed for data source: test_2_DB
[]java.sql.SQLException: Cannot connect to MySQL server on
(localhost):3306. Is there a MySQL server running on the machine/port
you are trying to connect to? (java.net.UnknownHostException)
The root cause was that: java.sql.SQLException: Cannot connect to
MySQL server on (localhost):3306. Is there a MySQL server running on
the machine/port you are trying to connect to?
(java.net.UnknownHostException)
2. If I define the server without parenthesis ie; localhost as
recommended in most of the CF books I have. I receive this error:
Connection verification failed for data source: test_DB
[]java.sql.SQLException: Server configuration denies access to data
source
The root cause was that: java.sql.SQLException: Server configuration
denies access to data source
What is causing this error? MySQL is running on port 3306. The
database exists and the user has been given correct privileges.
I can log into MySQL via SSH with no problems.
I have seen a similar posting on the House of Fusion list. However the
solution was not in the thread...
Any ideas?
Best,
J-C
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38
Message: http://www.houseoffusion.com/lists.cfm/link=i:15:445
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
