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 > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. ------------------------------------------------------------------------------ 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.
