Cannot establish db connection: "Connection refused"
Hello,
I'm trying to establish a connection to a mysql5 database (Metadata, right click on a db), but i always get a
"The driver has not received any packets from the server." ... "Connection refused".
My connection string is the following: jdbc:mysql://localhost:3306/mydb?noDatetimeStringSync=true (I'm using localhost as the server on my local machine, looks like it's not going to work..).
Do you have any suggestion ..? Thanks
Hi, Thank you for your answer! I don't have mysql on my machine, I haven't installed it, do I need it installed for Talend to work? Same thing when I try to use the ETL connection component for Oracle (tOracleConnection_1), it tells me that "the Network Adapter could not establish the connection".. Looks like it won't work no matter witch DB connection component I try to use.. Do you have an idea?
Ok, well I have Mamp on (with apache and mysql), so I can access localhost on a web page, so I guess it's ok..
As for the db connection, I don't know how I can test it..
Since I installed Mamp and ran it, the error is slightly different, the driver still haven't received any packets from the server, but this time it's a timout exception "Read timed out"..
Thank you in advance for your time
Hi,
I don't have any my.ini file since I don't have any mysql db.. Mamp is using mysql, but the folder mysql of Mamp doesn't have a .ini file.
Must I have a mamp running if I want to use Talend's db connection ?
Sorry I'm a little bit lost, first time using Talend and the demo project isn't working because of that..
Thanks again in advance for your time
I'm running map on the port 80, so when I try the same port number with a Talend db connection, it will wait, I think it's because the port is already used by map so it's waiting for the port to be free.
The error is the same, connection refused, can I use the default port 3306 ?
I had the same problem too, when you configure your db, login=root, pwd=root, server=localhost, port=3306, db=MySql (this one worked for me, don't ask me why^^), additional parameters: instance=Training (found that one on a forum)