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
3 users online | 3 Guests and 0 Registered
Most popular FAQs 
- I get error 1130 "Host is not allowed to ... (169314 views)
- Error no. 2003: Can't connect... (86274 views)
- SQLyog Version History (63952 views)
- Error no. 1045: "Connection denied..." (61348 views)
- Error no. 1251: "Client does not support authentication..." (58317 views)
- Error No. 2005: Unknown MySQL server host... (50193 views)
- What is HTTP-tunneling? (42282 views)
- What Is SSH and SSH-tunneling? (38073 views)
- Can I use SQLyog with the WINE Windows emulator ... (34946 views)
- Why are Stored Procedures not created when I import ... (34267 views)
Latest FAQs 
- SQLyog Version History (2012-01-26 08:20)
- SQLyog is a client for the MySQL server - ... (2011-11-04 04:48)
- I get error 1130 "Host is not allowed to ... (2011-11-01 05:21)
- Problems on Ubuntu 11.x (2011-10-29 13:02)
- Problems creating a functional DSN on 64 bit Windows. ... (2011-09-15 14:34)
Sticky FAQs
Connection issues » Connection problems
ID #1029
I am able to connect but can't see the list of databases/tables.
You must have at least SELECT privilege (as a global privilege or a SCHEMA/COLUMN privilege, to be able to see any data.
More information on the MySQL privilege system can be found here
If the database is hosted at an ISP/hosting provider it is likely that you must use some web-based "Control Panel" application to set up user privileges.
Tags: -
Related entries:
- Do I need PHP to use SQLyog with MySQL?
- SQLyog gives you the most options for connecting to MySQL
- SQLyog Version History
- What kind of ODBC databases are supported by SQLyog Import External Data Tool?
- Can I perform "incremental import" with the SQLyog Import External Data Tool?
Last update: 2005-09-20 23:55
Author: Peter Laursen
Revision: 1.0
{translationForm}
You can comment this FAQ