On 8/29/05, Bryan Stevenson <[EMAIL PROTECTED]> wrote: > > 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.
Actually, it's a 3.23.x series driver. And you're fine if you're using MySQL 4.1.0 -- the auth mechanism changed in 4.1.1. Running without a password is really a poor choice, especially when there are a number of more sensible options: 1) Use the oldpassword option in your my.ini or pass as a command line parameter at startup 2) Use the OLD_PASSWORD() function on the password for the user defined in the CFMX datasource, which will generate a hash that the MySQL 3.23.x driver that ships with ColdFusion understands 3) Use the MySQL 4.1.x series driver as an "Other" datasource in CFMX, which you'll *have* to do to get access to the 4.1 and 5.0 branch-specific functionality. You can also dload the newer JDBC driver for 4.x and up at mysql.org<http://mysql.org>or .com > or wherever the home of that miserable excuse for a database is (no I'm > not > jaded at all...hehe) ;-) How's this significantly different from the whole Windows vs SQL Server login difference with MS-SQL? Other than the fact that you've had to know the difference between those two types of logins for so long to get CF-MSSQL datasources to work that it's second nature by now :) 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 <http://www.electricedgesystems.com> > ----- Original Message ----- > From: "Josh Nathanson" <[EMAIL PROTECTED]> > To: "CF-Talk" <[email protected]> > 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" <[email protected]> > > 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 <[email protected]> > >> 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:216754 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
