MySQL Connection Failure

[Anonymous]

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!

[Anonymous]

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

[janhess]

It's a permissions problem.

[Anonymous]

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

[Anonymous]

Hi
Thanks for your feedback.
Regards,
Pedro

[_AnonymousUser]

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.

[Anonymous]

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

[Anonymous]

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.

[_AnonymousUser]

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.

[janhess]

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