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
