I need to get a dump of database from a remote mysql server. I have the remote server ip, username and password but when I try to connect from mysql workbench it fails with error message 'cannot connect to mysql server"ip address" (10060)' I tried to ping the ip of server from cmd but it timed out. What am I missing ?Is there a way of connecting to this server? Unfortunately, all I have are these details n am not sure if my IP has access or was added or not. Also noway for me to check. Last person who connected remotely has left 1 yr. back and there is no IT staff to resolve this. I just wanted to know if there is anyway of getting the db dump from server
Your first problem is the server machine because you cannot ping it.
You can only connect to a MySQL database server if there are an actual running machine. Having not able to ping the ip address is the first obvious problem.
Should you have able to confirm that there are really a database server that is running for that ip address, only then you can try your username and password.