uh oh.... now you've done it. Prepare for a wall of fire.... -----Original Message----- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Monday, August 29, 2005 12:37 PM To: CF-Talk Subject: Re: MySQL - CF: Access Denied when using password
CF 7 comes with a MySQL 3.1 driver....if you're using 4.1, there is a different authentication mechanism so username/passwords don't fly....just use without the user/pass. You can also dload the newer JDBC driver for 4.x and up at mysql.org or .com or wherever the home of that miserable excuse for a database is (no I'm not jaded at all...hehe) ;-) HTH Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ----- Original Message ----- From: "Josh Nathanson" <[EMAIL PROTECTED]> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Saturday, August 27, 2005 2:22 PM Subject: Re: MySQL - CF: Access Denied when using password > Thanks Dave, but I have set up a dummy user locally with the same username > and password as that of the live application, so I don't think that is the > issue... > > It works absolutely great as long as I don't try to use a password. For > some reason that is what's throwing it off. > > I have a bunch of apps running remotely on CF/MySQL, and I am trying to > move > from MS Access to MySQL locally, so I'd like to be able to do that without > rewriting all the code, or dealing with the commenting workaround you > suggested. > > Is there some rule against a localhost user other than root connecting to > MySQL? > > I am no expert so I might be missing something really obvious, but this > also > stumped my trusty web host who is something of a CF guru. I emailed him > my > MySQL user and db tables and he couldn't find anything wrong that would be > causing the error. > > > > > > > ----- Original Message ----- > From: "dave" <[EMAIL PROTECTED]> > To: "CF-Talk" <cf-talk@houseoffusion.com> > Sent: Saturday, August 27, 2005 1:07 PM > Subject: re: MySQL - CF: Access Denied when using password > > >> that would be because your local MySQL install doesnt have the same pw's >> as your live one therefor you are trying to give it a username and >> password it doesn't have and getting the warning. >> >> Not sure how others do it but in my Application.cfm or cfc (shut it will) >> I set 2 sets of connection variable, 1 live and 1 local and just comment >> out the one i dont need at the time. >> >> like >> <!--- comment out cause we are in local setting >> <!--- set live connection ---> >> <cfset application.dsn = "myconnection"> >> <cfset username = "jack"> >> <cfset password = "smack"> >> ---> >> >> <!--- set local connection --> >> <cfset application.dsn = "myconnection"> >> <cfset username = ""> >> <cfset password = ""> >> >> ~Dave the disruptor~ >> "Some people just don't appreciate how difficult it is to dispense wisdom >> and abuse at the same time." >> >> ---------------------------------------- >> From: "Josh Nathanson" <[EMAIL PROTECTED]> >> Sent: Saturday, August 27, 2005 1:49 PM >> To: CF-Talk <cf-talk@houseoffusion.com> >> Subject: MySQL - CF: Access Denied when using password >> >> Hello all, >> >> I have set up MySQL on my local box, everything works fine until I try to >> use a password when creating a datasource in CF Administrator. I get the >> "1045 Access Denied" error. I am able to create the datasource fine if I >> don't use a password, so I know the issue is not caused by incorrect >> privileges in the mysql.user or mysql.db tables. Also if I do set up the >> datasource without a password, and try to use a password in a cfquery, I >> get the same error. >> >> My platform: Windows XP SP2/CFMX 6.1/MySQL 4.1 >> >> Thanks for any assistance! >> >> >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216671 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