Toad not connecting to mysql remote server

I am using Toad on my windows machine to connect to mysql on the remote ubuntu linux server. And it is not connecting it. It says "Can't connect to SSH server on '': No connection could be made because the target machine actively refused i开发者_运维知识库t 22." I guess 22 is the ssh port and I provided the default mysql db server port i.e. 3306. I don't know what's happening

---

After 20 hrs of trying, finally got the solution for this. First added the port 3306 and ip of my db server to the firewall settings of my antivirus. Then edited the /etc/mysql/my.cnf file and then added remote user in the database's user table. The link below explains a lot what I did.

http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html

It helped me. Although the settings at my server is different from this. This might help you all.

---

Set connection properties as follows:

Don't forget to check "Use MySQL libraries"

Tested on my environment:

• Ubuntu server 14:04 (@ ip 10.0.0.4)
• openssh server is installed
• Port 3306 is open (netstat -ntlp | grep LISTEN)
• MySql 5.5
• Client: Windows 7, 64 bit
• TOAD 7.7