Toad for MySQL connection problems (Win 7 to Linux)

I have a MySQL instance running on a Linux box, and a Mac which also has Win7 (Bootcamp/VMWare)开发者_开发技巧. I can connect to the MySQL db from Navcat Lite for Mac with no problems, however, I prefer Toad. I installed Toad for MySQL for Win7 but it just CANNOT connect to the db. I installed ODBC for MySQL and it CAN successfully connect to the db, so it's not a firewall issue (I also tried disabling the firewall)

Here is a quick summary of what I see:

1. MySQL db running on Linux box, within my network, port 3306
2. Mac can successfully connect to the db through Navcat Lite
3. Toad for MySQL (Win 7) CANNOT connect to the db using a TCP connection (tried increasing connection timeout to 30 sec)
4. ODBC Driver for MySQL (Win 7) CAN connect to the db using the same credentials

Any help would be much appreciated!

Here is the error that Toad throws:

System.TimeoutException A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond

---

Check this bug report. Might be what you are facing.

link: http://toadformysql.com/thread.jspa?threadID=32380

Taking in account your recent outcome from the packet sniffing, i do believe it is related to this bug report.

Toad seems to use the .net framework, according to the release notes it requires version 3.5 to be installed and the security policy set to unrestricted.

So, do you have .net 3.5 installed? if so, can you try to run toad as administrator?

PS: to set the security policy and i'm quoting from the link above:

To run Toad, the .NET security policy must be set to Unrestricted. To modify the security policy:

• Select Control Panel from the Windows Start menu.
• Double-click Administrative Tools.
• Double-click Microsoft .NET Framework version Configuration.
• Select My Computer, and then select the Runtime Security Policy node.
• Select Evaluate Assembly from the list of tasks in the right panel, and locate and select Toad.exe in the File field.
• Click Next and set the permission to Unrestricted.

Hope it helps, keep providing information.

---

I have the same issue with one my MySQL installations. I am able to connect using MySQL Workbench, but Toad for MySQL does not connect. Also, every application I created using MySQL .NET Connector also times out.

The solution I found was to connect the machines to the Internet and they connect instantly. I believe it has to do with the Connector and not Toad. Updating to a version beyond 5 should help.

---

Using freeware Toad for MySQL 8.0.0.296 (64 bit), instead using connection type TCP, use connection type SSH, insert database data like Host IP, user, password, default database and port. Also add SSH port, SSH Host IP, SSH user and password. Toad will emulate onnection directly to SSH console, the interface is the same, it works very fine, the error "Character set 'utf8mb3' is not supported by .Net Framework" is gone.