You won't need myODBC, because CFMX uses the JDBC drivers directly, unlike previous versions of CF.
I usually GRANT my users with both [EMAIL PROTECTED] and user@'%'. I had issues similar to this a while back, and specifying both seemed to resolve them. I'd try that. You also might try FLUSH PRIVILEGES from the mySQL client, although that shouldn't be needed because you're using GRANT, rather than directly editing the tables in the mysql database. barneyb > -----Original Message----- > From: DuSTiN KRySaK [mailto:[EMAIL PROTECTED] > Sent: Friday, March 14, 2003 12: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
