Can't create data source for MySQL
Posted by: Tanya Crawford
Date: December 26, 2021 01:39AM

I have installed MySQL 8. I have installed Connector/J.
I have a Windows Server 2019 running with Cold Fusion 10.
In the CF Administrator I try to create a new data source.
I have set up the schema in MySQL and have even got some table populated.
Now I want to start writing CF code.

I am getting a multitude of errors. I've tried MySQL (Datadirect) and MySQL 5.
The directory browsing is not working in CF Admin so I put in the full path to the database folder: C:\ProgramData\MySQL 8.0\Data\Refadmin.
I supply the IP address of the server, and port 3306
I supply the user name and password.

I get an error "cannot connect. tried 3 times. Giving up"

Other times it will say "Unknown database" or "Connection timed out" Or access denied for user@server using password: yes".

Can someone please offer the correct settings for a MYSQL data source.

thanks

Options: ReplyQuote


Subject
Written By
Posted
Can't create data source for MySQL
December 26, 2021 01:39AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.