Derrick, Thanks for the reply. The crazy thing is that I have my test account set up to allow access to *.* from '%'. Like I said, it works fine from the command line but throws that error when trying to connect through CF admin.
Thanks, Dennis -----Original Message----- From: Derrick Shoemake [mailto:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 4:24 PM To: CF-Linux Subject: Re: CF MX/RH 7.3/MySQL Dennis, It probably is a permissions problem, create a new user using the grant command a test would be the following: grant all privileges on testdb.* to testuser@'%' identified by 'testpassword'; You would of coarse want to revoke that after the test.... then apply the proper host where the '%' was. The mysql reference to this is http://www.mysql.com/doc/G/R/GRANT.html On Fri, 2002-07-12 at 14:17, dennis baldwin wrote: > Is anyone running Red Hat 7.3 with CF MX and MySQL? I keep getting the > following error when creating a DSN: > > "Connection verification failed for data source: testing > []java.sql.SQLException: SQLException occurred in JDBCPool while attempting > to connect, please check your username, password, URL, and other > connectivity info. > The root cause was that: java.sql.SQLException: SQLException occurred in > JDBCPool while attempting to connect, please check your username, password, > URL, and other connectivity info." > > I've verified that it isn't a permissions issue because I'm able to connect > via the MySQL command line tool. A friend of mine is running CF MX with > MySQL on 7.2 with no problems. I'd greatly appreciate any feedback or > suggestions you may have. > > Thanks, > Dennis > > ps. this didn't help much > http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=10&threadid > =357509&highlight_key=y&keyword1=mysql > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
