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:216599 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
