Yup, I posted this originally and got the problem solved by downloading the jdbc "connector/j" from mysql.org - I had to use connector version 3.0 though, maybe because I am on CFMX6.1 -- the 3.1 version (recommended) didn't work for me.
----- Original Message ----- From: "John Paul Ashenfelter" <[EMAIL PROTECTED]> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Tuesday, August 30, 2005 6:56 AM Subject: Re: MySQL - CF: Access Denied when using password > 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" <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:216783 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