Can't create data source for MySQL

[Tanya Crawford]

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