SQL Maestro Group / Products / MySQL / SQL Maestro for MySQL / FAQ

SQL Maestro for MySQL FAQ

You are welcome to look through the following Frequently Asked Questions list for getting to know the answers to the most commonly asked questions about SQL Maestro for MySQL.

If you want to ask a question which is not in the list you may apply to our support team.

Why SQL Maestro for MySQL?

SQL Maestro for MySQL is a powerful Windows database management solution for MySQL administration and development. The software provides you with graphical user interface (GUI) which allows you to make database operations easy and fast.

With SQL Maestro for MySQL you can easily create, edit and drop database objects, build queries as visual diagrams, execute queries and SQL scripts, manage data including BLOBs, manage MySQL security features, and use a lot of other tools designed for the easiest and most efficient work with MySQL.

Is it possible to try SQL Maestro for MySQL before buying?

Yes, of course. The latest fully functional trial version is always available for downloading.

I want to use your software for educational purposes. Can I get a discount?

Yes, you can. Feel free to choose a non-commercial license. Exact prices can be obtained on the purchase page.

We intend to buy multiple licenses. Is it possible to obtain a discount?

Yes, certainly. You can get a volume discount purchasing 3 and more licenses for the same product as well as a cross-selling discount purchasing multiple different products at a time. Also you can get a great discount purchasing a bundle that includes SQL Maestro for MySQL.

I would like to resell SQL Maestro for MySQL to my customers. What are your reseller's discounts?

You are to discuss reseller's policy with our sales department.

Which license type can I select?

You may choose a non-commercial license if you use the software for non-commercial purposes in non-business, non-commercial environment. You should purchase a business license to use the software in a corporate, government, or business environment.

Single license means that a copy of the software is allowed to be used only on a single computer and only by a single user at a time. If you wish to use the software for more than one user, you will need a separate license for each individual user (click the "Order now" button to see volume discounts). Site license means that the software is allowed to be used without limitation on count of installations and users within one organization.

All our products and bundles are shipped with 12 months of free upgrades (minor and major ones) or with 36 months of free upgrades for a quite small additional fee.

Can I deploy a single license for both desktop and laptop?

A single license can be installed on a single computer. However, we offer a special allowance which authorizes you to deploy SQL Maestro for MySQL on both desktop computer and portable computer, laptop, or other mobile computer with a single license, as long as it is not being used simultaneously.

What are system requirements for installing your software?

Pentium PC or higher;
Windows NT4/2000/XP/Vista/Windows 7/Windows 8/Windows 10;
1 GB RAM (2 GB or more is recommended);
50 MB of free hard disk space;
SVGA-compatible video adapter.

How can I find out the date of my current product version release?

Product versions are formalized according to the date of release. For more information, please refer to the appropriate news article.

Is it possible to install the software in "silent" mode (without user interaction)?

Yes, it is possible. Run installation_package.exe with /SILENT or /VERYSILENT command line parameter. When /SILENT is used the wizard and the background window are not displayed but the installation progress window is. When /VERYSILENT is used this installation progress window is not displayed at all.

What should I enter as 'host' when connecting to a MySQL server?

You may enter a domain name or an IP address. Examples are: localhost, 245.139.237.146, www.yoursite.com.

Does SQL Maestro for MySQL work with MariaDB?

Yes, all our MySQL-related tools have been successfully tested with MariaDB.

Does SQL Maestro for MySQL support MariaDB-specific features?

Yes, SQL Maestro for MySQL provides direct support for a number of MariaDB-specific features including roles, check constraints, virtual columns, and more.

I cannot create views using your program. There is no such node in the explorer tree.

Views are being implemented in the 5.01 version of MySQL Server. Check the version of MySQL server you are using.

How to transfer a database from one MySQL server to another?

Export your database to an SQL script with the Backup Database tool, then create a new database at the target server and execute the result script against that database.

Why I cannot create a foreign key for a table?

Foreign keys are supported only for InnoDB tables. You can change the table engine at the Properties tab of Table Editor.

I want to connect to the server via SSH tunnel and I have a public-private key pair that works fine with PuTTY. However when I test the connection, I get an error message "Key is broken".

PuTTY uses its own format to store private keys while our products support private keys stored either in OpenSSH or ssh.com formats. To convert a private key from PuTTY's format to one of the formats acceptable by our software, use the PuTTYgen utility that can be freely downloaded from the PuTTY website.

Are there any graphical tools for building and executing queries implemented?

SQL Maestro for MySQL provides two powerful tools which allow you either to edit query text directly with syntax highlighting and code completion or to build a query diagram visually selecting tables and fields, setting links between tables, etc.

What is the function of Generate Database Report? Does the report include data?

Generate Database Report Wizard allows you to print definitions of the database objects. To run the wizard, select the Tools | Generate Database Report main menu item. The wizard helps you to print all the database object or specify the Categories for printing according to the selected object type. The report does not include database data.

Is code completion implemented in the SQL Editor?

The Editor area is provided for working with the text of the query. For your convenience code completion is enabled. You can activate the completion list by pressing the Ctrl+Space key combination.

I cannot edit the SQL definition using the SQL tab? Why?

The reason is that you are trying to edit SQL definition within the SQL tab of the object editor. Bear in mind that this text is read-only. If you want to modify the object definition, use SQL Editor or SQL Script Editor tools.

What is the difference between Object Manager and Object Browser?

Both Object Manager and Object Browser are tools for operating on database objects designed as extensions of the Database Explorer. SQL Maestro for MySQL provides such operations as multiple selecting of objects (for copying, dropping, etc.) and the ability of using drag-and-drop operations between Object Manager, Object Browser and Database Explorer as well as between instances of the Object Manager or Object Browser. Unlike Object Manager Object Browser represents objects as a grid with according possibilities (sorting, grouping, and filtering).

Is it possible to execute more than one query using SQL Editor?

SQL Editor provides you with an ability to execute multiple queries separated by a statement delimiter from the same editor tab. Queries are executed in a separate thread, so all SQL Maestro for MySQL features remain available during the execution.