, 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
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 driverif you're using 4.1, there is a
different
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.
and for me the JDBC connector works for verifying
it is to dispense wisdom and
abuse at the same time.
From: Bryan Stevenson [EMAIL PROTECTED]
Sent: Tuesday, August 30, 2005 12:51 PM
To: CF-Talk cf-talk@houseoffusion.com
Subject: Re: SOLVED Re: MySQL - CF: Access Denied when using password
Yup, I posted
Thankfully this project will end up on MS SQL Server ;-)
hopefully not!!!
while ms sql server (and as crystal tech likes to call it mysql server
2000, great job of training them techs ct!!! very knowledgable) is a
decent product, some of us and our clients choose to use better platforms
it is to dispense wisdom and
abuse at the same time.
From: Bryan Stevenson [EMAIL PROTECTED]
Sent: Tuesday, August 30, 2005 1:22 PM
To: CF-Talk cf-talk@houseoffusion.com
Subject: Re: SOLVED Re: MySQL - CF: Access Denied when using password
Thankfully this project
LOL...never shoulda named ya the Disruptor...
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
LOL...never shoulda named ya the Disruptor...
yeah but ya did and now i have an image to uphold and even you as the creator
are not a immune!
~Dave the disruptor~
Some people just don't appreciate how difficult it is to dispense wisdom and
abuse at the same time.
LOL...never shoulda named ya the Disruptor...
I believe it's really the disruptured Bryan.
:)
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours
-talk@houseoffusion.com
Subject: Re: SOLVED Re: MySQL - CF: Access Denied when using password
LOL...never shoulda named ya the Disruptor...
I believe it's really the disruptured Bryan.
:)
~|
Logware (www.logware.us): a new
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
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 driverif you're
I experienced the same kind of problem a long time ago when I was using MySQL.
Ran into it with SQL server I think too.
Don't ask me why, but I believe what I did that worked was to go straight thru
my Windows Control panel to setup the datasource.
Control Panel Administrative Tools Data
Hi Josh,
I just got through going through this myself. There is a tech note
regarding this issue (courtesy of the House of Fusion blog). Once I
followed the instructions it appears to be working fine for me. I am
using CFMX7, but the tech note is for MX, so it should work.
Sorry, meant Fusion Authority blog.
--
v/r,
Jeff Fleitz
~|
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
The password algorithm was changed in MySQL 4.1. That is why you are having
problems. Go here:
http://dev.mysql.com/doc/mysql/en/old-client.html
or here:
http://rucus.ru.ac.za/docs/mysql/Old-client.html
and you will find your solution.
HTH
Mike
@houseoffusion.com
Sent: Sunday, August 28, 2005 7:05 AM
Subject: Re: MySQL - CF: Access Denied when using password
Sorry, meant Fusion Authority blog.
--
v/r,
Jeff Fleitz
~|
Logware (www.logware.us): a new and convenient web-based
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
[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
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
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
For Yes and No I use and ENUM field and specify 'Yes','No' as the acceptable
choices.
Luis
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 15, 2002 6:40 PM
To: CF-Talk
Subject: mySQL CF
Hi, all.
I'm learning to use mySQL with CF instead of
: RE: mySQL CF
Rick,
I noticed you mention that you use CFINSERT. From your earlier postings I
know you are on CF 4.5x, as I am.
You're likely to discover that CFINSERT and/or CFUPDATE sometimes blow
sky-high on CF 4.5x (at least) when working with mySQL (3.23 for sure, and
maybe 4.0x
Thanks for the tip, Luis...I'll read up on ENUM.
Rick
-Original Message-
From: Luis Lebron [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 16, 2002 9:26 AM
To: CF-Talk
Subject: RE: mySQL CF
For Yes and No I use and ENUM field and specify 'Yes','No' as the acceptable
choices.
Luis
: http://www.epilepsyfoundation.org
email: [EMAIL PROTECTED]
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 16, 2002 11:02 AM
To: CF-Talk
Subject: RE: mySQL CF
Hi, Matt.
I, too, learned about the CFUPDATE problem from personal experience
and from
secure.
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]]
Sent: 16 December 2002 16:02
To: CF-Talk
Subject: RE: mySQL CF
Hi, Matt.
I, too, learned about the CFUPDATE problem from personal experience
and from the Allaire forums when I first started using CF (with Access
11:08 AM
To: CF-Talk
Subject: RE: mySQL CF
For mysql -- or any sql, really -- you code it as follows:
cfquery name=yourName datasource=yourDataSource
INSERT INTO yourTable (field1, field2) VALUES ('value1', 'value2')
/cfquery
With mysql, you need to watch out for illegal characters. That means
11:10 AM
To: CF-Talk
Subject: RE: mySQL CF
Standard SQL inserts will work fine on most if not all RDBMS's
Eg.
insert into tablename
(int_col1,varchar_col2)
values
(cfqueryparam cfsqltype=CF_SQL_INTEGER
value=#form.val1#,cfqueryparam cfsqltype=CF_SQL_VARCHAR
value=#form.val2#)
Do try to use
16, 2002 11:10 AM
To: CF-Talk
Subject: RE: mySQL CF
Standard SQL inserts will work fine on most if not all RDBMS's
Eg.
insert into tablename
(int_col1,varchar_col2)
values
(cfqueryparam cfsqltype=CF_SQL_INTEGER
value=#form.val1#,cfqueryparam cfsqltype=CF_SQL_VARCHAR
value=#form.val2#)
Do try
and other things manually,
which is quite handy too.
Trust me, cfqueryparam is your friend ;-)
Craig.
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]]
Sent: 16 December 2002 16:51
To: CF-Talk
Subject: RE: mySQL CF
Hi, Craig, and thanks for the reply.
When you say they make
Thanks, Cary!
Rick
-Original Message-
From: Cary Gordon [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 16, 2002 12:07 PM
To: CF-Talk
Subject: RE: mySQL CF
CFQueryParam gives you an easy way to validate the query params. Some
clever, bored hackers have figured out how to do things
Thanks, Craig!
Rick
-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 16, 2002 12:05 PM
To: CF-Talk
Subject: RE: mySQL CF
cfqueryparam will escape potentially dangerous characters for you. This
is ESSENTIAL if you don't want to have your database
Cary Gordon wrote:
CFQueryParam gives you an easy way to validate the query params. Some
clever, bored hackers have figured out how to do things like pass a drop
table query through the header. It is an even easier exploit if you are
passing query parameters through the url string.
a
and other things manually,
which is quite handy too.
Trust me, cfqueryparam is your friend ;-)
Craig.
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]]
Sent: 16 December 2002 16:51
To: CF-Talk
Subject: RE: mySQL CF
Hi, Craig, and thanks for the reply.
When you say
Thanks for the insights, Mark!
Rick
-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 16, 2002 12:53 PM
To: CF-Talk
Subject: RE: mySQL CF
While it's true that CFQUERYPARAM escapes characters, there's a bit more
going on under the covers
saving overhead. On a busy server this can cause an increase in
performance that is exponential. At least that's been my experience.
-Mark
-Original Message-
From: Craig Dudley [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 16, 2002 11:05 AM
To: CF-Talk
Subject: RE: mySQL CF
hehe... maybe - can you post some of your code? How are your catalogs built
and how often?
-Mark
-Original Message-
From: paul smith [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 16, 2002 8:10 PM
To: CF-Talk
Subject: RE: mySQL CF
Thanks!
CFQUERYPARAM enabled me to reduce
Subject: RE: mySQL CF
Thanks!
CFQUERYPARAM enabled me to reduce that pesky overhead using client vars in
a database to maintain state from 32ms to 16ms.
Anything up your sleeve to reduce my SQL7 1,000ms-2,000ms full-text
searches by 50% ?
best, paul
At 11:52 AM 12/16/02 -0600, you wrote
Rick,
You should put in a zero in my opinion. 1 = true and 0 = false. Using
tinyint in this way is fairly common on most DB platforms.
-Mark
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 15, 2002 6:40 PM
To: CF-Talk
Subject: mySQL CF
Hi,
Thanks, Mark.
I guess the zerofill option is there to prevent a null, if desired?
Rick
-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 15, 2002 8:37 PM
To: CF-Talk
Subject: RE: mySQL CF
Rick,
You should put in a zero in my opinion. 1
That's the way I do it.
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 15, 2002 8:15 PM
To: CF-Talk
Subject: RE: mySQL CF
Thanks, Mark.
I guess the zerofill option is there to prevent a null, if desired?
Rick
-Original Message
Rick,
I noticed you mention that you use CFINSERT. From your earlier postings I know you
are on CF 4.5x, as I am.
You're likely to discover that CFINSERT and/or CFUPDATE sometimes blow sky-high on CF
4.5x (at least) when working with mySQL (3.23 for sure, and maybe 4.0x). In threads
on the
\ is an escape character .. .Matt Robertson gave me a good tip .. use
cfqueryparam for your insert and let CF escape all the correct characters.
Hope this helps.
Paul Giesenhagen
QuillDesign
- Original Message -
From: FlashGuy [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent:
I see...OK...trying the cfqueryparam now. Getting ? inserted into my database. Must
be wrong syntax.
I'll keep trying.
On Thu, 31 Oct 2002 11:53:38 -0600, Paul Giesenhagen wrote:
\ is an escape character .. .Matt Robertson gave me a good tip .. use
cfqueryparam for your insert and let CF
well \ is a C type escape character. So like a new line is \n or backspace
is \b if you double the \ that is the escape character for \
so D:\\data\\book1 should do it.
-Original Message-
From: FlashGuy [mailto:flashmx;rogers.com]
Sent: Thursday, October 31, 2002 9:47 AM
To: CF-Talk
Cheers,
--Matt Robertson--
MSB Designs, Inc.
http://mysecretbase.com
-Original Message-
From: FlashGuy [mailto:flashmx;rogers.com]
Sent: Thursday, October 31, 2002 10:01 AM
To: CF-Talk
Subject: Re: MySQL CF
I see...OK...trying the cfqueryparam now. Getting ? inserted into my
database
AM
To: CF-Talk
Subject: Re: MySQL CF
I see...OK...trying the cfqueryparam now. Getting ? inserted into my
database. Must be wrong syntax.
I'll keep trying.
On Thu, 31 Oct 2002 11:53:38 -0600, Paul Giesenhagen wrote:
\ is an escape character .. .Matt Robertson gave me a good tip
Just remember MySQL does not support cftransaction and subselects. You
have to use inner joins.
-Original Message-
From: W Luke [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 3:47 PM
To: CF-Talk
Subject:MySql CF?
Hi,
I've been asked to do some modifications
yes it will
"W Luke" [EMAIL PROTECTED] wrote:
Hi,
I've been asked to do some modifications for a site which is using MySql as
it's Database, and running CF for Linux. I, locally, am running CF for
Windows and have always used Access - can anyone tell me whether my Windows
CF will be able to
At 15:46 2/6/01 -, you wrote:
Hi,
I've been asked to do some modifications for a site which is using MySql as
it's Database, and running CF for Linux. I, locally, am running CF for
Windows and have always used Access - can anyone tell me whether my Windows
CF will be able to connect to the
yes, just download the mysql odbc drivers from www.mysql.com (myodbc)
-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 10:47 AM
To: CF-Talk
Subject: MySql CF?
Hi,
I've been asked to do some modifications for a site which is using MySql as
yes. you need MyODBC.
"Mark Davies" [EMAIL PROTECTED] wrote:
I'm trying to use mySQL instead of MSAcccess on my W2K laptop for CF
development. Is this possible? I've got everything up and running, but I
can't seem to define the datasource in the CF app server. Is it possible?
Any help much
, inc.
895 E. 13th Ave
Eugene, OR 97401
(541) 346-4331
http://www.uobookstore.com
-Original Message-
From: Mark Davies [mailto:[EMAIL PROTECTED]]
Sent: Sunday, August 13, 2000 8:58 PM
To: [EMAIL PROTECTED]
Subject: RE: [mySQL,cf,W2K: possible?]
thanks, I've got myodbc installed but can you
Anyone using CF and mySQL and accessing BLOB data? I converted an Access2K
db to Mysql and all memo fields were converted to BLOB datatypes. Now when
I
pull the information and display it I get ASCII garbage and not the text.
Someone in mySQL support told me to change it to a longvarchar
54 matches
Mail list logo