> 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
Try turning on mysql logging in /etc/my.cnf and see what is happening. [mysqld] log=/var/log/mysql-messages Pretty sure you need to touch the mysql-messages file first and chown it to the mysql uid. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=14 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=14 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.14
