Hi Rick, This definitely seems to be a SandBox security restriction for the Datasource access. Make sure that you have enough access for the required resources.
Thanks Jayesh Viradiya Adobe CF Team -----Original Message----- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Thursday, September 20, 2007 4:08 AM To: CF-Talk Subject: RE: CF8: Why would I be getting an access error with this query? Yes, that's my thinking, too, Andy. But for some reason, when I try to use the "Manage Users" function in Navicat on the MySQL 5 server at CrystalTech, I get the error, "1044-Access denied for user 'xxxxxxxx'@'%' to database 'mysql'. And the xxx's in my line above are my correct username... Like I mentioned to Williams, the reference to a database 'mysql' must be to the server software, because I don't have a database named 'mysql'. Thanks, Rick -----Original Message----- From: Andy Allan [mailto:[EMAIL PROTECTED] Sent: Thursday, September 20, 2007 6:37 AM To: CF-Talk Subject: Re: CF8: Why would I be getting an access error with this query? Looks like your user hasn't been specifically "granted" the appropriate rights to your database. Andy On 20/09/2007, Rick Faircloth <[EMAIL PROTECTED]> wrote: > This is on a remote shared server, so I only have access > through an access panel. I can log into everything there without problem. > > However, when I try to use "Manage Users" in Navicat to check my > permissions, > I get this error: "1044 - Access denied for user 'XXXXXXXX'@'%' to database > 'mysql'. > > I'm not sure why it reference "database 'mysql'... unless it's referencing > the > mysql server. That's not the name of the database I'm accessing. > > Ideas? > > Rick > > > > -----Original Message----- > From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 19, 2007 11:39 PM > To: CF-Talk > Subject: Re: CF8: Why would I be getting an access error with this query? > > > I'm getting an access denied error because of line 36 (middle line) in > this > > query: > > <cfquery name="get_user" datasource="#dsn#" password="#password#" > > username="#username#"> > > select * from users where user_email = > > '#trim(form.user_email)#' and user_password = '#trim(form.user_password)#' > > </cfquery> > > > > For CF 8, does anyone see anything wrong with the syntax? > > I would first try running the query manually by logging in from the > server using the username and password set in the variables. > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288997 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4