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!

[_AnonymousUser]

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.

[_AnonymousUser]

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

[janhess]

Have you given the host permission?

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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.