127.0.0.1 as the server in CF Admin. Just for clarification.
-----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
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.14
