These are idiotic questions, but i've been bit by such things: did you spell the database name correctly in both the GRANT statement for you user? did you give the user appropriate permissions? did you spell the username and password correct?
if you can connect with security turned off, then it has to be something with your security data. > -----Original Message----- > From: DuSTiN KRySaK [mailto:[EMAIL PROTECTED] > Sent: Friday, March 14, 2003 3:47 PM > To: CF-Linux > Subject: Re: MySQL datasource in CF admin error > > > On 3/14/03 12:52 PM, "Steven Erat" <[EMAIL PROTECTED]> spit > this out onto > my computer screen: > > > As a test for basic connectivity while ignoring user security, > you can start > > mysql with a flag to not check security: > > > > cd /usr/local/mysql/bin > > ./safe_mysqld --skip-grant-tables & > > > > This is a security hole, so do that at your own risk. > Ok - when starting MySQL this way, I am able to connect to the database no > problem. So now - (being new to mysql) I assume I have an issue > with the way > I configured it. I have been hitting mysql lists at the same > time, and they > are not quite as helpful. > > Do you have any suggestions as to what the issue could be? > > Dustin > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=14 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=14 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.14
