I have CFMX7, MySQL 5.0 and NaviCat all running locally -----Original Message----- From: ColdFusion [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 9:33 PM To: CF-Talk Subject: RE: MySQL 5 and CFMX7 (New Problem)
Localhost is where the MySQL Database is at. It is all one machine -----Original Message----- From: David Livingston [mailto:[EMAIL PROTECTED] Sent: Friday, February 03, 2006 7:49 PM To: CF-Talk Subject: Re: MySQL 5 and CFMX7 (New Problem) In your users table do have your machine or sub-net entered to accept a connection from your machine/user that is having trouble connecting? Is MySQL installed on the same machine as CF? If not then jdbc:mysql://localhost:3306/myTest wouldn't do the trick. You would need to use the mysql boxes ip instead of local host. Sorry if I'm stating the obvious and not helping. The error basically says it cant connect to the port. Which doesn't sound like a CF issue but a network issue. Is the machine that you are using Navicat to connect with also the machine you have CF installed on? The only other thing I would suggest is check the cf and mysql logs to see if the provide any lower lever details/clues. Dave On Feb 3, 2006, at 6:26 PM, ColdFusion wrote: > Yes, it is displayed under System Information in CF Admin > > -----Original Message----- > From: David Livingston [mailto:[EMAIL PROTECTED] > Sent: Friday, February 03, 2006 7:07 PM > To: CF-Talk > Subject: Re: MySQL 5 and CFMX7 (New Problem) > > Did you add \ wwwroot \ web-inf\ lib into your java coldfusion class > path? > You have to restart CF after you add it so that the jdbc driver gets > loaded in. > > Here is a link to how to install the postgress driver. The mysql setup > should be similar. > http://cfguru.daemon.com.au/archives/000082.html > > Dave > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231335 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
