I am able to use the command line in accessing mysql As indicated: mysql -uSomeUser -pSomePassword -hlocalhost
(all values were substituted as needed) -----Original Message----- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] Sent: Monday, February 06, 2006 4:15 PM To: CF-Talk Subject: Re: MySQL/CFMX7 is the death of me. > And I do not see where the packet it logged for port 3306. > I did validate the port in the Control Panel for ODBC Sources And > checked in there to see if it registered at port 3306. > That was fine. > > Maybe I am not using Ethereal right or something cause I do not See > where Ethereal picked up any request to port 3306. OK -- you've mentioned ODBC more than once. The MySQL drivers don't have anything to do with ODBC -- they are pure *JDBC* drivers. I think there's a bit of confusion there. If you're trying to connect to an *O*DBC datasource through ColdFusion, you use the ODBC Socket driver. That bridges *any* ODBC datasource to JDBC. I assume you'd pretty much only use it for MS Access, FoxPro, or anything else w.o an *O*DBC driver. I don't use navicat -- so don't know if it's using ODBC or something else. Assuming you can go to a command prompt, type mysql -uSomeUser -pSomePassword -hlocalhost where SomeUser and SomePassword are the same as you're going to use for the datasource. For a default mysql install, you want -uroot and can skip the password. If this works, that's exactly the same info you use in the CFAdministrator to set up the datasource. Assuming you have put the JDBC drivers in the right place, you're fine. If the command line DOESN'T work, then you've got a configuration problem -- either with the hostname, username, password, port, etc. You should get enough info from that error to start figuring out what is wrong. -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231537 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
