Online Documentation for SQL Query for MySQL

EMS SQL Query FAQ


Please read this page attentively if you have questions about SQL Query for MySQL.

 

Table of contents

 

Product questions

 

 

Troubleshooting

 

 

 

Question/answer list

 

Product questions

 

Q: What is EMS Query for MySQL?

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 are 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 one of the available 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?

A: First of all, you must have a possibility to connect to some local or remote MySQL server to work withSQL Query. You can download MySQL database server from https://www.mysql.org/downloads/ (download is free). Besides, you need your workstation to satisfy the system requirements of SQL Query for MySQL.

 

 

Q: What is the difference between the Query Builder module in SQL Manager for MySQL and the standalone SQL Query application?

A: First of all, SQL Query for MySQL works faster as it is a considerably lighter application. Besides, it provides additional features for query building, namely:

  • "favorite" queries to find and execute often used queries quickly;
  • saving query history which allows you to rollback to any of the previous queries;
  • various interface improvements for easier and more productive work.

 

Q: Are there any limitations implied in the trial version as compared with the full one?

A: Actually the trial version of the utility does not differ from the full version as far as the functionality is concerned. That is, you can test all the features implemented in SQL Query for MySQL within the 30-day trial period.

 

 

Scroll to top

 

Troubleshooting

 

Q: I cannot figure out how I can use the Export dataset function. Why I press the Export Data toolbar button, nothing happens.

A: Please make sure that you have the latest version of EMS Data Export for MySQL installed on your system. Note that the export utility should be registered and run at least once before you use the Exporting results function.

 

 

Q: I use a UTF-8 database. Native characters are displayed incorrectly in the query result. What is wrong?

A: You need to set Client charset in the Database Registration Info dialog.

 

 

Q: I've registered the DB, but on attempt to connect the "dynamic library libmysql.dll not found" message appears.

A: Please, make sure that the libmysql.dll file exists in the program directory. Reinstallation of the application  may solve the problem.

 

 

Q: When I try to register a database, I get the following message: Access denied for user: user@host.domain. Why does it happen?

A: This error is returned by MySQL server because you do not have privileges to connect to the server from your host. Please contact your database administrator to resolve this problem.

 

 

Q: I try to connect to a remote MySQL host, but I receive only the "Host not allowed to connect to server" message. What can be the reason?

A: This error occurs because you do not have the permission to connect to the remote MySQL server from your host. Please contact your database administrator or, if you have access to MySQL server with grant privilege, you can use the GRANT statement to add a new user. For example, the following command will give full access from your host to the user:

GRANT ALL PRIVILEGES ON *.* TO 'user' IDENTIFIED

BY 'user_password' WITH GRANT OPTION;

Please read the "GRANT and REVOKE Syntax" chapter of MySQL reference.

 

 

Q: I get the "Bad handshake" message when I try to connect to MySQL 4.1.x. Does this product support 4.1.x?

A: You seem to be using an old version of the client library (libmysql.dll). We recommend you to use the client library which is distributed with SQL Query for MySQL installation package. Try to reinstall the application.

 

 

Q: Every time I try to connect to MySQL on a remote Linux server, I get the 'Lost connection to MySQL server during query' error. How can I fix this?

A: This error can occur if your Linux glibc requires greater than 128K of stack size to resolve a hostname. It happens primarily on RedHat 8.0 system with MySQL version lower than 4.0.10, but is can also happen with another configuration. To solve such issue, add/edit the following line to the [mysqld] section of MySQL configuration file:

set-variable = thread_stack=192k # value must be 192K or higher

 

Scroll to top

 

If you still have any questions, contact us at our Support Center.