i dunno if there is a better work around, i have never really bothered to look, the way i do it takes about 17.4 seconds to do so it's easy enough. Seems as tho there was someting about a local mysql system that just didnt let you use it but it sure looks like thats your fix and as long as you set it in the Application scope its there and only needs changed on one page.
Technically, you can do quite a few things with this like in the application.cfm or CFC you can do some logic, like determine if its being called from localhost or from the live server and have it feed it the correct settings. ~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 5:24 PM To: CF-Talk <cf-talk@houseoffusion.com> 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" To: "CF-Talk" 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 > > > > > ---> > > > > > > > ~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" > Sent: Saturday, August 27, 2005 1:49 PM > To: CF-Talk > 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! > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216601 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