Unable to connect to Mysql from mysql workbench

You can only connect through a ssh tunnel using the public key that you create in Forge (Server Details/SSH Keys). You also have to do that in order to ssh into the box, so you may already have one set up.

I don't use workbench, but here's what I have to do with Navicat and Sequel Pro:

General Settings:
Hostname/IP: localhost (sequel pro required Forge server IP, navicat required localhost)
Port: 3306
username: forge
password: forge-password

SSH Settings:
Use SSH Tunnel: (check)
Hostname/IP: forge ip
port: 22
username: forge
authentication method: public key
private key: /path/to/key/on/your/computer/keyName_rsa
passphrase: your keys passphrase

Edit: here's an older video showing this. The interface has changed a bit since this was recorded, but the essence is the same: https://laracasts.com/series/server-management-with-forge/episodes/4

@CRONIX -

I JUST INSTALLED TOMCAT 14 DAY TRIAL VERSION

use SSH tunnel: checked

Host: localhost

Port: 3306

User Name: forge

Authentication method: public Key

Private Key: C:\Users\SUCCESS.ssh\id_rsa

passphrase: *********** i provided the passphrase i used to generate the key from bit bash

Save Passphrase: checked

Those are the configuration settings I have used but still not working..

Server unexpectedly closed network connection

and when I change the host to the server IP address, it loads for a while then say Network: Connection timed out

are you able to ping host/ip address and also able to telnet the ip address and port?

@CRONIX - Thanks alot.. I actually got to make it work.... funny enough that I wasnt patient enough to thoroughly go through the settings you sent me and I was missing the General Settings tab section. I keep using General setting for SSH settings and this has cost me a week and 3 days... Thanks anyway