connect mysql workbench to server

Question

i try to connect my sql workbench to database on server withe konw the username,password and ip adress that have the acseesa to the server but is not work.

it give me this error

ERROR 2003 (HY000): Can't connect to MySQL server on '$$$$$$$$:3306' (10060)

Answer 1

According to the documentation, 10060 errors are a time-out error, which means the server failed to respond to your connection request within the established time period.

This has several potential sources

1. you have the wrong IP address or port number
2. the server is offline or not accepting any new connections
3. you do not have permissions to access the server / the machine you attempting to connect from is either blocked (blacklisted) or not on the approved list (not whitelisted)
4. a firewall somewhere in the chain between your copy of Workbench and the server is blocking your connection (your computer, the server, a middleware layer, the DMZ layer at work, etc.)

Troubleshooting:

1. confirm the server (both the computer and the database software) are online
2. confirm the port you are trying to connect to
3. confirm that your username and password have rights to remotely log in
4. temporarily disable firewalls or make a tunnel through them on the machine were Workbench is running