One Star

MySQL Connection Failure

Hi,
I just installed Talend on a new machine. When I am trying to create a connection to a MySQL database I am getting the error "com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server"
Any Ideas? Do I need to install a new MySQL driver? If so what folder would I store this in?
Thanks!
15 REPLIES
One Star

Re: MySQL Connection Failure

Hi
Have you checked the correct DB version?
Maybe you need to try with Mysql 5 on tMysqlConnection.
Regards,
Pedro
One Star

Re: MySQL Connection Failure

It's a permissions problem.
One Star

Re: MySQL Connection Failure

Thanks guys! I just needed to white list the IP.
One Star

Re: MySQL Connection Failure

Hi
Thanks for your feedback.
Regards,
Pedro
One Star

Re: MySQL Connection Failure

I am also getting same error "com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server"
Any Ideas? Do I need to install a new MySQL driver? If so what folder would I store this in? also i have
bind-address 127.0.0.1 i.e localhost in my.cnf.
Moderator

Re: MySQL Connection Failure

Hi yogeshballani,
The technical article http://stackoverflow.com/questions/2983248/com-mysql-jdbc-exceptions-jdbc4-communicationsexception-c... about the error("com.mysql.jdbc.exceptions.jdbc4.Communications Exception : Communications link) will point a light to you.

Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: MySQL Connection Failure

Hi yogeshballani,
I had faced same problem. I'm sharing here what I had done then.
Plz check the below things to identify the problem.
1. Check ur internet connection.
2. Check ur DB connection parameters settings in Talend job.
3.Check whether the user which u r using to run this job has the permissions from admin to access the respective DB.

Hope it is helpful to u.
Thanks,
Saty.
One Star

Re: MySQL Connection Failure

Hi yogeshballani,
I had faced same problem. I'm sharing here what I had done then.
Plz check the below things to identify the problem.
1. Check ur internet connection.
2. Check ur DB connection parameters settings in Talend job.
3.Check whether the user which u r using to run this job has the permissions from admin to access the respective DB.

Hope it is helpful to u.
Thanks,
Saty.

Hi
I have tried every thing have re-installed Talend, MySQL and also java but still not having any success as it is connecting from remote machine but not able to connect talend with my local machine having MySQL Instance. I have already commented out bind-address in my.cnf and restarted mysql instance several times but not having success.
One Star

Re: MySQL Connection Failure

It's a permissions problem. Check the access permissions in the MySQL admin.
One Star

Re: MySQL Connection Failure

Hi yogeshballani,
The technical article http://stackoverflow.com/questions/2983248/com-mysql-jdbc-exceptions-jdbc4-communicationsexception-c... about the error("com.mysql.jdbc.exceptions.jdbc4.Communications Exception : Communications link) will point a light to you.

Best regards
Sabrina

Hi
I have tried every thing have re-installed Talend, MySQL and also java but still not having any success as it is connecting from remote machine but not able to connect talend with my local machine having MySQL Instance. I have already commented out bind-address in my.cnf and restarted mysql instance several times but not having success.
One Star

Re: MySQL Connection Failure

It's a permissions problem. Check the access permissions in the MySQL admin.

Hi ,
I am accessing mysql using root user having all permission's
One Star

Re: MySQL Connection Failure

Have you given the host permission?
One Star

Re: MySQL Connection Failure

Hi All,
The Issue has Been solved as the localhost was blocked from network settings in talend in general tab.
Moderator

Re: MySQL Connection Failure

Hi,
Thanks for your feedback. Your solution provide us with another aspect about the error "com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: MySQL Connection Failure

Hi All,
The Issue has Been solved as the localhost was blocked from network settings in talend in general tab.

Thanks Yogesh.
I learnt from ur issue that this could one of the reasons for communication link failure.
Saty.