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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288873 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
