Dustin, Have you tried using 127.0.0.1 for the server instead of localhost? We had something similar happen and I think it was resolved when we used the IP instead.
Regards, Dennis -----Original Message----- From: DuSTiN KRySaK [mailto:[EMAIL PROTECTED] Sent: Friday, March 14, 2003 2: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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.14
