Please note: If this FAQ s empty you must choose English language from the drop-down-box below. Only English content is available as of now!
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
- Notification Services
- 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
- Instant Response
- Sitemap
Most popular FAQs 
- I get error 1130 "Host is not allowed to ... (115201 views)
- Error no. 2003: Can't connect... (51979 views)
- Error no. 1251: "Client does not support authentication..." (48041 views)
- Error no. 1045: "Connection denied..." (41265 views)
- SQLyog Version History (39857 views)
- What is HTTP-tunneling? (29222 views)
- Error No. 2005: Unknown MySQL server host... (28259 views)
- What Is SSH and SSH-tunneling? (25442 views)
- Why are Stored Procedures not created when I import ... (23378 views)
- Do I need PHP to use SQLyog with MySQL? ... (21478 views)
Latest FAQs
- SQLyog Version History (2010-03-09 03:20)
- SQLyog is a client for the MySQL server - ... (2009-09-11 07:48)
- Can I use SQLyog with the various SQL-modes available ... (2009-08-20 08:02)
- Failed dependency for libstdc++.so.5 error (2009-08-13 11:22)
- Wrong results are returned for FOUND_ROWS(). (2009-08-12 06:31)
Connection issues » Connection problems
Error no. 2003: Can't connect...
The error message
Error No. 2003: Can't connect to MySQL server on 'localhost' (or some other host)
simply means that connection is not possible for one of the following (or similar) reasons:
* There is no MySQL server running at the specified host
* Connection to the MySQL server is not allowed using TCP-IP. Check the 'skip-networking' setting in the MySQL configuration file (my.ini on Windows, my.cnf on Unix/Linux). It shall be commented out like '#skip-networking'. If it is not commented out, then do it and restart the MySQL server for the change to take effect. SQLyog needs to connect using TCP-IP.
* Some networking issue prevents connection. It could be a network malconfiguration or a firewall issue. We have experienced sometimes that some firewalls (ZoneAlarm in particular) is blocking TCP-IP connections even if it claims to be disabled. Most often it will help to uninstall and reinstall the firewall.
* When trying to connect to a MySQL server at an ISP this error message often indicates that direct connection to MySQL has been blocked. You must then use HTTP-tunneling or SSH-tunneling to connect.
* Also this FAQ may have relevant information. It describes some more special situations when connection to MySQL on Linux.
Tags: -
Related entries:
- Do I need PHP to use SQLyog with MySQL?
- SQLyog gives you the most options for connecting to MySQL
- Installation and upgrading
- SQLyog Version History
- Error messages
Last update: 2005-09-20 23:28
Author: Peter Laursen
Revision: 1.0
You can comment this FAQ
Comment of G.Zanferrari:
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