Problem adding new connection for datasource

Hi,
I am not SQL guy, but I am trying to add new conection in datasource. But always fail. I have a couple of screen shots attached. Please help out.

Thanks,
Richard




Well, you’re getting a Connection Refused error trying to connect to that mysql datasource at localhost:6666. Maybe its not there or not listening on that port?

I would also add that it looks like your IADemo data connection is working… and that’s going against MySQL on port 3306. I think it’s very unlikely that you’d have a separate mysql instance running on a different port… why don’t you try changing the connection string to:

jdbc:mysql://localhost:3306/Energy

and see if that works.

Regards,