Download and install this patch which will allow you to get a more specific error message from the CFAdmin:
Diagnostic JAR file for data source connection issues http://www.macromedia.com/support/coldfusion/ts/documents/tn18355.htm 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. BTW, note that CFMX is not yet supported on Red Hat 8. -----Original Message----- From: DuSTiN KRySaK [mailto:[EMAIL PROTECTED] Sent: Friday, March 14, 2003 3:41 PM To: CF-Linux Subject: MySQL datasource in CF admin error Hi there.... CFMX RedHat 8 MYSQL Ok, I created my user in mysql, and I am able to logon through mysql, etc to create databases, and tables, etc. Now when I try to create the data source in the CF admin I get this error: � * Connection verification failed for data source: addy []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. The MySQL server and CF are on the same box, so I am filling it out as the following: MySQL Data Source : �addy � CF Data Source Name addy �� � Database �� addressbook � Server �� localhost � Port 3306 � � Username myuserid Password myidpassword Now do I need to have my user id with: [EMAIL PROTECTED] Or myuserid@'%'? Now when I created the user in mysql I used this command: MySQL> GRANT SELECT, INSERT, UPDATE, DELETE, -> CREATE, DROP, ALTER, INDEX, FILE ON ->databasename.* TO [EMAIL PROTECTED] ->IDENTIFIED BY 'password'; Now I made sure that myODBC (V2.5) was installed too.... So I am not sure what else to try - I have been reading the MM site and searching all day - ideas? This is driving me INSANE!!!! ;-) 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.14
