In order to connect remotely, you have to have MySQL bind port 3306 to your machine’s IP address in my.cnf. Then you have to have created the user in both localhost and ‘%’ wildcard and grant permissions on all DB’s as such . See below: my.cnf (my.ini on windows) #Replace xxx with your IP Address … Read more
Here is what I do to avoid the issues of making the remote server accept your local external IP: when I ssh into the machine, I use the option -L to transfer the port 6006 of the remote server into the port 16006 of my machine (for instance): ssh -L 16006:127.0.0.1:6006 olivier@my_server_ip What it does … Read more
Run ssh-add on the client machine, that will add the SSH key to the agent. Confirm with ssh-add -l (again on the client) that it was indeed added.