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
2 users online | 2 Guests and 0 Registered
Most popular FAQs 
- I get error 1130 "Host is not allowed to ... (503304 views)
- Error no. 2003: Can't connect... (418654 views)
- SQLyog Version History (271000 views)
- Error no. 1045: "Connection denied..." (229025 views)
- Error No. 2005: Unknown MySQL server host... (212551 views)
- Error no. 1251: "Client does not support authentication..." (201342 views)
- Can I use SQLyog with the WINE Windows emulator ... (193449 views)
- What is HTTP-tunneling? (166689 views)
- What Is SSH and SSH-tunneling? (138467 views)
- Introduction to the 'SQLyog Job Agent' (SJA) (136796 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 #42
Tags: -
Related entries:
- SQLyog gives you the most options for connecting to MySQL
- Do I need PHP to use SQLyog with MySQL?
- Welcome to the SQLyog FAQ
- SQLyog Version History
- Error messages
You cannot comment on this entry

I was no allowed to connect with SqlYog to mysql installed on another server. The problem was that the default root user created at installation the 'localhost' permissions has.
Thus: root@localhost
I changed it to:
root@%
and the problem was solved.
Added at: 2007-03-29 10:01
On windows, you need to turn off windows firewall or let traffic on your mysql server port through on both sides - the client and server machine.
Added at: 2011-10-17 04:43
If you're trying to connect to a SQL Server hosted by a host such as iPage, you need to connect using HTTP Tunneler because the port is blocked. This is easy, simply upload the SQLyogTunnel.php file from the SQLyog root directory to the root directory of your server then use the HTTP tab when making a new connection.
Added at: 2013-10-11 05:15