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 ... (476343 views)
- Error no. 2003: Can't connect... (392032 views)
- SQLyog Version History (244550 views)
- Error no. 1045: "Connection denied..." (204717 views)
- Error No. 2005: Unknown MySQL server host... (187257 views)
- Error no. 1251: "Client does not support authentication..." (175920 views)
- Can I use SQLyog with the WINE Windows emulator ... (167764 views)
- What is HTTP-tunneling? (141930 views)
- What Is SSH and SSH-tunneling? (113563 views)
- Introduction to the 'SQLyog Job Agent' (SJA) (111651 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