Table of contents
- What is EMS SQL Query for MySQL utility?
- What do I need to start working with EMS SQL Query for MySQL?
- What is the difference between the Query Builder module in EMS SQL Manager for MySQL tool and EMS SQL Query for MySQL utility?
- When I try to connect to a database, I get the following message: Access denied for user: user@host.domain Why does it happen?
Q:
What is EMS SQL Query for MySQL utility?
A:
EMS SQL Query for MySQL is a utility that lets you quickly and simply build SQL queries to MySQL databases. Visual building as well as direct editing of a query text is available. User-friendly graphical interface allows you to connect to databases, select tables and fields for a query, set the selection criteria and much more. You can work with several queries at once, edit queries and view the execution results in several modes and perform any other operations you may need in your work with database queries.
Q:
What do I need to start working with EMS SQL Query for MySQL?
A:
First of all you must have an opportunity to connect to some local or remote MySQL server. Besides you need your computer to satisfy the system requirements of EMS SQL Query for MySQL.
Q:
What is the difference between the Query Builder module in EMS SQL Manager for MySQL tool and EMS SQL Query for MySQL utility?
A:
First of all, EMS SQL Query for MySQL works faster as it is a much lighter product. Besides it provides additional features for query building, e.g.:
- "favorite" queries to find and execute often-used queries quickly;
- keeping query history, which allows you to rollback to any edited query;
- various interface improvements for more productive and easy work;
- ability to view query results in the form of diagram




