Choose your database:
MS SQL Server
SQL Anywhere

Subscribe to our news:
Adam Allen: "I just have to say WOW!!! I'm so glad that you guys have developed something that is so useful for MySql. I am able to graphically view my tables, and I don't even have to think about my queries because I can visually design them. I just stumbled upon this, and I'm already very excited about it".
Christian Novak: "Really good Job! I love this software and will buy it soon! Greetings from Austria".


Add your opinion

SQL Maestro Group / Products / MySQL / SQL Maestro for MySQL / News / SQL Maestro for MySQL 17.5 released

SQL Maestro for MySQL 17.5 released

May 22, 2017

SQL Maestro for MySQL

SQL Maestro Group is happy to announce the release of SQL Maestro for MySQL 17.5, a powerful Windows GUI solution for MySQL and MariaDB administration and database development.

Please consider the list of new features implemented in this version since the last official release:

New feature highlights:

  • This version has been successfully tested with all MySQL versions from 4.1 to 8.0.1 (the latest MySQL development version available at the moment) as well as with MariaDB 10.0, 10.1, and 10.2.
  • Direct support for a number of MariaDB-specific features has been implemented. The list of currently supported features is as follows:
    • Roles. Starting from this version you can create, edit, and delete roles as well as grant them permissions.
      Role Editor (MariaDB)Picture 1. Role Editor (MariaDB)
      To grant a permission for a database object (table, view, procedure, etc) to a role, you can use either the Grants tab of the Role editor or the Permissions tab in the object editor.
      Managing Table PermissionsPicture 2. Managing Table Permissions
    • Check Constraints. From now on you can add, edit, and drop named check constraints at the Checks tab of the Table Editor.
      Check EditorPicture 3. Check Editor
    • Virtual (Computed) Columns. Values of such columns are automatically calculated using a deterministic expression, in particular from the values of other fields in the table. Both persistent and pure virtual columns are supported.
      Managing generated columnsPicture 4. Managing virtual columns
      In Data Grids and Data Input Forms virtual columns are marked by a green calculator.
      Generated columns in the Data GridsPicture 5. Virtual columns in data grids
    • Default values for text and BLOB columns can now be specified in Field Editor. Also it becomes possible to select some predefined default values such as CURRENT_USER() or CURRENT_ROLE() from the list instead of entering them manually.
      Predefined Default ValuesPicture 6. Predefined Default Values
    • The Aria storage engine is now supported.
  • Support for roles introduced in MySQL 8.0 has been also implemented. As MySQL currently has no 100% reliable way to distinguish a role and a user, we decided to consider a principal to be a role if the corresponding account is locked and the account's password is expired.
    Role Editor (MySQL)Picture 7. Role Editor (MySQL)
  • Starting from this version it is possible to specify a custom label and/or a font color for server nodes in the Database Explorer tree.
    Explorer Tree: custom labels and colorsPicture 8. Explorer Tree: custom labels and colors
    To change these properties, right-click a server node, select "Edit Server Properties" from the popup menu and provide the values you need in the modal dialog.
    Edit Server Properties dialogPicture 9. Edit Server Properties dialog
  • The Statistics tab has been added to the Edit Database Profile dialog. Here you can find such information as profile creation time, total number of connections, last connection time, and so on.
    Database Profile StatisticsPicture 10. Database Profile Statistics
  • Data Grid: now it is possible to copy the value of the selected cell to Clipboard using grid's popup menu or Ctrl+Shift+C shortcut.
    Data Grid: copy cell valuePicture 11. Data Grid: copy cell value
  • The "Show SQL Help" command now displays the manual that corresponds the version of the database server you are connected to. This means it will display this page if you are working with MySQL 5.7, this one if you are working with MySQL 5.6, and so on.
    Show SQL Help commandPicture 12. Show SQL Help command
  • Support for Adobe Reader DC has been added to BLOB Editor. Also the editor window now saves its size and position between times it is opened (for each table).
    BLOB EditorPicture 13. BLOB Editor
  • Default Data Import settings can now be set up in the Program Options dialog.
    Data Import defaultsPicture 14. Data Import defaults
  • "Show special chars" and "Convert tabs to spaces" options have been added to the Editor settings.
    Editor OptionsPicture 15. Editor Options

In addition to this, several bugs have been fixed and some other minor improvements and corrections have been made.

Related links: