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
24 users online | 24 Guests and 0 Registered
Most popular FAQs
- I get error 1130 "Host is not allowed to ... (460347 views)
- Error no. 2003: Can't connect... (375973 views)
- SQLyog Version History (229176 views)
- Error no. 1045: "Connection denied..." (190253 views)
- Error No. 2005: Unknown MySQL server host... (172271 views)
- Error no. 1251: "Client does not support authentication..." (160691 views)
- Can I use SQLyog with the WINE Windows emulator ... (152347 views)
- What is HTTP-tunneling? (127292 views)
- What Is SSH and SSH-tunneling? (98643 views)
- Introduction to the 'SQLyog Job Agent' (SJA) (96589 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