If SQLyog is taking long time (more than 5-10 seconds) to connect to your MySQL server using SSH tunneling then there could be problem with the name resolution.
The first thing that the SSH server does before forwarding the connection to the specified MySQL server is to perform a reverse DNS lookup on the client’s IP. The SSH server may cause an unnecessary delay during authentication due to incorrect or absent of reverse DNS settings. So in case of any slowness you should check those settings.
You can also disable most of the server-side lookups by setting UseDNS = "no" in SSHD configuration file (/etc/ssh/sshd_config on most systems). But in that case the MySQL host must be specified with an ip and not a hostname.
Navigation
- FAQ Home
- All categories
- About Webyog support and about this FAQ
- About the SQLyog program
- Connection issues
- Using the GUI
- Managing your MySQL Database Systems
- Database Schema Synchronization
- MySQL DATA synchronization
- SQL Scheduler and Reporting Tool
- Importing external data
- Backup/Restore
- SQLyog Job Agent (SJA)
- Working with Views, Stored Procedures and Triggers
- Character Set and Localization Issues
- MySQL bugs that affect SQLyog
- Questions on Open Source and Compiling
- Sitemap
0 users online | 0 Guests and 0 Registered
Most popular FAQs
- I get error 1130 "Host is not allowed to ... (465626 views)
- Error no. 2003: Can't connect... (381367 views)
- SQLyog Version History (234343 views)
- Error no. 1045: "Connection denied..." (195077 views)
- Error No. 2005: Unknown MySQL server host... (177254 views)
- Error no. 1251: "Client does not support authentication..." (165772 views)
- Can I use SQLyog with the WINE Windows emulator ... (157494 views)
- What is HTTP-tunneling? (132113 views)
- What Is SSH and SSH-tunneling? (103661 views)
- Introduction to the 'SQLyog Job Agent' (SJA) (101586 views)
Latest FAQs
- SQLyog Version History (2014-06-08 10:22)
- I get error 1130 "Host is not allowed to ... (2014-01-30 12:21)
- About CHUNKs and BULKs (2014-01-09 11:53)
- SQLyog is a client for the MySQL server - ... (2013-08-04 04:48)
- Problems creating a functional DSN on 64 bit Windows. ... (2013-07-22 08:34)
Sticky FAQs
ID #1187
SQLyog takes long time to connect when using SSH-tunnel.
Tags: -
Related entries:
- SQLyog Version History
- What Is SSH and SSH-tunneling?
- How shall I understand the 'query execution time' that SQLyog gives me?
- SSH error messages
- How do connection names resolve to ip's?
You can comment this FAQ