Release Notes

Windows
macOS
Linux

If you have purchased our products and want to retrieve the download information of the latest version, please click here.

Feb 29 2024
Navicat for MySQL (Windows) version 16.3.8

Bug-fixes:

  1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Feb 21 2024
Navicat for MySQL (Windows) version 16.3.7

Bug-fixes:

  1. Crashed when importing paradox files.
  2. Failed to import JSON file from web service.
  3. Refresh button did not work in Server Monitor.
  4. Some labels disappeared after adding the chart to the dashboard.
  5. Unable to display proportion percentages in the chart axis.
  6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jan 11 2024
Navicat for MySQL (Windows) version 16.3.5

Bug-fixes:

  1. The percentage values shown in the chart were incorrect.
  2. Not all data was imported when scheduling import.
  3. Unknown Internal Error occurred when importing data.
  4. The comment code shortcut did not work in some cases.
  5. Unknown Internal Error occurred when transferring data.
  6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Dec 5 2023
Navicat for MySQL (Windows) version 16.3.3

Improvements:

  1. Support enabling or disabling "Detect Data Types" in Import Wizard.
  2. Support ssh agent using pageant unix mode.

Bug-fixes:

  1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Nov 7 2023
Navicat for MySQL (Windows) version 16.3.2

Bug-fixes:

  1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Oct 17 2023
Navicat for MySQL (Windows) version 16.3.0

Improvements:

  1. Support setting MySQL descending primary key.

Bug-fixes:

  1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Oct 3 2023
Navicat for MySQL (Windows) version 16.2.11

Bug-fixes:

  1. Crashed when opening Charts workspaces in some cases.
  2. Missing parameters when transferring MariaDB Functions.
  3. Crashed when scheduling import jobs.
  4. 1064 error occurred when running query to create stored procedure in some cases.
  5. Missing records when importing files in some cases.
  6. Special characters were garbled when using double-click to add a snippet to the query.
  7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Sep 7 2023
Navicat for MySQL (Windows) version 16.2.10

Bug-fixes:

  1. Crashed when importing Access files.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Aug 28 2023
Navicat for MySQL (Windows) version 16.2.8

Improvements:

  1. Auto guess field types when importing xlsx files.

Bug-fixes:

  1. Beautify SQL incorrectly added spaces between the function name and parentheses.
  2. Unable connect to MySQL via SSH tunnel in some cases.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Aug 14 2023
Navicat for MySQL (Windows) version 16.2.7

Bug-fixes:

  1. Incorrectly triggering code completion when pressing ENTER in Query Editor.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Aug 7 2023
Navicat for MySQL (Windows) version 16.2.6

Bug-fixes:

  1. Unable to close tabs in some cases.
  2. Slashes (\) were removed from triggers when synchronizing MariaDB structures.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jul 14 2023
Navicat for MySQL (Windows) version 16.2.5

Bug-fixes:

  1. Cannot type a new name for the table in Import Wizard.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jun 19 2023
Navicat for MySQL (Windows) version 16.2.3

Bug-fixes:

  1. Expressions for virtual columns were truncated.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jun 9 2023
Navicat for MySQL (Windows) version 16.2.2

Improvements:

  1. Support unix socket forwarding in SSH.

Bug-fixes:

  1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

May 31 2023
Navicat for MySQL (Windows) version 16.2.1

Main New Features:

  1. Support sequence design for MariaDB.
  2. Show fields, indexes and more under tables in Navigation Pane.
  3. Minor bug fixes and improvements.
  4. Navicat for Redis is released.

To upgrade, please visit our Customer Center.

Apr 26 2023
Navicat for MySQL (Windows) version 16.1.15

Bug-fixes:

  1. High CPU usage when using SSH connection.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Apr 17 2023
Navicat for MySQL (Windows) version 16.1.12

Bug-fixes:

  1. Query Builder window was larger than the screen in some cases.
  2. Unable to display the data differences of TEXT fields in Data Synchronization.
  3. The second field was selected when adding a sort condition in Table Viewer.
  4. Crashed when stopping Data Transfer process.
  5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Mar 13 2023
Navicat for MySQL (Windows) version 16.1.11

Bug-fixes:

  1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Mar 1 2023
Navicat for MySQL (Windows) version 16.1.9

Bug-fixes:

  1. Memory utilization issue.
  2. Table Viewer did not show the SQL if errors occurred.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Feb 8 2023
Navicat for MySQL (Windows) version 16.1.8

Bug-fixes:

  1. Unable to save changes after deleting a cell value in Table Viewer.
  2. Access violation error occurred when opening a model.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jan 31 2023
Navicat for MySQL (Windows) version 16.1.7

Improvements:

  1. Support MariaDB UUID type.

Bug-fixes:

  1. Cannot display column comment when mouse over in dark mode.
  2. Data Synchronization did not work in Automation.
  3. "Failed to send mail. Stream error." occurred when sending email.
  4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Dec 12 2022
Navicat for MySQL (Windows) version 16.1.6

Bug-fixes:

  1. "Cannot open source table" error occurred when using Condition Query in Import Wizard.
  2. Exporting to Excel file was slow.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Dec 5 2022
Navicat for MySQL (Windows) version 15.0.29

Bug-fixes:

  1. Failed to transfer large tables.
  2. Crashed when batch querying tables with FK dependency.
  3. Unknown Internal Error occurred when exporting large amount of data.
  4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Nov 21 2022
Navicat for MySQL (Windows) version 16.1.4

Bug-fixes:

  1. 1267 error occurred when clicking the "Users" button.
  2. Bar chart label display issue.
  3. Unable to export Excel file in some cases.
  4. Hanged when transferring tables.
  5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Nov 21 2022
Navicat for MySQL (macOS) version 16.1.4

Bug-fixes:

  1. 1267 error occurred when clicking the "Users" button.
  2. Bar chart label display issue.
  3. BLOB data was truncated in Console.
  4. Table columns were not aligned in Console.
  5. Chart value labels disappeared after reopening Navicat in dark mode.
  6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Sep 28 2022
Navicat for MySQL (Windows) version 16.1.3

Bug-fixes:

  1. Unable to connect server using HTTP tunnel in some cases.
  2. Font size issue in Form View.
  3. Buttons in the lower right corner of the main window were missing in some cases.
  4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Aug 31 2022
Navicat for MySQL (Windows) version 16.1.2

Bug-fixes:

  1. Crashed when changing the chart type in some cases.
  2. Hanged when deleting a table in Query Builder.
  3. Text color issue in Dark Mode.
  4. Unable to connect AWS RDS database via SSH.
  5. Backup and Dump SQL File was slow in some cases.
  6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Aug 16 2022
Navicat for MySQL (Windows) version 16.1.1

Bug-fixes:

  1. Unable to open the objects in the "Find in Database" window.
  2. The first number of every value in the list was removed in the table filter.
  3. Unknown Internal Error occurred when updating query results in some cases.
  4. Unable to use "Copy As" in View results.
  5. Crashed when opening functions in some cases.
  6. Unknown Internal Error occurred when foreign key selection window popped up.
  7. Crashed when clicking on the value box in table filter.
  8. Cannot retain the window size and position for existing objects.
  9. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jul 21 2022
Navicat for MySQL (Windows) version 16.1.0

Main New Features:

  1. Support OceanBase Community Edition.
  2. Support Trend Line for several chart types.
  3. Support adding On-Prem Server with URI.
  4. Allow skip preview of changes in data sync.
  5. Enhanced responsiveness and performance.
  6. Improved UI/UX.
  7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jun 14 2022
Navicat for MySQL (Windows) version 16.0.14

Bug-fixes:

  1. Query parameters did not work in some cases.
  2. Decimal precision issue when importing from Excel files.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

May 16 2022
Navicat for MySQL (Windows) version 16.0.13

Bug-fixes:

  1. Crashed when opening large tables.
  2. Incorrect MySQL auto increment value in Table Designer.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

May 4 2022
Navicat for MySQL (Windows) version 16.0.12

Bug-fixes:

  1. Extra commas were added to the script in Structure Synchronization.
  2. Unknown Internal Error occurred when exporting large amount of data.
  3. Unable to sign in Subscription plan.
  4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Mar 29 2022
Navicat for MySQL (Windows) version 16.0.11

Bug-fixes:

  1. Crashed when running Automation in some cases.
  2. Missing the first record when import.
  3. Unable to locate project when running batch job.
  4. Unable to get table information when scheduling data synchronization.
  5. Refresh button ran all SQLs in Query Editor.
  6. .0000 data export issue.
  7. Function execution message log issue.
  8. Access Violation error occurred when removing default value.
  9. Navicat exited when clicking the Type column in Table Designer.
  10. Crashed when batch querying tables with FK dependency.
  11. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Mar 1 2022
Navicat for MySQL (Windows) version 16.0.10

Bug-fixes:

  1. Unable to close the error dialog when changing field name in model canvas.
  2. Unable to connect to MySQL using named pipe in some cases.
  3. Syntax error occurred when using Structure Synchronization in some cases.
  4. Unable to close the error dialog when editing chart y-axis range.
  5. Unable to update the default value of mediumtext field.
  6. Failed to transfer large tables.
  7. SSH connection issue when using Automation.
  8. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jan 18 2022
Navicat for MySQL (Windows) version 15.0.28

Bug-fixes:

  1. Syntax error occurred when importing data to MySQL table.
  2. Incorrect END clause in SQL when creating MariaDB Event.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jan 13 2022
Navicat for MySQL (Windows) version 16.0.9

Bug-fixes:

  1. The "Compare" button did not work in Data Synchronization in some cases.
  2. "Couldn't open known_hosts file" error occurred when the SSH path contained Chinese characters.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jan 3 2022
Navicat for MySQL (Windows) version 16.0.7

Bug-fixes:

  1. Unable to show utf8mb4 data.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Dec 15 2021
Navicat for MySQL (Windows) version 16.0.6

Bug-fixes:

  1. Connection encoding issue in Navicat Cloud.
  2. Connection password issue when updating connection in Navicat Cloud.
  3. Error occurred when synchronizing to Navicat Cloud.
  4. Unable to view and edit user/role privileges.
  5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Dec 7 2021
Navicat for MySQL (Windows) version 16.0.4

Bug-fixes:

  1. Syntax error occurred when importing data to MySQL table.
  2. Notification Email authentication failed in some cases.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Nov 23 2021
Navicat for MySQL (Windows) version 16.0.3

Main New Features:

  1. New Data Generation Tool
  2. Enhanced Charts Feature
  3. Support of Navicat On-Prem Server

Additional Features:

  1. Connection Profiles
  2. Field Information Pane
  3. Query Execution Summary
  4. Navicat On-Prem Server is released
  5. Many other new features and improvements

To upgrade, please visit our Customer Center.

Nov 9 2021
Navicat for MySQL (Windows) version 15.0.27

Bug-fixes:

  1. Double foreign key lines were printed when exporting a model to a PDF file.
  2. Access violation error occurred when searching in the Backup's Object Selection tab.
  3. No data value on the label when exporting a chart to a PDF file.
  4. Unable to rename a view inside a group in Navicat Cloud.
  5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jul 28 2021
Navicat for MySQL (Windows) version 15.0.26

Improvements:

  1. Support tunneling on PHP 8.

Bug-fixes:

  1. Unknown Internal Error occurred when importing Excel file in some cases.
  2. An empty string was not quoted when exporting to a text file.
  3. Query was garbled when the system locale set to Japanese.
  4. Export/Import profile did not work if it was copied to Desktop.
  5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Apr 26 2021
Navicat for MySQL (Windows) version 15.0.25

Bug-fixes:

  1. Empty rows were added when exporting more than 1.05 M records to Excel file.
  2. Error occurred when using Recordset Generator to generate a record set for the Date field.
  3. Hanged when designing a table with many fields.
  4. Relation lines were disappeared after saving and reopening Logical Model.
  5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Mar 15 2021
Navicat for MySQL (Windows) version 15.0.23

Bug-fixes:

  1. Functions were not properly saved as the default value in MariaDB.
  2. ER diagram was reloaded when clicking the Design Table button.
  3. Unable to toggle "Virtual Type" in an existing table.
  4. Error 1227 occurred when creating or designing a table.
  5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jan 13 2021
Navicat for MySQL (Windows) version 15.0.22

Bug-fixes:

  1. MySQL/MariaDB connection encoding issue.
  2. Wrong MySQL version was detected for Microsoft Azure connection.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Dec 22 2020
Navicat for MySQL (Windows) version 12.1.28

Bug-fixes:

  1. Unable to show user's database privileges in MySQL 5.0.
  2. Unable to change the label text color in Report's header.
  3. Incorrect default value was displayed for BIT field in a new record.
  4. Notification email subject was incorrect when the job finished unsuccessfully.
  5. Cursor focusing issue when using Find feature in Table Viewer.
  6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Dec 15 2020
Navicat for MySQL (Windows) version 15.0.21

Bug-fixes:

  1. Queries cannot be displayed when "Settings Location" was set to a network path.
  2. Error 80041318 occurred when setting schedule .
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Dec 8 2020
Navicat for MySQL (Windows) version 15.0.20

Bug-fixes:

  1. Flashed in dark mode.
  2. "Unallowed argument in list..." error when running export / import schedule.
  3. Unable to load version 10 data synchronization profiles.
  4. Differences were incorrectly detected in Synchronize to Database.
  5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Nov 3 2020
Navicat for MySQL (Windows) version 15.0.19

Bug-fixes:

  1. Unable to import MEMO data from DBF files.
  2. Unable to reconnect SSH connection after the PC woke up.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Sep 15 2020
Navicat for MySQL (Windows) version 15.0.18

Bug-fixes:

  1. Unable to show records that had -1 data in Table Viewer.
  2. "Drop target objects before create" option did not work in Data Transfer.
  3. Memory leak issue when enabled code completion.
  4. "Unknown Internal Error (A70529211102SE)" error occurred when exporting / importing data.
  5. Slow issue when transferring large tables.
  6. Unable to show the inputted text in Filter Wizard.
  7. Error occurred when filtering data by right-clicking a cell in Table Viewer.
  8. Inserted records to the wrong table when transferring data to the target table with a different name.
  9. Unable to connect MySQL server when using TLSv1.2.
  10. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jun 22 2020
Navicat for MySQL (Windows) version 15.0.17

Bug-fixes:

  1. Differences were detected when re-comparing the model and the database.
  2. Unable to synchronize large ndm2 model files to Navicat Cloud.
  3. Unable to show users' database privileges in MySQL 5.0.
  4. Negative default value displayed as "-" in MariaDB.
  5. Drop-down list was blank in Table Designer.
  6. Unable to scroll after switching the query results to Form view.
  7. Syntax error occurred when transferring data between two MySQL 8 servers.
  8. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jun 3 2020
Navicat for MySQL (Windows) version 15.0.16

Improvements:

  1. Integer column exported in Number format when exporting Excel file.
  2. Display export profiles in the same group of queries.

Bug-fixes:

  1. Unable to set data to NULL in query results.
  2. Crashed when clicking the ellipsis button in Custom Recordset.
  3. Pasting data into a column cleared another column data.
  4. Default Settings Location path was set to a wrong location for some cases.
  5. "Floating point division by zero" error occurred when setting the dashboard background.
  6. The file extension was missing when exporting the dashboard.
  7. Query Parameter did not work when using a parameter twice.
  8. "Invalid floating point operation" error occurred when adding NULL data to the chart.
  9. Incorrect columns were displayed after clicking the Default button in the "Choose columns" window
  10. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

May 6 2020
Navicat for MySQL (Windows) version 15.0.14

Bug-fixes:

  1. Unable to synchronize data to MySQL 8.0.19.
  2. Unable to connect AnalyticDB.
  3. Unable to export data to .mdb files.
  4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Apr 15 2020
Navicat for MySQL (Windows) version 15.0.13

Bug-fixes:

  1. MySQL table row format reverted to Compact after editing.
  2. Syntax error occurred when creating events.
  3. Unable to set default value for fields in Table Designer.
  4. Unable to show SUPER privilege for MariaDB 10.4 in the user object list.
  5. Foreign key was dropped and added when re-comparing the model.
  6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Mar 24 2020
Navicat for MySQL (Windows) version 15.0.12

Bug-fixes:

  1. Invalid XML error occurred when importing connections.
  2. Differences was detected in re-comparison in Structure Synchronization and Synchronize to Database.
  3. Incorrect data was updated when saving ; in a non-text field.
  4. Incorrect SQL generated for altering fields in Structure Synchronization.
  5. Incorrect items were displayed in suggestion list when using code completion with alias.
  6. Incorrect SQL generated when enabling "On Update Current_timestamp" in Table Designer.
  7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Feb 28 2020
Navicat for MySQL (Windows) version 12.1.27

Bug-fixes:

  1. Query wrongly returned null results in some cases.
  2. Unable to update bit type data.
  3. Datetime format issue when exporting to Excel files.
  4. Query Results Text pane appended values of the selected cells.
  5. Syntax error occurred when renaming an index in MariaDB table.
  6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Feb 27 2020
Navicat for MySQL (Windows) version 15.0.11

Bug-fixes:

  1. Query wrongly returned null results in some cases.
  2. "," was replaced by "." when using Custom Filter in Table Viewer.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Feb 19 2020
Navicat for MySQL (Windows) version 15.0.10

Improvements:

  1. Added "Table Relation" and "Field Relation" options to Query Builder.
  2. Added Connection Coloring to Query windows.

Bug-fixes:

  1. Unknown Internal Error occurred when starting Navicat in some cases.
  2. Crashed when importing two XML files.
  3. Popup menu was missing when right-clicking on stored procedure results.
  4. The performance of Privilege Manager was slow.
  5. Unable to synchronize decimal data from MariaDB to MySQL 8.0.
  6. Refresh button in Privilege Manager did not pull the latest privileges.
  7. Differences were detected after synchronizing model to database.
  8. Syntax error occurred when saving procedures in some cases.
  9. Datetime functions generated text in exported Excel files.
  10. Hanged when searching regular expression in Query Editor.
  11. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jan 16 2020
Navicat for MySQL (Windows) version 15.0.9

Bug-fixes:

  1. Only the first batch was transferred when "Number of row per batch" was enabled.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jan 16 2020
Navicat for MySQL (Linux) version 15.0.8

Bug-fixes:

  1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jan 15 2020
Navicat for MySQL (Windows) version 15.0.8

Improvements:

  1. Added "Keep Orthogonal Layout" to Model.

Bug-fixes:

  1. Unable to update bit type data.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jan 6 2020
Navicat for MySQL (Windows) version 15.0.6

Improvements:

  1. Added shortcuts for "Run Current Statement" and "Select Current Statement" in Query Editor.

Bug-fixes:

  1. "Unknown Internal Error" occurred when modeling databases.
  2. Find bar UI issue in Data Viewer.
  3. Unable to print table when using popup menu on Navigation pane.
  4. Syntax error occurred when renaming index in MariaDB table.
  5. Explain feature did not work with query parameters.
  6. Interval type was not supported in Charts.
  7. Highlight color issue in Filter wizard when using Dark mode.
  8. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Dec 19 2019
Navicat for MySQL (Windows) version 12.1.26

Bug-fixes:

  1. Unable to connect Azure Database for MariaDB.
  2. Wrong options were selected when loading another Data Transfer profile.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Dec 19 2019
Navicat for MySQL (Windows) version 15.0.5

Bug-fixes:

  1. "Invalid floating point operation" error occurred when resizing tables in View Builder.
  2. Multiple primary key names were generated when exporting model to SQL files.
  3. Syntax error occurred when connecting to MySQL 4.
  4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Dec 9 2019
Navicat for MySQL (Windows) version 15.0.4

Bug-fixes:

  1. Access violation error occurred when adding users to Navicat Cloud project.
  2. Access Denied error occurred when designing table.
  3. Unable to highlight field when typing in Filter's field selection list.
  4. Wrong fields are exported to the SQL file when not all fields are selected.
  5. Dark theme kept reverting back to Normal theme.
  6. Wrong CREATE INDEX was generated in Model.
  7. MySQL JSON data was truncated in Table Viewer.
  8. Empty value was exported as **** when exporting DBF file.
  9. Data Transfer high memory consumption issue.
  10. Unable to connect Azure Database for MariaDB.
  11. Run queries slow issue.
  12. "List index out of bounds (-1)" error occurred when editing role privileges.
  13. "Last Tab Window" option was missing.

To upgrade, please visit our Customer Center.

Nov 25 2019
Navicat for MySQL (Windows) version 15.0.3

New Features:

  1. New Charts
  2. Advanced Data Transfer
  3. Brand new Query Builder
  4. Enhanced Data Modeling Tool
  5. Dark theme UI and Diagram
  6. Many other new features and improvements

To upgrade, please visit our Customer Center.

Oct 31 2019
Navicat for MySQL (Windows) version 12.1.25

Bug-fixes:

  1. Unable to list tables when connecting to MyCat.
  2. Down arrow key did not highlight table grid cell in some cases.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Oct 2 2019
Navicat for MySQL (Windows) version 12.1.24

Bug-fixes:

  1. Failed to update records in table viewer.
  2. "Input profile is invalid" error occurred when opening export query profiles.
  3. Tab was exported instead of "," when scheduling to export CSV files.
  4. Automation was failed when scheduling export profile and import profile.
  5. Unable to copy and paste "," comma decimal separator.
  6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Sep 17 2019
Navicat for MySQL (Windows) version 12.1.23

Bug-fixes:

  1. Export process was slow.
  2. Unable to dump the default value of TIMESTAMP field.
  3. Synchronize to Database feature wrongly detected differences of unique constraints.
  4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Aug 1 2019
Navicat for MySQL (Windows) version 12.1.22

Bug-fixes:

  1. Copy and paste data issue in Table Viewer.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jul 30 2019
Navicat for MySQL (Windows) version 12.1.21

Bug-fixes:

  1. Unable to list users for MariaDB 10.4.
  2. Code Completion did not work in some cases.
  3. Unable to import signed numbers when there was spaces between the sign and the number.
  4. Unable to map a source field to multiple target fields in Import Wizard.
  5. DELIMITER statements did not work in Console.
  6. "Cannot open file" error occurred when scheduling export profiles in some cases.
  7. Unable to show empty fields in query result sets.
  8. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jun 10 2019
Navicat for MySQL (Windows) version 12.1.20

Bug-fixes:

  1. "Unknown Internal Error" occurred when opening Table Designer.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

May 23 2019
Navicat for MySQL (Windows) version 12.1.19

Bug-fixes:

  1. Text editor did not display the full text in some cases.
  2. Data Synchronization inserted values into Generated Columns.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Apr 17 2019
Navicat for MySQL (Windows) version 12.1.18

Bug-fixes:

  1. Error occurred when connecting to MySQL 4.0.
  2. Primary Key checkbox was deselected when tabbing to the next field in Table Designer.
  3. "Unknown Internal" error occurred when importing data.
  4. Table Designer cannot show the definition of MySQL 5.0 triggers.
  5. The deployment scripts generated incorrect default value in Structure Synchronization.
  6. "Access Violation" error occurred after editing the data pipeline in Report.
  7. "Unknown Internal" error occurred when using Automation.
  8. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Mar 21 2019
Navicat for MySQL (Windows) version 12.1.17

Bug-fixes:

  1. Query result pane size did not retain after minimizing the window.
  2. Paradox tables cannot be imported.
  3. Unknown Internal error occurred when importing data.
  4. "On Update Current Timestamp" option did not reflect the settings when using ANSI_QUOTES SQL mode.
  5. Column order was incorrect when importing database to model.
  6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Feb 26 2019
Navicat for MySQL (Windows) version 12.1.16

Bug-fixes:

  1. "Replace All" button was unable to replace the last occurrence in Query Editor.
  2. "Profile Location (MariaDB)" option was missing in Navicat for MySQL.
  3. Code completion suggestion list did not show on the same screen as the editor.
  4. A table was mistakenly transferred even it was not selected.
  5. Incorrect syntax highlighting issue in Query Editor.
  6. MySQL trigger definition displayed \\ as \ .
  7. Filter criteria input box was not retained when switching applications.
  8. Drag and drop selected text on Query Editor did not move the text.
  9. JSON expression did not display correctly in Table Designer.
  10. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Feb 13 2019
Navicat for MySQL (Windows) version 12.1.15

Bug-fixes:

  1. "Cannot add foreign key constraint" error occurred when importing Access file.
  2. Code completion box displayed off the bottom of the screen and partially obscured.
  3. Unable to customize query result tab name by using /*NAME:XYZ*/ .
  4. Boolean or BIT(1) values importing, exporting and transferring issue.
  5. Copying table field names in Table Designer was slow.
  6. Table Form view was unable to show jpg images.
  7. Unable to import data when using Append/Update mode.
  8. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jan 10 2019
Navicat for MySQL (Windows) version 12.1.12

Bug-fixes:

  1. SQL order issue in Structure Synchronization.
  2. Console window was not colored when connection coloring were set.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Nov 23 2018
Navicat for MySQL (Windows) version 12.1.10

Improvements:

  1. Added the "Include Owner" or "Include Definer" option in Data Transfer.

Bug-fixes:

  1. Geometry field precision was lost when transferring MySQL/MariaDB tables.
  2. List index out of bounds error occurred when inserting data in Table Viewer.
  3. Unable to shrink the last column on the Process List tab in Server Monitor.
  4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Nov 6 2018
Navicat for MySQL (Windows) version 12.1.9

Improvements:

  1. Added the "Compare owners" option in Structure Synchronization.

Bug-fixes:

  1. Slow performance when editing users or roles.
  2. Floating point numbers were rounded to decimals when import.
  3. <html> tag was repeated twice when exporting HTML files.
  4. "Add Database to List" button was enabled when the "Use custom database list" option was not checked.

To upgrade, please visit our Customer Center.

Oct 5 2018
Navicat for MySQL (Windows) version 12.1.8

Bug-fixes:

  1. Custom Filter was cleared when editing it.
  2. HTML export did not specify charset.
  3. "Show/Hide Columns" option was missing in Form View.
  4. The hidden Information pane was shown when switching from Form View to Grid View.
  5. Cursor focus issue in Form View.
  6. Code Completion did not work in some cases.
  7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Sep 10 2018
Navicat for MySQL (Windows) version 12.1.7

Bug-fixes:

  1. "SQLite function sqlite_libversion cannot linked" error occurred when starting Navicat.
  2. Unable to scroll inside the text box in Form View.
  3. "is in list" operator in Filter Wizard did not working correctly.
  4. Structure Synchronization compared table options.
  5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Aug 21 2018
Navicat for MySQL (Windows) version 12.1.6

Bug-fixes:

  1. Unknown Internal Error occurred when showing data "{}" in TEXT editor.
  2. Precision value in CURRENT_TIMESTAMP(6) was missing when synchronizing structure.
  3. Esc shortcut did not work when error occurred during deleting records.
  4. Error occurred when renaming an existing column and adding a new one.
  5. Filter value did not displayed when the string exceeded 5880 characters.
  6. Unable to display the columns list in Table Designer's Index tab when there was no index.
  7. Unable to apply Filter profile.
  8. Unable to scroll to right in Filter Wizard.
  9. Opening Design Table froze in large database.
  10. "Open Table" and "Design Table" were not properly synchronized.
  11. Import Target and Field Mapping changed after changing the source file in profile.

To upgrade, please visit our Customer Center.

Jul 31 2018
Navicat for MySQL (Windows) version 12.1.5

Improvements:

  1. Improved Filter Wizard.
  2. Supported expression for default field value in Table Designer.

Bug-fixes:

  1. Crashed when applying filter in Foreign Key Selection window.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jul 26 2018
Navicat for MySQL (Windows) version 12.1.4

Main New Features:

  1. Support Roles for MySQL 8
  2. Support Roles for MariaDB 10
  3. Brand new Filter Wizard
  4. UI and UX Improvement
  5. MongoDB is added in Navicat Premium
  6. Navicat for MongoDB is released

To upgrade, please visit our Customer Center.

May 29 2018
Navicat for MySQL (Windows) version 12.0.29

Bug Fixes:

  1. File encoding was incorrect when transferring database to SQL file.
  2. The generated CREATE PROCEDURE statement was incorrect when dumping database to SQL file.
  3. Structure Synchronization detected differences after synchronizing.
  4. Incorrect unique values were imported from .dbf file.
  5. Crashed when saving the modified field names in some cases.
  6. Extra "(" was added to INSERT statements when deploying scripts in Data Synchronization.
  7. Unable to restore LONGTEXT data completely from .psc file.
  8. .ndm file association was not worked.

To upgrade, please visit our Customer Center.

May 8 2018
Navicat for MySQL (Windows) version 12.0.28

Improvements:

  1. Supported to connect MySQL 8 using SHA2 connection.

Bug Fixes:

  1. 80041318 error occurred when saving a task schedule.
  2. The cursor position row moved to the bottom line after saved the procedure/function.
  3. Syntax error occurred when updating MySQL user password.
  4. Transaction did not end after closing the table in some cases.

To upgrade, please visit our Customer Center.

Apr 25 2018
Navicat for MySQL (Windows) version 12.0.27

Bug Fixes:

  1. Unable to transfer objects between different server types by drag-and-drop.
  2. Zero decimal place digits were not displayed in Table Viewer.
  3. Exported SQL file did not have table name when exporting an unsaved query.
  4. Incorrect SQL "ON UPDATE CURRENT_TIMESTAMP(0)" was dumped for MariaDB 5.5 tables.
  5. Unknown Internal Error occurred when importing from ODBC.
  6. Syntax error occurred when importing CSV files in some cases.
  7. Database names were missing in the Drop SQL generated by Structure Synchronization.
  8. Unable to change the Tab Width in Query Editor.
  9. Unable to edit query results when tables had alias.
  10. Procedure parameters were missing in the scripts generated by Structure Synchronization.
  11. Unknown Internal Error occurred when Automation ran.
  12. Unable to transfer tables with HEX format.
  13. Encoding issue of the exported text file.

To upgrade, please visit our Customer Center.

Mar 28 2018
Navicat for MySQL (Windows) version 12.0.26

Bug Fixes:

  1. "Access Violation" error occurred when creating new connections in fresh installed Navicat.

To upgrade, please visit our Customer Center.

Mar 27 2018
Navicat for MySQL (Windows) version 12.0.25

Bug Fixes:

  1. Unable to create a query inside a group.
  2. The color of function keywords did not change according to the Font Color settings in Options.
  3. Column width did not retain after hide and show the column in Table Viewer.
  4. Unable to drag and drop a query into a group in some cases.
  5. Unable to edit query results in some cases.
  6. Unable to disable Foreign Key constraint in Data Synchronization.
  7. Crashed when dumping table to sql file in some cases.
  8. DROP PROCEDURE statements in Structure Synchronization did not include the schema name.
  9. Foreign Key constraint issue in Import Wizard.
  10. Code completion replaced the text after caret.
  11. Exported files or reports were not attached to the notification email.
  12. Keepalive Interval setting attempted to connect continuously even the database was down.
  13. If a query was opened, abnormal behavior happened when closing Navicat.
  14. Automation did not start when the computer was logged out.
  15. Unable to create new table with primary key settings in Import Wizard.

To upgrade, please visit our Customer Center.

Feb 22 2018
Navicat for MySQL (Windows) version 12.0.24

Improvements:

  1. Supported Microsoft Azure Database for MySQL.

Bug Fixes:

  1. Spaces were missing in the SQL exported from Model.
  2. Extra newlines were added to the SQL exported from Model.
  3. "Hourly" option was missing on Task Schedule's Trigger tab.
  4. Wrong datestamp was appended to the exported files.
  5. Slow issue when searching in Table Viewer.
  6. Unable to move functions into a group.
  7. Syntax error occurred when running query in some cases.
  8. Unable to select Enum data in query results.
  9. Target functions/procedures were not dropped before create when synchronizing structure.
  10. Unable to synchronize models/queries in Navicat Cloud.
  11. Exported Excel files were corrupted in some cases.
  12. "Access is denied" error occurred when setting schedule.

To upgrade, please visit our Customer Center.

Jan 22 2018
Navicat for MySQL (Windows) version 12.0.23

Bug Fixes:

  1. Error occurred when synchronizing structure in some cases.
  2. Replace All did not work in Table Viewer.
  3. Cell selection disappeared after pressing CTRL+C in Table Viewer.
  4. Error occurred when running query in some cases.
  5. "Unknown Internal Error" occurred when exporting query results.

To upgrade, please visit our Customer Center.

Jan 15 2018
Navicat for MySQL (Windows) version 12.0.22

Bug Fixes:

  1. Unknown Internal error occurred when editing/adding connections.
  2. Adding self-referencing table issue in Query Builder.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jan 11 2018
Navicat for MySQL (Windows) version 12.0.21

Bug Fixes:

  1. Out of memory issue when running Data Transfer.
  2. "Unknown Internal Error" occurred when loading profiles in Structure Synchronization.
  3. Export Float data to csv files issue.
  4. Syntax error occurred when synchronizing MySQL functions.
  5. Crashed when importing Excel or Text files in some cases.
  6. Opening large databases in List View took long time.
  7. Unable to show query files with ".SQL" extension in Objects tab.
  8. Errors occurred when executing MySQL Dump files.
  9. CTRL+SPACE shortcut were missing in Query Editor.
  10. Print report to PDF command wrongly sent the report to printer.
  11. Null date values were exported wrongly as "1900-01-00" in Excel files.
  12. Tables Viewer displayed wrong number of digits.
  13. Input parameter window did not pop up when exporting query.
  14. High CPU usage issue.

To upgrade, please visit our Customer Center.

Dec 5 2017
Navicat for MySQL (Windows) version 12.0.20

Bug Fixes:

  1. Unable to transfer POINT data type from MySQL to MariaDB.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Dec 1 2017
Navicat for MySQL (Windows) version 12.0.19

Bug Fixes:

  1. Unable to zoom in/out Query Editor using mouse wheel.
  2. Unable to connect Sphinx servers.
  3. Swapping connections did not work when re-comparing in Data Synchronization.
  4. Syntax errors occurred when running query in some cases.
  5. Unknown Internal error occurred when performing Structure Synchronization.
  6. No records was transferred when the target connection was using HTTP Tunnel.
  7. Query syntax highlight was wrong after switching tabs.
  8. DateTime field Not Null checkbox unchecked wrongly in Table Designer.
  9. Unable to export table to xlsx with name longer than 31 characters.
  10. Hanged when searching in Table Viewer in some cases.

To upgrade, please visit our Customer Center.

Nov 13 2017
Navicat for MySQL (Windows) version 12.0.18

Bug Fixes:

  1. The database/schema combo-box did not work in Query.
  2. Manual refresh did not work in Server Monitor when auto-refresh was enabled.
  3. Unknown Internal Error occurred when performing Structure Synchronization.

To upgrade, please visit our Customer Center.

Nov 7 2017
Navicat for MySQL (Windows) version 12.0.17

Bug Fixes:

  1. Fixed exporting numbers to Excel issue.
  2. Fixed importing connections with Settings Location issue.
  3. Fixed ER diagram layout issue.
  4. Table groups were not synchronized to other members in Navicat Cloud.
  5. Add Index statements were generated wrongly when opening Table Designer.
  6. Wrong SQLs were generated when inserting fields in Table Designer.
  7. Unable to run CREATE PROCEDURE statements in Query Editor.
  8. Unable to save function after changing parameter names.
  9. Unable to import DBF files.
  10. Identifiers panel retained when opening new query window.
  11. Access denied error occurred when transferring tables with triggers in some cases.
  12. The Stop button in Export Wizard did not work properly.
  13. Unknown Internal Error occurred when typing in Query Editor.

To upgrade, please visit our Customer Center.

Oct 10 2017
Navicat for MySQL (Windows) version 12.0.16

Bug Fixes:

  1. Structure Synchronization detected differences wrongly in some cases.
  2. Record delimiter was wrong when exporting to text file using Automation.
  3. Table Viewer moved back to the first page when refreshing a table.
  4. Characters displayed wrongly in Table Viewer.
  5. Unable to select fields when exporting to Excel file.

To upgrade, please visit our Customer Center.

Sep 27 2017
Navicat for MySQL (Windows) version 12.0.15

Bug Fixes:

  1. Error occurred when deleting INT field value in Table Viewer.

To upgrade, please visit our Customer Center.

Sep 26 2017
Navicat for MySQL (Windows) version 12.0.14

Bug Fixes:

  1. Wrongly shown differences when synchronizing structure.
  2. The DDL tab in Information pane did not updated after saving changes in sub forms.
  3. Unknown Internal Error occurred when synchronizing structure/data in some cases.
  4. Unable to schedule Data Synchronization profiles.
  5. Syntax error occurred when filtering with ' character in Table Viewer.
  6. Compared table comments in Structure Synchronization.
  7. Input decimal separator issue in Table Viewer.
  8. Unable to import date from Excel to VARCHAR field.
  9. Query Builder loading was slow.
  10. Custom backup file name was ignored when scheduling in Automation.
  11. Re-registration issue.
  12. Unable to create new table in Import Wizard in some cases.

To upgrade, please visit our Customer Center.

Sep 5 2017
Navicat for MySQL (Windows) version 12.0.13

Bug Fixes:

  1. Table triggers was not included when backing up tables.
  2. Auto increment field was ignored when importing
  3. Unable to set the default value of TEXT/BLOB field for MariaDB 10.2.1 or above.
  4. Navicat hanged when running a query export profile in some cases.
  5. Error occurred when running LOAD DATA LOCAL queries.
  6. Special characters were garbled when exporting Access files.
  7. Unknown Internal error occurred when exporting Access files.
  8. Unknown Internal error occurred when saving changes in Table Designer.
  9. "Too many client tasks" error occurred when importing Access files.
  10. Double-quote encased text fields were split into new records when importing a record which multiple lines.
  11. Syntax error occurred when performing data transfer in some cases.
  12. Unknown Internal error occurred when adding multiple records in Table Viewer.
  13. Two identical functions declared as different in Structure Synchronization.

To upgrade, please visit our Customer Center.

Aug 8 2017
Navicat for MySQL (Windows) version 12.0.11

Bug Fixes:

  1. Unable to open Information pane by context menu.
  2. Unable to import fixed width text file in some cases.
  3. Access Violation error occurred when creating models / tables in some cases.
  4. Access Violation error occurred after Navicat was idle.
  5. Unable to import the CDATA data in XML files.
  6. Number values were exported as text in Excel files.
  7. Code completion did not work for alias in SQL Editor.
  8. Beautify SQL did not format multiple statements properly in SQL Editor.
  9. Unknown Internal error occurred when running query with parameters.
  10. Table menu displayed wrong item in some cases.
  11. Unknown Internal error occurred when running old version export profiles in Automation.
  12. Unknown Internal error occurred when opening tables in some cases.
  13. "_Navicat_Temp_Stored_Proc() does not exist" error occurred when saving functions.
  14. High memory usage issue in Data Synchronization.
  15. "Use empty string as NULL" option did not work in Import Wizard.
  16. Unknown Internal error occurred when writing query in some cases.
  17. Unknown Internal error occurred when backup in Automation in some cases.
  18. Hang issue occurred when launching Import Wizard.
  19. Unable to connect with SSL in some cases.

To upgrade, please visit our Customer Center.

Jul 13 2017
Navicat for MySQL (Windows) version 12.0.10

Bug Fixes:

  1. Error occurred when opening MySQL databases in HTTP connection if enabled "Encode outgoing query with base64" setting.
  2. Unable to import Chinese characters from Excel files.
  3. Incorrect date and decimal formats in exported Excel files.
  4. Filter criteria settings were removed when applying sorting on column.
  5. Error occurred when duplicating MySQL tables in HTTP connection.
  6. Unknown Internal Error occurred when executing old version export profiles in Batch Job.
  7. Save dialog did not pop up when closing backup profiles after editing.
  8. Unknown Internal Error occurred when loading Filter profiles in Table Viewer.
  9. File path and file name were not saved in Export profiles.
  10. Unknown Internal Error occurred when there was multiple statements in Query.
  11. Incorrect field names were shown in code completion suggestion list.
  12. Unable to attach the report PDF file in notification email.

To upgrade, please visit our Customer Center.

Jun 28 2017
Navicat for MySQL (Windows) version 12.0.9

Bug Fixes:

  1. "Unknown Internal Error" occurred when typing statement in SQL Editor.
  2. Unable to show field names in data pipeline after editing SQL in Report.
  3. Beautify SQL formatted the statement wrongly in some cases.
  4. Sorting by modified/create date did not work for details view in main window.
  5. Connection coloring displayed wrong color in some cases.

To upgrade, please visit our Customer Center.

Jun 26 2017
Navicat for MySQL (Windows) version 12.0.8

Bug Fixes:

  1. Wrong table showed when comparing tables in Data Synchronization in some cases.
  2. Unable to import special characters from Excel.
  3. Unable to paste multiple records in Table Viewer.
  4. Created Batch Jobs did not show in Standard Edition.
  5. "Unknown Internal Error" occurred when importing files.
  6. View Builder locked up when re-open for editing in some cases.

To upgrade, please visit our Customer Center.

Jun 15 2017
Navicat for MySQL (Windows) version 12.0.7

Bug Fixes:

  1. "Access violation" error occurred when create new query/view.
  2. Enum value drop-down list was missing for MariaDB in Table Viewer.
  3. Wrongly showed primary key warning in some cases.
  4. Unable to type some characters in editor when using international keyboard.
  5. Unable to edit connection settings in some cases.
  6. Information Pane did not appear in some cases.
  7. Internal error occurred when importing CSV files.
  8. Cell values froze when scrolling in grid view.

To upgrade, please visit our Customer Center.

Jun 6 2017
Navicat for MySQL (Windows) version 12.0.6

Bug Fixes:

  1. 1142 error occurred when dumping SQL files.
  2. 1142 error occurred when backing up databases.
  3. Failed to load Data Synchronization profiles.
  4. Data display issues in table viewer.
  5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

May 31 2017
Navicat for MySQL (Windows) version 12.0.5

New Features:

  1. New UI/UX.
  2. On Startup: open favorite tabs automatically when Navicat launches.
  3. Code Snippet.
  4. Advanced Code Completion with better suggestions.
  5. Brand new Structure Synchronization: visually show side-by-side DDL comparison between two databases.
  6. Brand new Data Synchronization: show particular status to distinguish the differences between records easily.
  7. New Automation: easy to find desired profiles and create automated batch jobs.
  8. Responsiveness and performance improved.
  9. Many other new features and improvements.

To upgrade, please visit our Customer Center.

Mar 16 2017
Navicat for MySQL (Windows) version 11.2.16

Bug Fixes:

  1. Error occurred when exporting with Time field type.
  2. "Argument out of range" occurred when running "Reverse Database to Model".
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Dec 22 2016
Navicat for MySQL (Windows) version 11.2.15

Bug Fixes:

  1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Dec 7 2016
Navicat for MySQL (Windows) version 11.2.14

Bug Fixes:

  1. Unable to show some errors in MySQL Console.
  2. Crashed when using Query in some cases.
  3. Query auto-save feature did not work in some cases.

To upgrade, please visit our Customer Center.

Oct 31 2016
Navicat for MySQL (Windows) version 11.2.13

Bug Fixes:

  1. Error occurred when getting MySQL query status.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Oct 24 2016
Navicat for MySQL (Windows) version 11.2.12

Bug Fixes:

  1. MySQL floating point fields were exported to decimal values.
  2. Error occurred when profiling query with sql_mode "ONLY_FULL_ GROUP_BY" for MySQL 5.7.5 or above.
  3. Fixed the sorting issue in Table Viewer.

To upgrade, please visit our Customer Center.

Aug 3 2016
Navicat for MySQL (Windows) version 11.2.11

Bug Fixes:

  1. Copy and paste issue in Table Viewer's Memo Editor.

To upgrade, please visit our Customer Center.

Jun 15 2016
Navicat for MySQL (Windows) version 11.2.10

Improvements:

  1. Support inputting tabs in the editor of Table Designer.
  2. Support UTF16 formatted files in Execute SQL File and Query's Import SQL functions.

Bug Fixes:

  1. The media keys (play, pause, next etc) did not work.
  2. Unable to connect MariaDB 5.5 with SSL.
  3. Failed to transfer data in Chinese locale OS.
  4. Foreign keys check SQL was missing at the end of the dumped SQL file.
  5. Crashed when synchronizing model to database in some cases.
  6. Unable to show the light coloring when the tab is non-active.

To upgrade, please visit our Customer Center.

May 10 2016
Navicat for MySQL (Windows) version 11.2.9

Bug Fixes:

  1. The datetime field values were inconsistent in exported file.

To upgrade, please visit our Customer Center.

Apr 29 2016
Navicat for MySQL (Windows) version 11.2.8

Bug Fixes:

  1. Unable to set "On Update Current_Timestamp" setting in some cases for MySQL version 5.6.5 or above.
  2. Unable to add tables to Report's Query Wizard and Query Designer when the table name contained dot.
  3. Error occurred when logging in Navicat Cloud if profile path contained Unicode.

To upgrade, please visit our Customer Center.

Mar 30 2016
Navicat for MySQL (Windows) version 11.2.7

Bug Fixes:

  1. Fixed multi-monitor with different dpi issue.
  2. Column import definition broken when importing.
  3. Saved Import profile mapped columns wrongly.
  4. "invalid varient operation" error occurred when import from ODBC.
  5. "Argument out of range" error occurred when importing CSV file.
  6. Primary Key settings were deleted when modifying import profile.

To upgrade, please visit our Customer Center.

Mar 1 2016
Navicat for MySQL (Windows) version 11.2.6

Improvements:

  1. Support field type JSON in MySQL 5.7.8 or above.

Bug Fixes:

  1. Errors occurred when running LOAD DATA LOCAL queries in 64-bit version.
  2. Error "Diagram table already exists" occurred when opening some model files.
  3. Crashed when exporting connections.
  4. "Access violation" error occurred when importing CSV file.

To upgrade, please visit our Customer Center.

Jan 15 2016
Navicat for MySQL (Windows) version 11.2.5

Bug Fixes:

  1. "Stop" button was not working in Query.
  2. Unable to edit the query in Query Editor when running it.
  3. Error occurred when running LOAD DATA LOCAL queries.

To upgrade, please visit our Customer Center.

Dec 14 2015
Navicat for MySQL (Windows) version 11.2.4

Bug Fixes:

  1. Schedule and Command Line stopped working when user did not sign in Navicat Cloud.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Dec 11 2015
Navicat for MySQL (Windows) version 11.2.3

Bug Fixes:

  1. "Argument out of range" error occurred when using "Find in Database/Schema".
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Dec 10 2015
Navicat for MySQL (Windows) version 11.2.2

Major New Features:

Navicat Cloud Collaboration

  1. Create/Modify/Delete projects.
  2. Add members to project for sharing connection settings, queries and models.
  3. View Project Activity Log.

Data Modeling Tool

  1. Support Model Conversion.
  2. Support Views.
  3. Enhanced Table Designer.

Others

  1. Enhanced Connection Coloring.
  2. Search database object structure.

To upgrade, please visit our Customer Center.

Aug 3 2015
Navicat for MySQL (Windows) version 11.1.13

Bug Fixes:

  1. Exported result incorrect for TIME field type in Export Wizard.
  2. File name with appended timestamp issue in Export Wizard.
  3. Slow performance when showing/hiding column with Memo editor opened.
  4. SSH protocol error issue.

To upgrade, please visit our Customer Center.

May 20 2015
Navicat for MySQL (Windows) version 11.1.12

Bug Fixes:

  1. Generated object SQL identifier without escaping quote characters in Model.
  2. Unable to load the virtual group settings file created by old versions of Navicat.
  3. After sorted a selected column in Table Viewer, access violation occurred when resizing column width.

To upgrade, please visit our Customer Center.

Apr 20 2015
Navicat for MySQL (Windows) version 11.1.11

Improvements:

  1. Reset the field length to default value after changing the auto guessed field type in Table Designer.

Bug Fixes:

  1. Access violation error occurred when entering SQL in Query.
  2. Cannot access field 'Super_priv' as type Boolean error occurred when managing Users.
  3. Unable to download source files with HTTPS connection in Import Wizard.
  4. Failed to create/edit users for MySQL 5.7.6.

To upgrade, please visit our Customer Center.

Mar 12 2015
Navicat for MySQL (Windows) version 11.1.10

Improvements:

  1. Improved the Message Log information.

Bug Fixes:

  1. Table Designer did not allow to edit MySQL table partition’s Values setting.
  2. Unable to identify equality of trigger definitions with different system line breaks in Structure Synchronization.
  3. Unable to generate MySQL table SQL with charset binary properly in Structure Synchronization.
  4. Code Completion added smart quote wrongly for utc_date() in Query Editor.
  5. Unable to convert object names in Data Transfer when using Schedule.
  6. Unable to transfer MariaDB triggers in Data Transfer.

To upgrade, please visit our Customer Center.

Jan 20 2015
Navicat for MySQL (Windows) version 11.1.9

Bug Fixes:

  1. Unable to run in Windows Server 2003.
  2. Fixed the color issue in the connection tree.
  3. Wrong handling for field type BIT.

To upgrade, please visit our Customer Center.

Dec 9 2014
Navicat for MySQL (Windows) version 11.1.8

Improvements:

  1. Allow copying field names in Table Viewer and Query's Result.

Bug Fixes:

  1. "Argument out of range" error occurred after running MySQL/MariaDB queries in Query.
  2. Crashed after multiple drag & drop tables in Model Designer.

To upgrade, please visit our Customer Center.

Dec 2 2014
Navicat for MySQL (Windows) version 11.1.7

Improvements:

  1. Error counting in Data Transfer's Message Log changed from records to records and objects.

Bug Fixes:

  1. Structure Synchronization was unable to compare the difference between Null and empty default value for MySQL/MariaDB fields.
  2. Unable to select new mode in connection tree using Alt+MouseDown.
  3. Access Violation error occurred when exporting single column to Word.
  4. Duplicated foreign key names issue in Model.
  5. Unable to recognize the Row Delimiter when importing from CSV files.
  6. Import Wizard was unable to import currency data from DBF files.
  7. Advanced settings were saved incorrectly in Data Transfer profiles.

To upgrade, please visit our Customer Center.

Sep 18 2014
Navicat for MySQL (Windows) version 11.1.6

Bug Fixes:

  1. Synchronized Navicat Cloud model files even they did not have any changes.

To upgrade, please visit our Customer Center.

Sep 15 2014
Navicat for MySQL (Windows) version 11.1.5

Improvements:

  1. Added Open Containing Folder feature for Query, Report, Backup and Model.
  2. Added Open with External Editor feature for Query.
  3. Added press and hold Alt key and double-click table to open Table Design.

Bug Fixes:

  1. Failed to dump SQL file from Navicat Cloud connection.
  2. Unable to select foreign key for new table in Table Design.

To upgrade, please visit our Customer Center.

Sep 1 2014
Navicat for MySQL (Windows) version 11.0.19

Bug Fixes:

  1. Unable to set default value to empty string for columns with SET data type in Table Design.
  2. Data started with single quote issue in exported Excel file.

To upgrade, please visit our Customer Center.

Aug 25 2014
Navicat for MySQL (Windows) version 11.1.3

New Features:

  1. Support to sync selected connection settings, queries, model files and virtual group information to Navicat Cloud. For more information, please visit here.

Improvements:

  1. Support parameter in Report command line.
  2. Support adding shapes in Model.

To upgrade, please visit our Customer Center.

May 21 2014
Navicat for MySQL (Windows) version 11.0.18

Improvement:

  1. Query profile now support to show in server level.

Bug Fixes:

  1. Unable to save local file if database name contained heading/tailing space.
  2. Crashed when loading and parsing a long incorrect syntax SQL in Query.
  3. After adding a new row, pressing next/last button would freeze the Form View in Table Viewer.
  4. Number of rows selected incorrectly when using shift+up/down keys in Table Viewer.
  5. Multiple selection not working properly with shift+keys in Table Viewer.
  6. When using CTRL+A to select text inside a data cell, all cells were incorrectly selected in Table Viewer.
  7. Import Paradox not able to import data properly in Navicat 64bits.
  8. Backup not able to backup table with foreign key.
  9. Wrong NullsOrder setting was shown for foreign key fields under Table Designer in Data Modeling Tool.
  10. Wrong CREATE TABLE SQL with character set and comment exported under Export SQL in Data Modeling Tool.

To upgrade, please visit our Customer Center.

Feb 25 2014
Navicat for MySQL (Windows) version 11.0.17

Improvement:

  1. Table Viewer is now able to update a row even not all the keys are input for numeric columns.
  2. Always import as NULL value if "Use empty string as NULL" option is checked in Import Wizard.
  3. All records are now able to show under the Fixed Width window in step 3 of Import Wizard.

Bug Fixes:

  1. 'Control 'Dock2Form_1' has no parent window' error occured while docking in and out of windows.
  2. Connection was deleted after renamed to capitalized name.
  3. Foreign key information with two words identifier not able to get correct correctly in Table Designer.
  4. Foreign key information with NDB cluster storage engine not able to get correctly in Table Designer.
  5. Parameter list not able to show in Function Designer when there was CHARACTER type in function parameters.
  6. 'Table does not exist' error occured while opening an export profile.
  7. Server with unsaved password not able to connect under 'Import from Database' in Data Modeling Tool.

To upgrade, please visit our Customer Center.

Jan 9 2014
Navicat for MySQL (Windows) version 11.0.16

Improvements:

  1. Added Dynamic Column Editor for MariaDB in Table Viewer.

Bug Fixes:

  1. Lose focus in Table Viewer.
  2. Function parser error.
  3. Access Violation error occurred when designing MariaDB tables with foreign keys.
  4. Access Violation error occurred when importing invalid connections.
  5. ERegistry Exception error occurred when starting Navicat.
  6. Wrong Date Editor frame size in Table Viewer.
  7. Stack Overflow error when running Query.
  8. Data Synchronization failed when MySQL or MariaDB table has multi-fields Primary Key.
  9. Permissions issue of the Updater.
  10. Cursor was missing in Stored Procedure.
  11. Failed to create MySQL user with special characters password.

To upgrade, please visit our Customer Center.

Nov 13 2013
Navicat for MySQL (Windows) version 11.0.12

Bug Fixes:

  1. Wrong handling on Integer type.
  2. Changed properties not check properly in Table Designer.

To upgrade, please visit our Customer Center.

Nov 8 2013
Navicat for MySQL (Windows) version 11.0.11

Bug Fixes:

  1. Missed to mark quotation on keywords in Query Builder.
  2. Process was unable to stop while running query in Essentials version.
  3. Failed to include auto increment column setting for floating point data types.
  4. Access Violation occured when executing query clause with 'GROUP BY _xxx, _yyy'.

To upgrade, please visit our Customer Center.

Sep 10 2013
Navicat for MySQL (Windows) version 11.0.10

Bug Fixes:

  1. Failed to show definition/DDL for View.
  2. Failed to check/uncheck column fields in Show/Hide Columns using space key in Tabler Viewer.
  3. Failed to scroll horizontally for wide content after applying Filter Wizard in Table Viewer.

To upgrade, please visit our Customer Center.

Aug 7 2013
Navicat for MySQL (Windows) version 11.0.9

Bug Fixes:

  1. Access violation occured in 64-bit scintilla (Text Editor) after Navicat used huge memory (>4G).
  2. Access violation occured while copying and pasting field in Table Designer.
  3. No respond from Filter Wizard in Table Viewer after execution error of filter query.
  4. Failed to replace text with an empty string using the Find and Replace feature.
  5. Fixed the scrolling issue in docking window on secondary display.
  6. Failed to display unicode user name and organization in Navicat About box.

To upgrade, please visit our Customer Center.

Jul 3 2013
Navicat for MySQL (Windows) version 11.0.8

Bug Fixes:

  1. Default value could not be kept longer than 255 characters in Table Designer.
  2. Column width not able to be reset after showing the hidden column in Table Viewer.
  3. Access violation occured in Table Viewer while reconnecting SSH connection with another port.
  4. Query message in status bar not updated if no result return after Run.
  5. Fixed concat string (with date) in Query.
  6. Access violation occured when entering query clause with 'GROUP BY _xxx, _yyy'.

To upgrade, please visit our Customer Center.

May 27 2013
Navicat for MySQL (Windows) version 11.0.7

Bug Fixes:

  1. Key was rejected for SSH connection.
  2. Access violation occured while running report in command line.
  3. Losing searched position in Memo editor after first searching or clicked into the Memo editor.
  4. Fixed query parser error.
  5. Invalid relation cardinality not showed in red color in Data Modeling Tool.

To upgrade, please visit our Customer Center.

May 9 2013
Navicat for MySQL (Windows) version 11.0.6

Bug Fixes:

  1. Fixed "Keyboard Interactive Failed" error for SSH tunnel connection.
  2. Crashed while using SSH tunnel connection for both source and target servers in Data Transfer.
  3. "Access violation" error occurred while entering query clause with 'ORDER BY _xxx ASC/DESC' in Query.
  4. Notification email not sent with an unsaved batch job.

To upgrade, please visit our Customer Center.

Apr 30 2013
Navicat for MySQL (Windows) version 11.0.5

Major New Features:

Native 64-bit version

Interface

  1. New User Interface
  2. Aero Snap with new docking system

Connection

  1. New SSH Manager
  2. Connection Tree Filter

Table Viewer

  1. Find and Replace data
  2. Box Selection
  3. Multi-Cell Editing
  4. Search Columns
  5. Web Viewer
  6. Memo Editor with syntax highlight
  7. Support Transaction
  8. Support animated gif in Image viewer
  9. Copy data as INSERT/UPDATE statement

Table Designer

  1. Search Columns
  2. Field Type Prediction

Query

  1. Enhanced Query Builder

Import Wizard/Export Wizard

  1. JSON file
  2. CSV file
  3. Improved binary data handling

Report

  1. Enhanced PDF printing

Others

  1. New Registration and Activation System
  2. New Updater

To upgrade, please visit our Customer Center.

Feb 4 2013
Navicat for MySQL (Windows) version 10.1.8

Bug Fixes:

  1. "Access violation" error occurred while applying an existing table name on a new table in Data Modeling Tool.

To upgrade, please visit our Customer Center.

Dec 11 2012
Navicat for MySQL (Windows) version 10.1.7

Improvement:

  1. Support fractional seconds precision of time, datetime, timestamp data types for MySQL 5.6.4/MySQL MariaDB 5.3 or above.
  2. The Profile tab under Query is now displayed without sorting.
  3. Support date time format 2012-12-31T01:02:03.456 in Import Wizard.
  4. Support fractional seconds precision of time, datetime, timestamp data types for MySQL 5.6.4 or above under Synchronize to Database function in Data Modeling Tool.
  5. Support to ignore comparing DEFINER clause of view, event, trigger, procedure and function in Structure Synchronization.

Bug Fixes:

  1. Create function statement which was after DELIMITER change statement was unable to be executed in Query.
  2. "List index out of bounds" error occurred when some source fields were removed after import profile were created during Import Wizard.
  3. Binary data from Access/ODBC was imported incorrectly during Import Wizard.
  4. Synchronize to Database function in Data Modeling Tool genarated incorrect comparison result for equivalent source and target foreign keys.
  5. Records were unable to generate for Federated table in Dump SQL File and Data Transfer.

To upgrade, please visit our Customer Center.

Sep 19 2012
Navicat for MySQL (Windows) version 10.1.6

Improvement:

  1. Added data format options for XML file in Export Wizard.

Bug Fixes:

  1. Wrong time unit (ms) was shown under Messages tab in Query function.
  2. Table Designer in Data Modeling Tool was unable to save newly added index and foreign key.
  3. Synchronize to Database function in Data Modeling Tool was unable to generate the referencing table schema name in the SQL scripts.

To upgrade, please visit our Customer Center.

Aug 23 2012
Navicat for MySQL (Windows) version 10.1.5

Bug Fixes:

  1. Empty named relation was unable to load back in Data Modeling Tool.
  2. Unable to generate sync queries for fields with auto increment and primary key in Data Modeling Tool.
  3. "Access violation" error occurred while opening "Import from Database" form in Data Modeling Tool.

To upgrade, please visit our Customer Center.

Jul 27 2012
Navicat for MySQL (Windows) version 10.1.3

Bug Fixes:

  1. Minimized docked window could not restore normally.

To upgrade, please visit our Customer Center.

Jul 19 2012
Navicat for MySQL (Windows) version 10.1.2

Improvement:

  1. Added font selection in Option for ER Diagram.

Bug Fixes:

  1. 1064 error occured when running Store Procedure.

To upgrade, please visit our Customer Center.

Jul 6 2012
Navicat for MySQL (Windows) version 10.1.1

Bug Fixes:

  1. If the table contained many columns, new column would be inserted to wrong position in Table Designer (Data Modeling Tool).

To upgrade, please visit our Customer Center.

Jun 15 2012
Navicat for MySQL (Windows) version 10.1.0

Improvements on Data Modeling Tool:

  1. Support Unsigned for Numeric Type.
  2. Support Auto Increment for Integer Type.
  3. Build model with multiple schemas.
  4. New wizard "Import from Database".
  5. New wizard "Synchronize to Database".
  6. Search filter.
  7. Align/Distribute diagram objects.

To upgrade, please visit our Customer Center.

Mar 28 2012
Navicat for MySQL (Windows) version 10.0.11

Bug Fixes:

  1. Data truncated when exporting pdf file from Report Builder.
  2. Navicat got hanged while performing a search in Table Viewer.
  3. Incorrect excel file format was exported while having data started with 0 in Export Wizard.
  4. Copy and paste was not working on index in Table Designer.

To upgrade, please visit our Customer Center.

Jan 31 2012
Navicat for MySQL (Windows) version 10.0.10

Improvement:

  1. Import speed has been improved in Import Wizard.
  2. Export speed has been improved in Export Wizard.

Bug Fixes:

  1. Navicat generated 'Not Implemented' error when running under replacement shell UI.

To upgrade, please visit our Customer Center.

Jan 4 2012
Navicat for MySQL (Windows) version 10.0.9

Bug Fixes:

  1. While scrolling index fields, the scrolled position could not be reflected in Table Designer.
  2. Table Designer generated incorrect SQL statement in field ordering.
  3. The comparison in columns ordering were generated incorrectly in Structure Synchronization, and Synchronize to Database in Modeler.
  4. Extra SET FOREIGN_KEY_CHECKS queries were generated even if the comparison results were identical in Structure Synchronization.
  5. Crash occurred when closing Synchronize to Database in Modeler during the comparison in progress.
  6. Crash occurred while renaming table failed with server error in ER-diagram view.
  7. Data Transfer would hang in Navicat Scheduler.

To upgrade, please visit our Customer Center.

Nov 24 2011
Navicat for MySQL (Windows) version 10.0.8

Improvement:

  1. Enhanced Model transformation.

Bug Fixes:

  1. "Access violation" error occurred when dragging n dropping a server node in connection tree together with the Model/Schedule object pane were opened.
  2. When created a virtual group in the connection tree, it would be added under Model/Schedule object pane while they were opened.

To upgrade, please visit our Customer Center.

Nov 14 2011
Navicat for MySQL (Windows) version 10.0.7

Improvement:

  1. Source field order is now kept in target table after running "Synchronize to Database".

Bug Fixes:

  1. Incorrect field type showed in ER Diagram.
  2. Fixed-width and row delimiter were unable to retrieve from a profile in Import Wizard.
  3. Print report to PDF file would generate a blank file.
  4. Non-latin characters with different collation columns were unable to search in "Find in Database" feature.

To upgrade, please visit our Customer Center.

Oct 17 2011
Navicat for MySQL (Windows) version 10.0.6

Improvement:

  1. Support column comment up to 1024 characters for MySQL 5.5.3.
  2. Support table comment up to 2048 characters for MySQL 5.5.3.

Bug Fixes:

  1. Data Modeling Tool was unable to set the reference field of foreign key.
  2. Data Modeling Tool was unable to print with landscape page setting.
  3. When importing data from an URL, it failed to create a temporary file if the same temporary file was being accessed.
  4. Tables contained geometric point data was failed in Data Transfer and Data Synchronization.
  5. Restore didn't work with the .pmb file created from Navicat version 5.
  6. Connection Information could not display properly in large font size.
  7. Default value of bit field was shown incorrectly in Table Viewer.

To upgrade, please visit our Customer Center.

Sep 19 2011
Navicat for MySQL (Windows) version 10.0.5

Improvements:

  1. Improved performance of "Reverse Database to Model" and "Reverse Tables to Model.
  2. Foreign Keys is now able to be imported into Model.
  3. Spacing issue has been improved in Beautify SQL.

Bug Fixes:

  1. Import from paradox file was unable to get signed short integer values.
  2. User Privileges typo was fixed.

To upgrade, please visit our Customer Center.

Sep 12 2011
Navicat for MySQL (Windows) version 9.1.12

Improvements:

  1. Indexes is now included in Create Table during Data Transfer.

Bug Fixes:

  1. The highlighted items from the previous searching results in Table Designer was failed to clear for the next searching.
  2. Foreign key was unable to be created in Table Designer when referencing a destination field requiring index.
  3. Default scale of 4 was applied when encountering currency data during the Import of Access file.
  4. "SET FOREIGN_KEY_CHECKS=1" did not generate while running Structure Synchronization.

To upgrade, please visit our Customer Center.

Sep 6 2011
Navicat for MySQL (Windows) version 10.0.3

Major New Features:

  1. Data Modeling Tools.
  2. ER Diagram view.
  3. SQL Minifier.
  4. Database Wide Search.

Improvements:

  1. Ability to run transaction backup for MySQL database (InnoDB only).
  2. Added object list in Query Editor.
  3. Added DDL tab in Object Information.

To upgrade, please visit our Customer Center.

Jun 1 2011
Navicat for MySQL (Windows) version 9.1.11

Improvements:

  1. Added Ctrl+a as shortcut key for "select all" in Form View.

Bug Fixes:

  1. Wrong table would be copied while running "Duplicate Table" function.
  2. Object Information was unable to be refreshed when under "List" view mode.
  3. Foreign Key Check box under Table Designer was unable to be toggled using space bar.
  4. Searching in Table Viewer would freeze when no record showed on the existing view.

To upgrade, please visit our Customer Center.

Apr 11 2011
Navicat for MySQL (Windows) version 9.1.10

Bug Fixes:

  1. Scroll bar in Trigger Definition editor was missing.
  2. Object List frozen.
  3. The size of the width in Run Result columns were too large in Stored Procedure form.
  4. "Grid index out of range" error occured while refreshing in Table Viewer.
  5. Connection combo box showed wrongly in Data Synchronization.
  6. Query was unable to execute a SQL containing DROP statement inside Create Statement.

To upgrade, please visit our Customer Center.

Feb 21 2011
Navicat for MySQL (Windows) version 9.1.9

Improvements:

  1. Added "Grant All", "Revoke All" etc in Server Privileges tab of User Designer.

Bug Fixes:

  1. Imported text-based file with UTF-8 encoded data to blob field incorrectly.
  2. "Use empty string as NULL" option while importing from XLS/XLSX formats is now working correctly.
  3. Procedure/Function Designer was unable to get the body part correctly.
  4. Failed to run multiple Data Synchronization at the same time.
  5. Table with identity fields was not working correctly in Data Synchronization.
  6. Invalid pointer error would occur after editing procedure/function during Structure Synchronization.

To upgrade, please visit our Customer Center.

Jan 17 2011
Navicat for MySQL (Windows) version 9.1.8

Improvements:

  1. Improved sorting order in Connection Tree and Object list.

Bug Fixes:

  1. Table Designer was unable to handle field insertion.
  2. Table Designer was unable to insert a field as first since Navicat modifies the second field to reference the not yet inserted field.
  3. Table Designer now supports primary key fields ordering.
  4. Table Designer was unable to show/edit trigger definition.

To upgrade, please visit our Customer Center.

Jan 12 2011
Navicat for MySQL (Windows) version 9.1.7

Improvements:

  1. Improved the compatibility of third party plugin (eg. Ultramon, Hardcopy etc).

Bug Fixes:

  1. Multiple files with files delimited as '|' were unable to be recognized during Import Wizard.
  2. Function Designer was unable to show definition for function with certain return types.

To upgrade, please visit our Customer Center.

Dec 28 2010
Navicat for MySQL (Windows) version 9.1.6

Bug Fixes:

  1. Tree node was unable to be highlighted when Connection Coloring feature was applied under Windows XP.
  2. DBF character field length would be set to 254 if table field length is 0 while exporting to DBF file.

To upgrade, please visit our Customer Center.

Dec 14 2010
Navicat for MySQL (Windows) version 9.1.5

Bug Fixes:

  1. Function/Procedure Designer was unable to show object body contents with RETURNS text as CHARSET and RETURNS ENUM/SET data type.
  2. Function/Procedure Designer was unable to show object body contents with argument of ENUM/SET data type.
  3. Query Builder was unable to recognize identifier starting with numbers, e.g. 123xyz.
  4. Wrong parenthesis generation in Query Builder when new table was added to FROM clause of query like e.g. select ... from (t1 join t2 on a=b).
  5. Code Completion did not work properly with field name if tables were from different database.
  6. Exported data (string) to Excel file did not work properly, e.g. value of '1E' would being exported as 1.

To upgrade, please visit our Customer Center.

Nov 30 2010
Navicat for MySQL (Windows) version 9.1.3

Bug Fixes:

  1. Data was truncated with VARCHAR as data type.

To upgrade, please visit our Customer Center.

Nov 25 2010
Navicat for MySQL (Windows) version 9.1.2

Major New Features:

  1. Support of MySQL Server 5.5.
  2. Support of geometry data type.
  3. Support BTREE and HASH index methods.
  4. New Privilege Manager.
  5. Enhanced User Management.
  6. Data Synchronization performance improved with new engine.
  7. Connection Coloring.

To upgrade, please visit our Customer Center.

Oct 4 2010
Navicat for MySQL (Windows) version 9.0.15

Bug Fixes:

  1. "700 - Invalid response: 403" error occured when using HTTP tunnel connection.
  2. "Out of memory" error occured when running a long SQL in Query function.
  3. "Access violation" error occurred when running an invalid SQL syntax in Query function e.g. SELECT DBMS_OBFUSCATION_TOOLKIT.MD5 (input_string=>'1') FROM DUAL.
  4. Result form showed in Query Editor would be closed after a new query was run.
  5. Beautify SQL returned an invalid SQL syntax, e.g. formatted xxx@yyy into xxx @ yyy.
  6. "Cannot call Start on a running or suspended thread" error occured when exporting tables with mutli resultsets.

Upgrade Procedure : click here to upgrade

Sep 15 2010
Navicat for MySQL (Windows) version 9.0.14

Bug Fixes:

  1. When pasting an enum type value using CTRL+V in Tabler Viewer, the drop down list box would be shown in wrong position.
  2. "Access violation" error occurred when running an invalid SQL syntax in Query Builder, e.g. select ... from ,table01.
  3. Imported string data as blob data incorrectly to database using Import Wizard.
  4. In Structure Synchronization, when the queries generated in the "Queries for Modification" list were too long (e.g. 8000 characters), the whole line would become blank.
  5. Field names for some tables with special names were unable to be listed in Report Builder.

Upgrade Procedure : click here to upgrade

Aug 30 2010
Navicat for MySQL (Windows) version 9.0.13

Improvements:

  1. Horizontal scrollbar is now reset to the left position after applying Beautify SQL feature.

Bug Fixes:

  1. "Access violation" error sometimes occurred when running an invalid SQL syntax in Query Editor.
  2. "Access violation" error occurred when running union/join/inner query in Query Editor.

Upgrade Procedure : click here to upgrade

Aug 2 2010
Navicat for MySQL (Windows) version 9.0.12

Bug Fixes:

  1. Brackets in FROM clause could not be parsed between Query Editor and Query Builder.
  2. When exporting numeric data with comma as decimal seperator to access file, the numbers were displayed without the comma.
  3. When exporting numeric data to excel file, it would be exported as string type.
  4. Sort by time could not work properly in Server Monitor.
  5. Process ID became negative value in Server Monitor.

Upgrade Procedure : click here to upgrade

Jul 15 2010
Navicat for MySQL (Windows) version 9.0.11

Bug Fixes:

  1. "Access Violation" error occured when printing database/table structure to PDF, HTML etc.
  2. "Open Table (Quick)" could not work properly in some machines issues.
  3. "List Index our of bounds (58)" error occured when trying to enter/edit SQL in query Definition tab.
  4. Foreign Key link position in Visual Builder were not accurate enough.
  5. Fixed "mysql.proc" error occured in Table Designer.
  6. Fixed bug when parsing FROM clause with brackets in Visual Builder, e.g. select ... from ((...)).
  7. Codepage problem in Data Transfer feature.
  8. Server Monitor would crash if being opened for a while.
  9. The info column in Server Monitor only showed (WIDEMEMO).
  10. Database/table Privileges were unable to show with uppercase names.

Upgrade Procedure : click here to upgrade

Jun 23 2010
Navicat for MySQL (Windows) version 9.0.10

Improvements:

  1. Structure Synchronization will now not compare MySQL table comment.

Bug Fixes:

  1. Auto-reconnection did not work on SSH tunnel connection to MySQL server.
  2. Fixed the unicode display problem on Text field with MySQL 4.0 or below.
  3. Beautify SQL would cause error if extra spaces existed in aggregate function.
  4. Fixed error when importig XML files from the Interent.
  5. When exported data to Excel spreadsheet, string start with zero (e.g. 009123) would be changed to integer (9123).
  6. "Access Violation" error occured in Manage User when MySQL user did not have enough privilege.
  7. "Ask to save new queries" in Options would be reset to unchecked after Navicat restarted.

Upgrade Procedure : click here to upgrade

Jun 8 2010
Navicat for MySQL (Windows) version 9.0.9

Bug Fixes:

  1. "700 - Invalid response: 417" error occured when connecting to server over HTTP Tunnel.
  2. "Duplicate name 'Field11' in TFieldDefs" error occured if a table contained more than 11 fields in which the first ten field names include "Field1".
  3. Tab order in Import Wizard was set up incorrectly.

Upgrade Procedure : click here to upgrade

May 31 2010
Navicat for MySQL (Windows) version 9.0.8

Improvements:

  1. Added more popup option for Where and Having clauses in Query Builder.

Bug Fixes:

  1. In Navicat main, View -> Sort did not work properly.
  2. In Navicat main, copying action would not work properly after certain user actions.
  3. In Navicat main, Window -> Next Window did not work properly.
  4. When adding new field and tabbing across cloumns in Table Designer, bule hash would appear at the end of the columns.
  5. When tabbing betweem columns in Table Deisgner, some columns would be skipped.
  6. Beautify SQL feature did not compatible with Navicat Query Parameter syntax, so that error would occur when running the parameter query.

Upgrade Procedure : click here to upgrade

May 17 2010
Navicat for MySQL (Windows) version 9.0.7

Improvements:

  1. Improved virtual grouping rename issue - e.g. group like "ITem" and it didn't allow to change into "Item".
  2. Changed to use Ctrl+MouseWheel instead of LeftClick+MouseWheel for zoom in/out function in Query Editor.
  3. Query Builder is now able to handle incomplete SQL statement when switching between Query Editor and Query Builder.
  4. SELECT clause is now able to be generated when dragging a table to Query Builder without selecting any columns, and switching to Query Editor.
  5. Improved export data to excel spreadsheet - number/float data is now being export to number format instead of string format.
  6. Widen the width of the saved profiles list under Data Transfer and Data/Structure Synchronization windows.
  7. Added shortcuts for Structure Synchronization - [ctrl+a] to select all scripts, [ctrl+c] to copy selected scripts, right click the popup menu to copy the selected scripts.

Bug Fixes:

  1. Access Violation error occured when exporting chart report to excel file.
  2. "1054 unknown column error" occured when updating or inserting a record in MySQL View that has Alias names in the Select statement.
  3. The automatic word wrap in TEXT fields not working properly in Form View.
  4. "Navicat is not able to prase SQL" error occured in Query Editor.
  5. Navicat freezed when applying "Beautify SQL" on some SQL statements.

Upgrade Procedure : click here to upgrade

May 10 2010
Navicat for MySQL (Windows) version 9.0.6

Bug Fixes:

  1. When unchecked MySQL "Include other table options" in Data Transfer, engine/table type, character set, auto increment settings were not transferred properly.
  2. The font size used in Query grid was smaller than in View grid.
  3. "Set Display Format" option in Table Viewer did not work in numerical field.
  4. Fixed the wrong positioning issue of main menu items.
  5. MySQL character set/collation type issue in Query Builder or View Builder.

Upgrade Procedure : click here to upgrade

May 3 2010
Navicat for MySQL (Windows) version 9.0.5

Improvements:

  1. Improved the performance for opening Table Viewer with huge amount of columns.

Bug Fixes:

  1. When selecting a particular entry in an enum select box by typing the first letters of the item, the wrong value would be saved if confirmed the changes using the check mark.
  2. When applied "Auto save" function, recover window would not launched if multiple Navicat instances started.
  3. "Access violation" error occured when creating function using Function wizard.
  4. "Not enough storage is available to complete this operation" error occured when exporting field values start with "=" to Excel file.
  5. Fixed the drag & drop problem on Select, Where, Group By, Having, Order By, Limit regions in Query Builder.
  6. When trying to determine if the dataset were editable in Query, error would occur if user contained privilege on View, but did not have select privilege for Table.
  7. Error would occur when switching between Query Editor and Query Builder with MySQL INTERVAL clause included.
  8. "Access violation" error occured for code/word completion feature.

Upgrade Procedure : click here to upgrade

Apr 26 2010
Navicat for MySQL (Windows) version 9.0.4

Improvements:

  1. Better handle case sensitive of object identifier for Query Builder.
  2. Support "select ... from ... group by left(..., ...)" when switching from Query Editor to Query Builder.
  3. Improved keywords list for Code/Word Completion.
  4. Attached hot keys to the navigation bar in Table Viewer.

Bug Fixes:

  1. Toolbar buttons did not refresh after maximized/minimized and changed size of panes.
  2. Toolbar would blink when toggling taskbar auto hide option.
  3. Incompleted Stored Procedure SQL statement showed in Stored Procedure Designer.
  4. When sweithed between Query Builder ad Query Editor, ";" would be inserted into the middle of the statement.
  5. Auto-increment and character set would not be transtered during Data Transfer function.
  6. "Select All" and "UnSelect All" buttons missing in Data Synchronization window.

Upgrade Procedure : click here to upgrade

Apr 12 2010
Navicat for MySQL (Windows) version 9.0.3

Main New Features:

  1. Import/Export connection.
  2. Significant Improvements made in code/word completion.
  3. Code Folding.
  4. Matched Brace/Bracket Highlighting.
  5. Parameter Tips.
  6. Zoom In/Out for SQL editors.
  7. SQL Beautifier.
  8. Favorites.
  9. Object Filter.
  10. Individual database objects backup.
  11. Unicode Character Report.
  12. Auto save in Query, Function etc.
  13. Custom sort in Tabler Viewer.
  14. Significant Improvements made in editor and data grid searching.
  15. Notification email supports SSL/TLS in Schedule.
  16. History Log Viewer.

Upgrade Procedure : click here to upgrade

Feb 24 2010
Navicat for MySQL (Windows) version 8.2.20

Improvements:

    In Table Viewer, MySQL Limit clause will now exclude from the Update/Delete statement if primary key does not exist.

Bug Fixes:

  1. Collations could not be changed for MySQL 4.1.
  2. When altered MySQL View definer, wrong quoting applied.
  3. Word Wrap status did not save in the Query Editor.
  4. "Access violation" error occured when adding "Order By" or selecting any fields after "Select * from table" being run several times in Query Builder.
  5. When import from ODBC with empty tables, "BOF/EOF access" error would occur.
  6. Error dialog occured when selecting target connection in Data Transfer.

Upgrade Procedure : click here to upgrade

Jan 19 2010
Navicat for MySQL (Windows) version 8.2.19

Bug Fixes:

  1. Restore function could not work properly.
  2. Insert Field did not work in Table Designer.

Upgrade Procedure : click here to upgrade

Jan 12 2010
Navicat for MySQL (Windows) version 8.2.18

Improvements:

  1. If length does not specify for MySQL char/varchar, 255 value will now be assigned when saving a table.

Bug Fixes:

  1. When using MySQL HTTP Tunnel connection and user tried to add/duplicate an user. After pressing OK to close the user form, Navicat would sometimes causes "Access Violation" error.
  2. When altered a MySQL data type that contains unsigned/zerofill properties into BIT type, table could not be saved in Table Designer.
  3. BIT type default value could not be handled properly in some MySQL server.
  4. "1055" errod occured when running MySQL queries after the SQL mode was set into 'TRADITIONAL,ONLY_FULL_GROUP_BY ,NO_AUTO_VALUE_ON_ZERO'.
  5. "1045 - Access denied" error occured when a target server was not selected during MySQL Data Transfer.
  6. Events and Sequences could not shown under Object Selection tab in Restore form.

Upgrade Procedure : click here to upgrade

Nov 18 2009
Navicat for MySQL (Windows) version 8.2.17

Improvements:

  1. In step 6 of Import Wizard, Source field name would be truncated if longer than 255 characters. Now, Navicat supports up to 5000 field name characters.

Bug Fixes:

  1. MySQL Auto increment value could not be altered if "Use DDL from SHOW CREATE TABLE" option was disabled with "Include Auto Increment" option being checked in Data Transfer.
  2. Refresh did not work for getting update data.
  3. When import text-based file using Import Wizard, Navicat was unable to get the number of columns correctly if the file did not contain field name row or there were empty lines existed before first data row.

Upgrade Procedure : click here to upgrade

Oct 28 2009
Navicat for MySQL (Windows) version 8.2.16

Bug Fixes:

  1. The cursor position moved to end-of-line after saved the Stored Procesure/Function.
  2. "Access Violation" error occured when getting the Event information from Linux server.
  3. Failed to establish SSH connection when the private key path contained unicode.
  4. when the server name contain unicode characters, this server name was unreadable in SQL file which created using Data Transfer feature.
  5. "Control 'ppParameterEditor' has no parent window" error occured when clicked on the ParametersEditor button which under Generation topic in Report Builder.
  6. When a table contained some long field names, those field names were only partialy visible or even invisible in Form View.
  7. When resizing the Data Transfer/Data Synchronization/Structure Synchronization window, all data fields expanded to display longer content except the "profile" drop down list.

Upgrade Procedure : click here to upgrade

Oct 5 2009
Navicat for MySQL (Windows) version 8.2.15

Bug Fixes:

  1. "Truncate Table" function did not work with multiple tables if using HTTP Tunnel connection.

Upgrade Procedure : click here to upgrade

Sep 25 2009
Navicat for MySQL (Windows) version 8.2.14

Improvements:

  1. "Exceed package size..." error will now occur to remind you to enlarge the max_allowed_packet variable if the records larger than the maximum packet size setting when running Data Synchronisation for MySQl server.
  2. Report Builder now accepts datetime function for MySQL server.

Bug Fixes:

  1. "Property cannot be found" error occured when importing Access file with datatype that may involve decimal places info, e.g.currecy, number, floating point value.
  2. BLOB data in text file was unable to import successfully.
  3. When added a new field (without labelling its name) in MySQL server usng Table Designer, then click the Move Up button. The last field in the table would be disappeared.
  4. "List index out of bound" error occured when using an account, which did not have enough privileges, to open MySQL Stored Procedure/Function.
  5. "Access Violation" error occured when exporting data to Access file if using HTTP Tunnel connection.

Upgrade Procedure : click here to upgrade

Sep 3 2009
Navicat for MySQL (Window) version 8.2.13

Improvements:

  1. The Data Synchronization message log will not show server name rather than Host/IP.

Bug Fixes:

  1. When applied comma as decimal seperator, Data Synchronization would cause problem.
  2. Date field was not converted correctly when exported to DBF file.
  3. Undo (Ctrl + z) function did not work properly on memo editor in Table Viewer.
  4. Docked windows could not show in task bar under Windows 7.
  5. Email attachment in Schedule could not be sent if "Add timestamp" option was enabled in Export Wizard.

Upgrade Procedure : click here to upgrade

Aug 11 2009
Navicat for MySQL (Window) version 8.2.12

Improvements:

  1. Support specify the socket name in Connection for MySQL server.
  2. Improve suggestion on target data type and provide a default precision and scale information in Import Wizard.
  3. Support export to clipboard.

Bug Fixes:

  1. When docking a console window to main window, the wheel of mouse would be no effect.
  2. Month calendar Could not fully display in some system.
  3. If password did not save in Connection Properties, Dump SQL File would not work propertly.

Upgrade Procedure : click here to upgrade

Jul 22 2009
Navicat for MySQL (Windows) version 8.2.11

Bug Fixes:

  1. "SSH Tunnel:''is not a valid integer value" error occured during SSH connection.
  2. When exported data to MS Access, month and day values were mixed up.
  3. Slow problem while transfering data from command line.
  4. Access Violation error happened when creating new table with index.
  5. Index, constraint and trigger could not be renamed in Table Designer.

Upgrade Procedure : click here to upgrade

Jul 13 2009
Navicat for MySQL (Windows) version 8.2.9

Enhancement:

  1. Improved connection alive issue for MySQL server.

Bug Fixes:

  1. When ran "LOAD DATA LOCAL FILE" in Query Editor to import data to MySQL database, Access violation error occured.
  2. If table names stated with number e.g. 1Table, those tables were not displayed on the Query Builder.
  3. when using Find (ctrl+f) in Form View, it would jump out of Form View into Grid View.
  4. When applied docking feature under Windows 7, "System Error. Code: 87. The parameter is incorrect" occured.
  5. Fixed "Select" statement with empty string in Query Editor resulted in Access violation.

Upgrade Procedure : click here to upgrade

Jul 9 2009
Navicat for MySQL (Windows) version 8.2.8

Enhancement:

  1. Improved dual monitor system support.
  2. Report files are now able to copy to other dataabses.

Bug Fixes:

  1. Access Violation error happened on Data Synchronization when the target connection applied HTTP Tunnel.
  2. Backup failed when connection applied HTTP Tunnel.
  3. When closed the Restore dialog after restored, Access violation occured.
  4. "Not enough timers available" error occured in Structure Synchronization.
  5. After saved the query in Query Editor, the cursor returned to the beginning of the script.
  6. When tables contained foreigh key, "Duplicate Table" feature would not worked for Navicat for MySQL version.
  7. When deleted multi-cell in Table Viewer, Navicat would hang.

Upgrade Procedure : click here to upgrade

Jul 2 2009
Navicat for MySQL (Windows) version 8.2.7

Enhancement:

  1. Support import/export from/to Access 2007 file.
  2. When using "Duplicate Connection" to create a new connection, Settings Save Path won't be copied.

Bug Fixes:

  1. Fixed the column width not saved in Query Result tab.
  2. When exporting tables with choosing "None" for Field delimiter into Text file, it now not add #0(null character) as delimiter.

Upgrade Procedure : click here to upgrade

Jun 26 2009
Navicat for MySQL (Windows) version 8.2.6

Enhancement:

  1. Ability to duplicate connection.

Bug Fixes:

  1. Fixed while changing value in table grid view given "1054 - Unknown column '' in 'field list'" error message using MySQL server version 4.0.x.

Upgrade Procedure : click here to upgrade

Jun 25 2009
Navicat for MySQL (Windows) version 8.2.5

Bug Fixes:

  1. Fixed access violation issue while reorganizing Join table for a saved query.
  2. Fixed "Duplicate Field" function in Table Designer, given "unknown column..." error message.
  3. Fixed access violation issue during backup process.

Upgrade Procedure : click here to upgrade

Jun 22 2009
Navicat for MySQL (Windows) version 8.2.4

Enhancement:

  1. Added execute time for Explain action under Message tab in Query.

Bug Fixes:

  1. Navicat will now end to run the routine for Profile/Status if the Query has stopped by user.
  2. Fixed access violation issue when deleted table in Query Builder after running the query.

Upgrade Procedure : click here to upgrade

Jun 19 2009
Navicat for MySQL (Windows) version 8.2.3

Bug Fixes:

  1. Fixed file association for Windows Vista and Windows 7.
  2. Fixed BINARY and VARBINARY displayed issue in Grid View.
  3. When importing dbf/excel file floating values '.' or ',' as decimal separator, Navicat will now try both in order to recognize its proper floating values.
  4. Fixed password prompt issue while connecting to server in Data Transfer, Data/Structure Synchronization, Console and Server monitor.
  5. Fixed field alias update/insert issue in Query.

Upgrade Procedure : click here to upgrade

Jun 17 2009
Navicat for MySQL (Windows) version 8.2.2

Enhancement:

  1. Improved stability in Query.
  2. Ability to stop while establishing connection to server.
  3. Adjusted the default Settings Save Path to "My Documents".
  4. Detail View (object attributes) will now being adjusted under View menu.
  5. Improved Stored Procedures/Functions Wizard as non-modal form.
  6. Adjusted the file size behavior of "Use extended insert statements" when transfering to file.
  7. Support Ctrl+Del shortcut to delete records.

Bug Fixes:

  1. Fixed SSH Tunnel: BigInteger Overflow issue.
  2. Fixed the crash issue while doing the seach action in Query results.
  3. Fixed VARBINARY and BINARY columns were exported incorrectly.
  4. Date became 0 while exporting to Excel.
  5. Fixed "show database" privilege problem - avoid to have alert box pop out when user using Navicat.
  6. Fixed columns missing while printing reports using schedule in command line.
  7. Fixed GUI font size issue in Connection form.
  8. Fixed parse set/enum value in Table Designer.
  9. Fixed password prompt for Data Transfer, Data/Structure Synchronization.
  10. Fixed Virtual Grouping was unable to load.

Upgrade Procedure : click here to upgrade

May 18 2009
Navicat for MySQL (Windows) version 8.1.20

Navicat new logo design has been launched.

Upgrade Procedure : click here to upgrade

May 12 2009
Navicat for MySQL (Windows) version 8.1.19

Enhancement:

  1. Added keyboard interactive authentication for SSH.
  2. Adjusted the AutoFill from picklist behavior for Grid View.
  3. Supported to import Visual Foxpro memo fields to tinytext/blob.

Bug Fixes:

  1. Fixed export excel spreadsheet with datetime was set to 0.
  2. Fixed Move up/Move Down issue in Table Designer.
  3. Fixed ampersand not show in Memo view.
  4. Employed the last dataset for report when multi-dataset.
  5. No need validate the expiry date while using SSL.

Upgrade Procedure : click here to upgrade

May 6 2009
Navicat for MySQL (Windows) version 8.1.18

Enhancement:

  1. Added keyboard interactive authentication for SSH.
  2. Adjusted the AutoFill from picklist behavior for Grid View.

Bug Fixes:

  1. Fixed export excel spreadsheet with datetime was set to 0.
  2. Fixed wrongly treat empty string as null.
  3. Fixed access violation when select BLOB/TEXT issue.
  4. Disable KeepAliveTimer before executing SQL.

Upgrade Procedure : click here to upgrade

Apr 30 2009
Navicat for MySQL (Windows) version 8.1.17

Bug Fixes:

  1. Fixed the save problem while pasting field from clipbosrd in Table Designer.
  2. Password was wrongly trimmed while using SSH connection.

Upgrade Procedure : click here to upgrade

Apr 27 2009
Navicat for MySQL (Windows) version 8.1.16

Major new features:

  1. Enhanced support of new MySQL server versions.
  2. Partitioning support for MySQL 5.1.
  3. Support of Show Profile and Status in Query.
  4. Support of multi-resultset in Query, Stored Procedure.
  5. Ability to attach Export Wizard/Report result files in Batch Job notification email.
  6. Support of SQL Preview for all object design forms.
  7. More table properties can be adjusted in Table design form.
  8. Support Preview and Explain in View Design form.

Other enhancements:

User Interface

  1. Object information is now shown in pane inside Navicat main form rather than pop-up modal dialog.
  2. Support of drag and drop files (e.g. csv, excel....) to connection tree/table pane, Import Wizard will be launched.
  3. Support of drag and drop SQL files to connection tree - Excute SQL Batch Wizard will be launched.
  4. Added confirm checkbox when delete system object (e.g. databse mysql, information schema, current user in Manage User).
  5. Changed to use "Delete" instead of "OK" in delete confirm dialog.
  6. Added "Go to setting save path" in connection tree popup menu.
  7. Support shortcut key(Ctrl+Q) to quick launch Query form.
  8. Support shortcut key(Ctrl+H) to open history log file.
Stored Procedure
  1. Added Stored Procedure Wizard to generate procedure template.
Connection
  1. Ability to copy Connection Information into Clipboard.
Import Wizard
  1. Improved support of Unique, Index, Foreign Key in Access/ODBC.
  2. Improved support of auto-increment.
Backup/Restore
  1. Added "Compress Backup" and "Decompress Backup".
Structure Synchronization
  1. More options to choose which objects to compare.
  2. Improved support of synchronizing auto-increment column.
Data Transfer
  1. More options to choose for creating table.

Navicat Release Notes.

Upgrade Procedure : click here to upgrade

Jan 6 2009
Navicat for MySQL (Windows) version 8.0.29

Bug Fixes:

  1. Fixed timeout problem during the Backup run in Command Line.
  2. Fixed Data Transfer (without target database name) access violation in Command Line.
  3. Fixed system color shows in grid.

Upgrade Procedure : click here to upgrade

Sep 18 2008
Navicat for MySQL (Windows) version 8.0.28

Bug Fixes:

  1. Fixed e-mail sending with authentication setting in Schedule.
  2. Fixed Print Database/Table issue, while printing non-english field name, table name etc.
  3. Fixed dbf import,while importing Float type with NULL value.
  4. Fixed Open Table shortcut issue.
  5. Fixed Command Line crash.

Upgrade Procedure : click here to upgrade

Apr 30 2008
Navicat for MySQL (Windows) version 8.0.27

Bug Fix:

  1. Fixed the backup problem while establishing connection using HTTP tunnel. (please feel save that all your data have already been backup in your backup files. No data are lost. If you are encountering problem during the restore process, please provide us your backup file.)
Navicat Release Notes.

Upgrade Procedure : click here to upgrade

Apr 16 2008
Navicat for MySQL (Windows) version 8.0.26

Improvements:

  1. Provide better error log system for Data Synchronization.
Bug Fixes:
  1. Fixed "Invalid class typecast" error in Server Monitor.
  2. Closed the docking windows using Alt+F4 would give Access Violation error.
  3. Structure Synchronization will not synchronize field comments.
Navicat Release Notes.

Upgrade Procedure : click here to upgrade

Apr 7 2008
Navicat for MySQL (Windows) version 8.0.25

Improvements:

  1. The outcome from Navicat "Dump SQL File" feature (both database and table) includes "drop table if exists" statement.
  2. Ability to remember size and position for "New Query" window.
  3. Set focus on Query Editor when opening a new query.
Bug Fixes:
  1. Fixed the backup problem which would generate error if object name contains apostrophe(').
  2. No need to save the query before export to excel file.
  3. Scheduled Job does not populate "from" field in email.
  4. Restore window position problem.
  5. Export dbf with or without memo issue.
  6. Fixed uppercase StoredProc in Manage users.
  7. Overflow in Server Monitor.
  8. Unicode problem in StoredProc designer.
  9. Comment are not shown in StoredProc designer after save.
  10. Fixed import dbf float/double issue.
  11. Fixed Import xml issue - while xml file contains ampersands(&).
  12. Fixed popup position with dual monitor.
  13. File association problem between MYSQL and PGSQL version.
  14. Fixed number of crashes from query.
Navicat Release Notes.

Upgrade Procedure : click here to upgrade

Jan 28 2008
Navicat for MySQL (Windows) version 8.0.23

Major new features:

  1. Event Scheduler - new MySQL feature as of MySQL 5.1.
  2. Virtual Grouping - provides better categorization for objects.
  3. Form View - enjoy a clear display of field name and its value with focus on current record.
  4. Code Completion - speedup your sql writing.
  5. New Profile System - open profile on your desktop directly.
  6. Print Report to Files - export report to pdf, html and more.
  7. E-mail Notification - send notification e-mail for schedule task.
Other enhancements:
  1. Compatible with any MySQL server version up to 5.1.x.
  2. Incremental Search and more supports in Table View.
  3. Usability enhancement in Table Design.
  4. Many other improvements on features and user-friendliness.
Navicat Release Notes.

Upgrade Procedure : click here to upgrade

Mar 17 2006
Navicat for MySQL (Windows) version 7.1.15

New features:

Lastest MySQL versions support:

  1. Compatible with any MySQL server version up to 5.0.x.
  2. Support of Triggers.
  3. VARCHAR Data Type support. Length from 0 to 65,535 in 5.0.3 and later versions.
  4. BIT Data Type support from MySQL 5.0.3.

Significantly improved user interface:

  1. Customize of connection order.
  2. Support of larger font in Filter Wizard.
  3. Auto-adjustment of row height setting.

New powerful data management tools:

  1. Support of Views/Stored Procedures Backup and Restore.
  2. Support of Views/Stored Procedures Data Transfer.
  3. Support of Delimiter in Query, Console and Execute Batch Job.
  4. Support of Views in Query Builder.
  5. Enhancement of Manage Users for supporting MySQL 5.x.
  6. Support of Views in Manage Users.

Ehancements :

  1. Support of importing Oracle to MySQL.
  2. Support of importing MS SQL to MySQL.
  3. Bug fixes of Timestamp creation problem.
  4. Bug fixes of adding a left join to existing View.
  5. Bug fixes of data transfer problem.

Upgrade Procedure : click here to upgrade

Nov 9 2005
Navicat for MySQL (Windows) version 7.0.9

New features:

  1. Data Synchronization.
  2. Structure Synchronization.
  3. Build in SQL Console.
  4. View Builder.

Some features enhancements:

  1. Further data are shown in the tree view.
  2. Three colors are employed within the table grid to provide a better vision for users.
  3. Supports Query Parameter. For example: Select * from table_A where id = [$id].
  4. Provides a short-cut to terminate a running query.
  5. Raw mode setting allows user to view the actual data value which stored in the MySQL database.
  6. Export Profile -the existing Navicat setting can be exported into a .reg file. You can also reload the Navicat setting from a new machine.
  7. Query Builder supports to create a query from different databases which are within the same connection.
  8. View Builder is an easy-way to create view.
  9. Run Selected - Query Statments can be executed partly in the Query Editor.
  10. Stored Procedure - new editor window provides an easy-way to create stored procedure or stored function.
  11. Timeout reconnection - Auto-reconnection will be made to the SQL server.
  12. Support Private Key feature for SSH Tunnel.
  13. WordWrap built for Query and View Editor.
  14. Supports Stored Procedure for MySQL 5.0.13 or above.

Bug Fixes:

  1. Closing Navicat without prompt to save changed.
  2. Invisibility of Foreign Key constraint settings.
  3. Inconsistency of importing Access file.
  4. Time-Consuming for creating new query with numerous tables.
  5. Prevention of modifying TIMESTAMP column type.
  6. DBF Import error.
  7. Excel Export error as Text fields.
Jan 12 2005
Navicat for MySQL (Windows) version 6.1.10
Major new features:

  1. Support View in MySQL 5.0
  2. Enhanced Import and Export Wizard
    • supports to import multiple tables, primary keys and foreign keys from Access.
    • supports to import multiple spreadsheet from Excel.
    • customizable row identifier in import of XML file.
    • more options available in Exporting MySQL table.
  3. Support Character Set (new function in MySQL 4.1 or above)
  4. Enhance Docking
  5. Options: Detail View/List View in mainwindow
  6. AutoFill for enum in grid
  7. Change display font in Navicat
  8. TableHint on mouse rollover
  9. Help in each window
  10. HistoryLog of executed process in Navicat.
Jul 6 2004
Navicat 2004 for Windows version 6.0.7
This new version includes a new feature - SSH Tunnel. For more information, please visit at ssh_tunnel.php .
Apr 20 2004
Navicat 2004 for Windows version 6.0
Over 100 enhancements and new features:

Navicat 2004 supports to import data from ODBC, create Batch Job Scheduling (schedule of Import/Export, Data Transfer and saved queries) and print table structure of their designed database. Furthermore, it now supports MySQL 5.0 Alpha (support stored procedure).

Navicat Standalone Report Viewer will be avaliable for Enterprise Edition (will be released in Mid-May).

Upgrade Procedure : click here to upgrade

Dec 2 2003
Navicat for MySQL (Windows) version 5.3.12
Bug fixes on SSL connection. SSL Connection setup tutorial .
Nov 10 2003
PremiumSoft Navicat (Windows) version 5.3.1

Create schedule for Import/Export is now possible in Navicat 5.3.11.

New features:

  1. Execute saved queries from command line.
  2. Save Import or Export wizard setting in a profile. You can execute saved profile from command line.
  3. Support importing multiple MS Access tables at once.
  4. MySQL Server v4.1 support.
  5. Duplicate Tables.
  6. Empty Tables.
  7. Bug Fixes on importing dbf file and Access file.
  8. Bug Fixes on using multiple monitors.
  9. Load SQL function fully supports Unicode.
  10. More user friendliness improvement.

Oct 1 2003
Survey for New Features: In order for us to further enhance our Navicat, please tell us your comment through [Navicat Survey]
Sep 29 2003
PremiumSoft Navicat (Windows) version 5.3
New features:
  1. Execute saved queries from command line.
  2. Save Import or Export wizard setting in a profile. You can execute saved profile from command line.
  3. Support importing multiple MS Access tables at once.
  4. MySQL Server v4.1 support.
  5. Duplicate Tables.
  6. Empty Tables.
  7. more user friendliness improvement.
Aug 20 2003
PremiumSoft Navicat (Windows) version 5.2.4
New features:
  1. foreign keys
  2. unicode support
  3. bugfix on displaying hidden popup windows.
  4. bugfix on sql editor.
  5. bugfix on Set Privileges.
  6. more useful features, minor bugfixes and performance improvement.
Aug 5 2003
PremiumSoft Navicat (Windows) version 5.2
New features:
  1. Foreign Keys - support to configure Foreign Keys.
  2. Unicode support.
  3. and more useful features, minor bugfixes and performance improvement.
Apr 6 2003
Version 5.1 of Navicat for MySQL (Windows) and New Upgrade Procedure are released today!
New features:
  1. Process priority - loading table can be faster if priority is set to High.
  2. Improve the user-friendliness of Data Transfer feature.
  3. There will be numerous performance and manageability improvements.
Jan 27 2003
Navicat for MySQL (Windows) version 5.0
New features:
  1. improve performance on multiple simultaneous jobs. The performance of running large queries will be greatly improved..
  2. support SSL.
  3. support custom display formats for Numeric , Date and Time Type.
  4. support Mysql function in edit data.
  5. improve the user-friendliness.
  6. there will be numerous performance and manageability improvements.
Jun 13 2002
Lastest version of Navicat for MySQL (Windows)

New features:

  1. Import/Export Wizard
    The Import and Export Wizard would help you to import/export data. It supports up to 18 most popular formats including MS Access, MS Excel, XML, PDF and TXT.
  2. Visual Query Builder
    The Visual Query Builder would help you to create SQL queries much easier.

May 21 2002
The newest version of Navicat for MySQL (Windows)

  1. creating Primary Key and Indexes would be much easier.
  2. a lot of small improvements on user friendliness.
  3. bugfix on Manage Users.
  4. some minor bugfixes.

Mar 31 2002
Navicat for MySQL (Windows), fixes of all minor bugs reported by our users since version 3.0 ...
Mar 4 2024
Navicat for MySQL (macOS) version 16.3.7

Bug-fixes:

  1. Modified data types were not retained when switching to other tables in Import Wizard.
  2. Incorrect json array index syntax was generated when transferring MySQL tables.
  3. Unable to connect using ssh agent in some cases.
  4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Feb 21 2024
Navicat for MySQL (macOS) version 16.3.6

Bug-fixes:

  1. Crashed when presenting dashboard in some cases.
  2. Unable to change data types when creating tables.
  3. Focus moved to the upper level after deleting an object in Navigation Pane.
  4. Some labels disappeared after adding the chart to the dashboard.
  5. Unable to display proportion percentages in the chart axis.
  6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jan 9 2024
Navicat for MySQL (macOS) version 16.3.5

Bug-fixes:

  1. Unable to load indexes in MariaDB Table Designer.
  2. Crashed when closing Server Monitor.
  3. The percentage values shown in the chart were incorrect.
  4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Dec 12 2023
Navicat for MySQL (macOS) version 16.3.4

Bug-fixes:

  1. Crashed when opening Navicat on older macOS versions.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Dec 7 2023
Navicat for MySQL (macOS) version 16.3.3

Bug-fixes:

  1. Column widths were not retained when opening tables/views.
  2. Crashed when scheduling batch jobs in some cases.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Nov 7 2023
Navicat for MySQL (macOS) version 16.3.2

Bug-fixes:

  1. COMMAND-F shortcut did not work in the main window.
  2. Refresh button did not work in Server Monitor.
  3. Text in the Search box was hidden in some cases.
  4. Advanced options in Structure Synchronization cannot be displayed.
  5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Oct 30 2023
Navicat for MySQL (macOS) version 16.3.1

Bug-fixes:

  1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Oct 17 2023
Navicat for MySQL (macOS) version 16.3.0

Improvements:

  1. Support setting MySQL descending primary key.

Bug-fixes:

  1. Crashed when transferring large tables using SSH connection.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Sep 20 2023
Navicat for MySQL (macOS) version 16.2.9

Bug-fixes:

  1. Crashed on macOS 14.
  2. MariaDB Triggers were transferred multiple times during Data Transfer.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Aug 28 2023
Navicat for MySQL (macOS) version 16.2.7

Bug-fixes:

  1. Beautify SQL incorrectly added spaces between the function name and parentheses.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Aug 8 2023
Navicat for MySQL (macOS) version 16.2.6

Bug-fixes:

  1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jul 14 2023
Navicat for MySQL (macOS) version 16.2.5

Bug-fixes:

  1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jun 19 2023
Navicat for MySQL (macOS) version 16.2.3

Bug-fixes:

  1. Copy and paste shortcuts did not work in Navigation pane.
  2. The focus jumped to the top level after renaming an object in Navigation pane.
  3. Table tree loading issue in Navigation Pane.
  4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jun 9 2023
Navicat for MySQL (macOS) version 16.2.2

Bug-fixes:

  1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

May 31 2023
Navicat for MySQL (macOS) version 16.2.1

Main New Features:

  1. Support sequence design for MariaDB.
  2. Show fields, indexes and more under tables in Navigation Pane.
  3. Minor bug fixes and improvements.
  4. Navicat for Redis is released.

To upgrade, please visit our Customer Center.

Apr 26 2023
Navicat for MySQL (macOS) version 16.1.10

Bug-fixes:

  1. High CPU usage when using SSH connection.
  2. Unable to save the schedule changes.
  3. TAB key did not work when adding field.
  4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Apr 17 2023
Navicat for MySQL (macOS) version 16.1.9

Bug-fixes:

  1. Crashed when opening Preferences in some cases.
  2. Crashed when importing database to model in some cases.
  3. Crashed when saving table after changing field comment.
  4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Mar 1 2023
Navicat for MySQL (macOS) version 16.1.7

Bug-fixes:

  1. Memory utilization issue.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Feb 15 2023
Navicat for MySQL (macOS) version 16.1.6

Bug-fixes:

  1. Unable to backup if database folder did not exist.
  2. Unable to load cloud connection info when opening data transfer profile.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Dec 12 2022
Navicat for MySQL (macOS) version 16.1.5

Bug-fixes:

  1. Default value did not show when adding new records.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Dec 5 2022
Navicat for MySQL (macOS) version 15.0.36

Bug-fixes:

  1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Sep 28 2022
Navicat for MySQL (macOS) version 16.1.3

Bug-fixes:

  1. Unable to enter Enum values in MariaDB table designer.
  2. Query Builder did not recognize the selected fields.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Aug 31 2022
Navicat for MySQL (macOS) version 16.1.2

Bug-fixes:

  1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Aug 16 2022
Navicat for MySQL (macOS) version 16.1.1

Bug-fixes:

  1. Unable to open the objects in the "Find in Database" window.
  2. Cannot show query errors when using HTTP tunnel.
  3. Crashed when renaming a connection in a group.
  4. Cannot show the new group unless Navicat was restarted.
  5. Checks were not imported when using "Reverse Database to Model".
  6. Unable to sort columns in table viewer.
  7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jul 21 2022
Navicat for MySQL (macOS) version 16.1.0

Main New Features:

  1. Support OceanBase Community Edition.
  2. Support Trend Line for several chart types.
  3. Support adding On-Prem Server with URI.
  4. Allow skip preview of changes in data sync.
  5. Enhanced responsiveness and performance.
  6. Improved UI/UX.
  7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jun 14 2022
Navicat for MySQL (macOS) version 16.0.14

Bug-fixes:

  1. Query parameters did not work in some cases.
  2. Function group creation issue.
  3. Hanged when updating records in some cases.
  4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

May 10 2022
Navicat for MySQL (macOS) version 16.0.13

Bug-fixes:

  1. Chart title display issue.
  2. Query listing issue when loading cloud queries.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Mar 28 2022
Navicat for MySQL (macOS) version 16.0.12

Bug-fixes:

  1. Crashed when opening a table in some cases.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Mar 21 2022
Navicat for MySQL (macOS) version 15.0.35

Bug-fixes:

  1. Crashed when hovering over tabs.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Mar 14 2022
Navicat for MySQL (macOS) version 16.0.11

Bug-fixes:

  1. Add/Delete Foreign Key issue in ER diagram.
  2. "Show bar labels" setting cannot be saved in Charts.
  3. Crashed when moving a connection from Navicat Cloud to My Connections.
  4. Crashed when running Automation in some cases.
  5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Mar 1 2022
Navicat for MySQL (macOS) version 16.0.9

Bug-fixes:

  1. Crashed when using table viewer.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Feb 23 2022
Navicat for MySQL (macOS) version 16.0.8

Bug-fixes:

  1. Auto completion did not work when inputting ENUM value in the table viewer.
  2. Crashed when closing Navicat in some cases.
  3. Hanged when designing table.
  4. Unable to scroll through the fields with the mouse wheel in Query Builder.
  5. Duplicate options in the user Plugin dropdown menu.
  6. Connection coloring did not work on subtabs.
  7. Crashed when importing invalid json files.
  8. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Feb 8 2022
Navicat for MySQL (macOS) version 15.0.34

Bug-fixes:

  1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jan 13 2022
Navicat for MySQL (macOS) version 16.0.7

Bug-fixes:

  1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jan 10 2022
Navicat for MySQL (macOS) version 15.0.33

Bug-fixes:

  1. Missing zero padding in year when exporting data to CSV / TXT file.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jan 3 2022
Navicat for MySQL (macOS) version 16.0.6

Bug-fixes:

  1. Data Transfer failed when using HTTP tunnel.
  2. Line numbers disappeared when scrolling in Query Editor.
  3. Crashed when mapping MySQL and MariaDB fields in Data Synchronization.
  4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Dec 15 2021
Navicat for MySQL (macOS) version 16.0.5

Bug-fixes:

  1. Connection encoding issue in Navicat Cloud.
  2. Crashed in some cases.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Dec 7 2021
Navicat for MySQL (macOS) version 16.0.4

Bug-fixes:

  1. Syntax error occurred when importing data to MySQL table.
  2. Crashed when opening query on macOS 10.14 .
  3. SSL connection error.
  4. Missing zero padding in year when exporting data to CSV / TXT file.
  5. Missing menu items when opening query in new window.
  6. Crashed when importing connections.
  7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Nov 23 2021
Navicat for MySQL (macOS) version 16.0.3

Main New Features:

  1. New Data Generation Tool
  2. Enhanced Charts Feature
  3. Support of Navicat On-Prem Server

Additional Features:

  1. Connection Profiles
  2. Field Information Pane
  3. Query Execution Summary
  4. Navicat On-Prem Server is released
  5. Many other new features and improvements

To upgrade, please visit our Customer Center.

Nov 10 2021
Navicat for MySQL (macOS) version 15.0.32

Bug-fixes:

  1. Crashed when running scripts in some cases.
  2. Crashed when copying records in some cases.
  3. The TEXT pane did not retain when running queries.
  4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Aug 19 2021
Navicat for MySQL (macOS) version 15.0.30

Bug-fixes:

  1. Unable to show the cursor when editing TEXT data using Form View in Dark Mode.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jun 29 2021
Navicat for MySQL (macOS) version 15.0.29

Bug-fixes:

  1. Differences were incorrectly detected when synchronizing MySQL table structures.
  2. Crashed when running query in some cases.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

May 3 2021
Navicat for MySQL (macOS) version 15.0.28

Bug-fixes:

  1. Unable to update data in some cases.
  2. Crashed when using Data Transfer in some cases.
  3. Exporting JSON field didn't handle NULL and integer values properly.
  4. Cursor did not focus to the Search box after pressing CMD-F.
  5. Crashed when selecting the "Group by Object Type" in Structure Synchronization.
  6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Mar 8 2021
Navicat for MySQL (macOS) version 15.0.26

Bug-fixes:

  1. Unable to read grid data in Dark mode.
  2. Unable to sort the last column by clicking the column header in Table Viewer.
  3. Duplicate entry error occurred when editing the pasted records.
  4. Hanged when starting Navicat in some cases.
  5. "Different primary key type" error occurred when synchronizing MySQL data.
  6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jan 14 2021
Navicat for MySQL (macOS) version 15.0.25

Bug-fixes:

  1. 'Primary key needs to be integer' error occurred when synchronizing data.
  2. Unable to show the ENUM items list in Table Viewer.
  3. Unable to sort by clicking the column header in Table Viewer.
  4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Dec 22 2020
Navicat for MySQL (macOS) version 12.1.31

Bug-fixes:

  1. Data Synchronization UX issue.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Dec 15 2020
Navicat for MySQL (macOS) version 15.0.24

Improvements:

  1. Set the values of a column to NULL.

Bug-fixes:

  1. Crashed when saving MariaDB Views.
  2. The modified dates of backup files were incorrect.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Oct 12 2020
Navicat for MySQL (macOS) version 15.0.22

Improvements:

  1. Prompt to change the MariaDB password when it expired.

Bug-fixes:

  1. Unable to show the granted privileges if the database name contained wildcard characters.
  2. Only the last selected table was printed when printing multiple tables.
  3. The SQL Editor was flickered and repainted when saving the query.
  4. "Auto Increment" and "Unsigned" options were removed after adding another field.
  5. Crashed when using Query Builder on Big Sur.
  6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Sep 15 2020
Navicat for MySQL (macOS) version 15.0.21

Bug-fixes:

  1. The "Set Null" option was applied to a wrong column when some columns were hidden in Table Viewer.
  2. The field size was incorrect in Form View.
  3. Crashed when opening/testing a connection after changing "Settings Location" to a folder in Documents.
  4. The "Encoding" setting was not stored when the connection was synchronized to Navicat Cloud.
  5. "Dump SQL File" stopped running in some cases.
  6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Aug 3 2020
Navicat for MySQL (macOS) version 15.0.20

Bug-fixes:

  1. Unable to set the encoding of MariaDB connection.
  2. Unable to connect MySQL server when using TLSv1.2.
  3. Schedule did not trigger when using Navicat App Store version.
  4. The "Close Database" option in the context menu was dimmed when a query tab was focused.
  5. The entire connection tree was collapsed when searching.
  6. Crashed when deleting a data source in Charts.
  7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jun 22 2020
Navicat for MySQL (macOS) version 15.0.18

Improvements:

  1. Improvement on resizing Information pane.

Bug-fixes:

  1. Negative default value displayed as "-" in MariaDB.
  2. No records were imported in some cases when Import Wizard displayed "Finished Successfully".
  3. Wrong SQL generated for CAST function when switching between Query Editor and Query Builder.
  4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jun 3 2020
Navicat for MySQL (macOS) version 15.0.17

Bug-fixes:

  1. Unable to show full table names in the Data Synchronization window.
  2. Field names in the Join dialog were truncated.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

May 18 2020
Navicat for MySQL (macOS) version 15.0.16

Bug-fixes:

  1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

May 6 2020
Navicat for MySQL (macOS) version 15.0.15

Bug-fixes:

  1. Jumped to the first record when refreshing in Form View.
  2. Unable to synchronize data to MySQL 8.0.19.
  3. Unable to connect AnalyticDB.
  4. The list of the reference tables for foreign key was empty in Model.
  5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Apr 20 2020
Navicat for MySQL (macOS) version 12.1.30

Bug-fixes:

  1. Scrolling was slow in data viewer.
  2. "Error moving files" error occurred when accessing Navicat Cloud.
  3. The color picker disappeared in diagram.
  4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Apr 15 2020
Navicat for MySQL (macOS) version 15.0.14

Bug-fixes:

  1. The state of the pane in model was not retained.
  2. Field count was missing in Table Designer.
  3. Crashed when opening Console.
  4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Mar 23 2020
Navicat for MySQL (macOS) version 15.0.12

Bug-fixes:

  1. "9015: Error Moving Error" error occurred when using Navicat Cloud.
  2. Crashed when clicking the Next button without choosing a target database in Data Transfer.
  3. Unable to show the whole Trial Reminder dialog.
  4. Crashed when editing/composing new queries in some cases.
  5. Invalid XML error occurred when importing connections.
  6. Crashed when starting Data Transfer in some cases.
  7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Mar 3 2020
Navicat for MySQL (macOS) version 12.1.29

Bug-fixes:

  1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Feb 27 2020
Navicat for MySQL (macOS) version 15.0.11

Bug-fixes:

  1. Console was missing in Standard eidtion.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Feb 20 2020
Navicat for MySQL (macOS) version 15.0.10

Bug-fixes:

  1. Crashed when using Data Transfer in some cases.
  2. Inserted records to the target server when transferring views.
  3. CPU usage was high when using Query Builder.
  4. Unable to open the main window when starting Navicat.
  5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jan 16 2020
Navicat for MySQL (macOS) version 15.0.8

Bug-fixes:

  1. Crashed when starting Navicat.
  2. Dates before 1900 were exported as numeric values when exporting to Excel.
  3. The Search feature did not work properly in the Data Transfer window.
  4. Icon and text were not aligned well in the Navigation pane
  5. The unchecked "Includes anonymous system profile" option was reverted to check after restarting Navicat.
  6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jan 6 2020
Navicat for MySQL (macOS) version 15.0.7

Bug-fixes:

  1. Crashed when starting Navicat.
  2. Crashed when running Data Transfer in some cases.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Dec 24 2019
Navicat for MySQL (macOS) version 15.0.6

Improvements:

  1. Added shortcuts for "Run Current Statement" and "Select Current Statement" in Query Editor.

Bug-fixes:

  1. Unable to run selected query in some cases.
  2. Crashed when using Data Transfer.
  3. Unable to show which database is active.
  4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Dec 12 2019
Navicat for MySQL (macOS) version 12.1.28

Bug-fixes:

  1. Data Synchronization options were unable to save in profile.
  2. Unable to copy SQL query from Process List in Server Monitor.
  3. "Option" button was missing in the file selection window of Import Wizard.
  4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Dec 9 2019
Navicat for MySQL (macOS) version 15.0.4

Bug-fixes:

  1. Data Synchronization options were unable to save in profile.
  2. Auto Layout feature separated notes and labels from layers.
  3. Unable to copy SQL query from Process List in Server Monitor.

To upgrade, please visit our Customer Center.

Nov 25 2019
Navicat for MySQL (macOS) version 15.0.3

New Features:

  1. New Charts
  2. Advanced Data Transfer
  3. Brand new Query Builder
  4. Enhanced Data Modeling Tool
  5. Dark theme UI and Diagram
  6. Many other new features and improvements

To upgrade, please visit our Customer Center.

Oct 11 2019
Navicat for MySQL (macOS) version 12.1.27

Bug-fixes:

  1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Oct 9 2019
Navicat for MySQL (macOS) version 12.1.26

Bug-fixes:

  1. Unable to change the Settings Location path of Navicat Cloud connections.
  2. A red exclamation mark was incorrectly displayed on the Navicat Cloud query icon.
  3. "Add Object Privileges" UI issue when using Dark Mode.
  4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Sep 17 2019
Navicat for MySQL (macOS) version 12.1.25

Bug-fixes:

  1. Unable to search in menu bar / Help.
  2. Unable to show the database list when there was more then 255 databases.
  3. Data Transfer process was stopped in some cases.
  4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jul 24 2019
Navicat for MySQL (macOS) version 12.1.24

Bug-fixes:

  1. Unable to list users for MariaDB 10.4.
  2. List View was not retained in the main window after restarting Navicat.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jun 12 2019
Navicat for MySQL (macOS) version 12.1.23

Bug-fixes:

  1. Unable to transfer views from MySQL to MariaDB.
  2. Crashed when running query in some cases.
  3. Unable to use the Add Privilege button.
  4. Connections moved out of the group after editing.
  5. Crashed when editing model in some cases.
  6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

May 23 2019
Navicat for MySQL (macOS) version 12.1.22

Bug-fixes:

  1. Empty tables were created when importing .accdb file.
  2. Run Selected option did not run all highlighted text when using shortcut to select the SQL.
  3. SSH connection dropped issue.
  4. Unable to retain selected columns in Foreign Key Selection window.
  5. Data Synchronization data grid UI issue in Dark Mode.
  6. Data Synchronization inserted values into Generated Columns.
  7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Apr 18 2019
Navicat for MySQL (macOS) version 12.1.20

Bug-fixes:

  1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Apr 17 2019
Navicat for MySQL (macOS) version 12.1.19

Bug-fixes:

  1. Error occurred when connecting to MySQL 4.0.
  2. Missing "Tools" menu when running an infinite loop in Console.
  3. Crashed when comparing databases in Structure Synchronization.
  4. Crashed when saving models.
  5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Mar 21 2019
Navicat for MySQL (macOS) version 12.1.18

Bug-fixes:

  1. Grid View and Form View menu options were flipped.
  2. "On Update Current Timestamp" option did not reflect the settings when using ANSI_QUOTES SQL mode.
  3. The row height of the object list did not match the font size.
  4. Column order was incorrect when importing database to model.
  5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Feb 26 2019
Navicat for MySQL (macOS) version 12.1.16

Improvements:

  1. Enter the datetime value directly in the Filter.

Bug-fixes:

  1. Crashed when opening a database in some case.
  2. If the filter value box was opened, Navicat window disappeared when switching to another App.
  3. Crashed when using Find feature after updating the data.
  4. Crashed when code completion was triggered in large query.
  5. Freeze when entering/exiting Full Screen.
  6. Selected connection, database and schema names were missing in Data Transfer window.
  7. 1146 error occurred when duplicating MySQL 8.0 functions.
  8. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jan 10 2019
Navicat for MySQL (macOS) version 12.1.15

Bug-fixes:

  1. Unable to search the grouped queries unless the group was selected.
  2. Crashed when using Find in Database/Schema if the connection was not opened.
  3. Field comment font color issue when using Dark Mode.
  4. SSH key file reselect issue when opening connection in App Store version.
  5. Crashed when creating a project.
  6. Beautify SQL feature wrongly split text which started with numbers.
  7. Row highlight issue when using Dark Mode.
  8. Crashed when opening Datetime picker window in Table Viewer.
  9. Unable to show line number in SQL Editor on macOS 10.14.
  10. Code Folding did not work properly in SQL Editor on macOS 10.14.
  11. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Nov 23 2018
Navicat for MySQL (macOS) version 12.1.13

Bug-fixes:

  1. Crashed when opening Navicat if logged in Navicat Cloud.
  2. Unable to connect using SSH private key in some cases.
  3. Hanged when saving Procedure/Function.
  4. Crashed when clicking Views in some cases.
  5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Nov 7 2018
Navicat for MySQL (macOS) version 12.1.12

Bug-fixes:

  1. Mojave's Dark Mode did not display properly.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Nov 6 2018
Navicat for MySQL (macOS) version 12.1.11

Bug-fixes:

  1. Stored procedures was not exported properly when using Data Transfer.
  2. Import Wizard was slow in some cases.
  3. "Connection is in use" message prompted when restarting Navicat if connection password was not stored.
  4. Crashed after Navicat was opened in a few minutes.
  5. Crashed when showing Navicat Cloud Agreement.
  6. Crashed when synchronizing data in MariaDB System Versioned Tables.
  7. Unable to copy data from Table Viewer.
  8. Code Completion did not work properly in some cases.
  9. Inputted text was not displayed when renaming objects on Navigation Pane in Mojave's Dark Mode.
  10. Unable to list the batch jobs in some cases.
  11. Connection/Database did not open when dragging tables into it.
  12. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Oct 10 2018
Navicat for MySQL (macOS) version 12.1.10

Bug-fixes:

  1. "<html>" tag was repeated twice when exporting HTML file.
  2. Definition was missing when dumping Views and Functions.
  3. Crashed when starting Navicat in some cases.
  4. Foreign key data selection did not work.
  5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Oct 2 2018
Navicat for MySQL (macOS) version 12.1.9

Bug-fixes:

  1. HTML export did not specify charset.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Sep 10 2018
Navicat for MySQL (macOS) version 12.1.8

Bug-fixes:

  1. Available Jobs list did not sort alphabetically in Automation.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Aug 29 2018
Navicat for MySQL (macOS) version 12.1.7

Bug-fixes:

  1. Crash occurred when adding export profile to a batch job in some cases.
  2. Navicat got hanged when viewing SQL Preview in new function.
  3. Crash occurred when saving new function.
  4. Sync User Name with Navicat Cloud option in SSH tab did not work properly.
  5. Unable to scroll horizontally in the comparison step of Data Synchronization.
  6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Aug 23 2018
Navicat for MySQL (macOS) version 12.1.6

Bug-fixes:

  1. COMMAND-N new object shortcut did not work.
  2. Not Null checkbox state was wrong in Table Designer.
  3. Crashed when creating new connection in some cases.
  4. Import Target and Field Mapping changed after changing the source file in profile.
  5. Syntax error occurred when transferring MySQL ARCHIVE engine tables.
  6. Crashed when closing window in some cases.
  7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jul 31 2018
Navicat for MySQL (macOS) version 12.1.4

Bug-fixes:

  1. Unable to map fields in Import Wizard.
  2. New Query shortcut and menu item did not work.
  3. Crashed when clicking New Query button in some cases.
  4. Crashed when typing in Query Editor in some cases.
  5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jul 26 2018
Navicat for MySQL (macOS) version 12.1.3

Main New Features:

  1. Support Roles for MySQL 8
  2. Support Roles for MariaDB 10
  3. Brand new Filter Wizard
  4. UI and UX Improvement
  5. MongoDB is added in Navicat Premium
  6. Navicat for MongoDB is released

To upgrade, please visit our Customer Center.

Jul 13 2018
Navicat for MySQL (macOS) version 12.0.28

Bug-fixes:

  1. Unable to rename table with double-click in some cases.
  2. Sorting Rows column on the Objects tab did not work properly.
  3. Command-W shortcut did not close the active window in some cases.
  4. Some menu items were missing in Table Designer.
  5. Export Wizard did not add a leading zero to pad days and months to two digits.

To upgrade, please visit our Customer Center.

Jun 7 2018
Navicat for MySQL (macOS) version 12.0.27

Improvements:

  1. Ability to copy comparison results of Model.
  2. Added thousand separators to the row count on the table objects list.

Bug Fixes:

  1. Crashed when opening Navicat if invalid characters were used for the paths in Preferences.
  2. The generated CREATE PROCEDURE statement was incorrect when dumping database to SQL file.
  3. Unable to execute Navicat commands using Automator.

To upgrade, please visit our Customer Center.

May 10 2018
Navicat for MySQL (macOS) version 12.0.26

Improvements:

  1. Supported to connect MySQL 8 using SHA2 connection.
  2. Supported coloring the Objects tab when a colored connection is selected.
  3. Improved table mapping in Import Wizard.
  4. Improved keyboard navigation with tab key in Import Wizard.

Bug Fixes:

  1. Left single quotation mark was wrong style when inputting in Form View.
  2. Extra "(" was added to INSERT statements when deploying scripts in Data Synchronization.
  3. Objects list loading was slow in some cases.
  4. Zero decimal place digits were not displayed in Table Viewer.

To upgrade, please visit our Customer Center.

Apr 23 2018
Navicat for MySQL (macOS) version 12.0.25

Bug Fixes:

  1. Incorrect SQL "ON UPDATE CURRENT_TIMESTAMP(0)" was dumped for MariaDB 5.5 tables.
  2. Crashed when starting Navicat.
  3. Unable to edit query results when tables had alias.
  4. Exported files were not attached to the notification email.
  5. Procedure Parameters was missing when synchronizing structure.
  6. Unable to filter connections in the Navigation Pane.
  7. Profile icons did not have indicator after adding attachments in Batch Job.

To upgrade, please visit our Customer Center.

Mar 28 2018
Navicat for MySQL (macOS) version 12.0.24

Bug Fixes:

  1. Unable to copy error messages in Query.
  2. Database name was added to the query when using Query Builder.
  3. XML file data was not imported to JSON fields completely.
  4. Unable to edit data in Query result set in some cases.
  5. Adjusting the height of split screen in Table Designer was not allowed.
  6. Crashed when selecting or editing Procedure SQL in Query Editor.
  7. Incorrect SQL was generated when changing Primary Key name in Table Designer.
  8. Query column width reset after restarting Navicat.
  9. Memory leak issue.
  10. "Fields" and "Referenced Fields" values were vanished after saving and moving cursor to another Foreign Key.
  11. Field properties were not shown when adding a field in Table Designer.
  12. Incorrect field name were shown when moving a field in Table Designer.
  13. UI issue in Full Screen mode.
  14. Exported Excel files were corrupted in some cases.

To upgrade, please visit our Customer Center.

Feb 22 2018
Navicat for MySQL (macOS) version 12.0.23

Improvements:

  1. Supported Microsoft Azure Database for MySQL.

Bug Fixes:

  1. Unable to open Console if a non-tabbed window was opened in font.
  2. Navicat hanged when refreshing table grid after changing field names.
  3. Navicat process was unable to terminate.

To upgrade, please visit our Customer Center.

Jan 22 2018
Navicat for MySQL (macOS) version 12.0.22

Bug Fixes:

  1. Error occurred when synchronizing structure in some cases.
  2. Enum type value returned as string in query results.
  3. Exported Excel files were corrupted in some cases.

To upgrade, please visit our Customer Center.

Jan 15 2018
Navicat for MySQL (macOS) version 12.0.21

Bug Fixes:

  1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jan 11 2018
Navicat for MySQL (macOS) version 12.0.20

Bug Fixes:

  1. Unable to open a table twice.
  2. Running multi-statement SQLs with delimiters issue.
  3. Crashed when adding default value in Table Designer.
  4. Crashed when clicking the Server Privileges tab in User Designer.
  5. Find feature in Table Viewer was not function correctly.
  6. Target object name was garbled when copying object named with non-ascii characters.
  7. Crashed when executing SQL to insert emoji to table.
  8. Crashed when performing Data Transfer in some cases.
  9. Navicat hanged when executing scripts in Data Synchronization.
  10. Unable to hide the Information pane permanently in Query.
  11. Preferences settings reset when Navicat started.
  12. Unable to stop query when using SSL connection.

To upgrade, please visit our Customer Center.

Dec 1 2017
Navicat for MySQL (macOS) version 12.0.19

Bug Fixes:

  1. Result tab was focused when explaining query.
  2. Query Plan result column was too narrow in Query.
  3. "\t" character was appended to the end of the row when copying data to text / Excel file.
  4. Unable to map fields in Import Wizard.
  5. Dump SQL File process was slow.
  6. Create new table wrongly when importing to existing table in some cases.
  7. Use old user to connect after changing new user name in Connection window.
  8. Unable to import decimal values when data has thousand separator.
  9. Crashed when searching on different pages in Table Viewer.

To upgrade, please visit our Customer Center.

Nov 13 2017
Navicat for MySQL (macOS) version 12.0.18

Bug Fixes:

  1. The database/schema combo-box did not work in Query.
  2. Manual refresh did not work in Server Monitor when auto-refresh was enabled.

To upgrade, please visit our Customer Center.

Nov 7 2017
Navicat for MySQL (macOS) version 12.0.17

Bug Fixes:

  1. Information panel retained when opening Navicat.
  2. Fixed importing connections with Settings Location issue.
  3. Command-D shortcut did not open Design form when viewing View data.
  4. Syntax error occurred when editing data in table with binary primary key.
  5. Unable to resize the assistant editor in Table Viewer.
  6. Fixed cursor focus issue in Console.

To upgrade, please visit our Customer Center.

Oct 17 2017
Navicat for MySQL (macOS) version 12.0.16

Bug Fixes:

  1. Syntax error occurred when creating MariaDB triggers in Table Designer.
  2. Unable to commit the same query twice.
  3. Unable to create the second filter by using context menu.
  4. Unable to reload or reopen tables after connection was timeout.
  5. Navicat hanged when opening large BLOB data in Hex Editor.

To upgrade, please visit our Customer Center.

Oct 10 2017
Navicat for MySQL (macOS) version 12.0.15

Bug Fixes:

  1. Save dialog prompted even no changes made in Table Designer.
  2. Query Builder loading was slow.
  3. Unable to execute query in some cases.
  4. Data synchronization crashed when HTTP connection was used.
  5. Unable to export views on High Sierra.

To upgrade, please visit our Customer Center.

Sep 26 2017
Navicat for MySQL (macOS) version 12.0.14

Bug Fixes:

  1. Error occurred when creating virtual columns in MariaDB Table Designer.
  2. Table Designer UI improvements.
  3. Font settings in Preferences reset to default after restarting Navicat.
  4. SQL Formatting was missing in the Triggers tab of Table Designer.
  5. Unable to delete fields in Table Designer.
  6. View Builder button was missing in View Designer.
  7. SSH connection hangs issue.
  8. Objects list loading was slow.
  9. Automation did not work when the profile name contained spaces.
  10. Syntax error occurred when filtering with ' character in Table Viewer.
  11. Unable to run DELIMITER $$ statements in Query.
  12. Navicat hanged when using normal OS user account.
  13. Duplicate Entry error occurred when importing with Append/Update mode.
  14. Sync Username to Navicat Cloud option was missing in Connection form.
  15. Navicat hanged when connection was cut off.

To upgrade, please visit our Customer Center.

Sep 5 2017
Navicat for MySQL (macOS) version 12.0.13

Bug Fixes:

  1. Auto increment field was ignored when importing
  2. Unable to set the default value of TEXT/BLOB field for MariaDB 10.2.1 or above.
  3. Error occurred when connecting to MariaDB in some cases.
  4. Navicat hanged when running a query export profile in some cases.
  5. Crashed when viewing or editing Functions.
  6. Code completion displayed unrelated items.

To upgrade, please visit our Customer Center.

Aug 24 2017
Navicat for MySQL (macOS) version 12.0.12

Bug Fixes:

  1. Replace All did not work in Table Viewer.
  2. Wrong row was inserted to when selecting foreign key value in Table Viewer.
  3. Memory error occurred when transferring tables.
  4. Suggested wrong table columns in code completion list.
  5. Context menu UI issue in some cases.
  6. Tables displayed as NEW in Import Wizard even it is already existed.
  7. Slow issue occurred when using code completion.
  8. Server name was missing in the window title bar of Console.
  9. Unable to add tables/views to Query Builder.

To upgrade, please visit our Customer Center.

Aug 8 2017
Navicat for MySQL (macOS) version 12.0.11

Bug Fixes:

  1. Crashed when executing query in some cases.
  2. Failed to sort by Modified Time, Created Time or Data Length in Detail view.
  3. Launching Import Wizard was slow.
  4. The month and day values were transposed when importing Date fields.
  5. Copy/Paste context menu was missing in Table Viewer.
  6. Crashed when creating new query without selecting a connection in Navigation pane.
  7. Unable to stop multiple processes in Server Monitor.
  8. Number of running processes was missing in Server Monitor.
  9. Table mapping was not in alphabetic order in Data Synchronization.
  10. Crashed when adding records in Table Viewer.
  11. Exported file name did not add timestamp when using Automation.
  12. Wrong SQL was generated for function in Structure Synchronization.
  13. In-App Purchases did not stay activated after restart the app.

To upgrade, please visit our Customer Center.

Jul 25 2017
Navicat for MySQL (macOS) version 12.0.10
  1. Crashed when exporting query result in some cases.
  2. Unable to show time values in Timestamp fields in Table Viewer.
  3. Lost focus when inputting auto increment value in Table Designer.
  4. Incorrect values displayed in MySQL "Data Length" column in Detail View.
  5. Table list was not sorted in Export Wizard.
  6. Backup object list in the Objects tab was not refreshed after finishing backup.
  7. Progress bar did not update when importing.

To upgrade, please visit our Customer Center.

Jul 14 2017
Navicat for MySQL (macOS) version 12.0.9

Bug Fixes:

  1. Unable to copy SQL in the bottom navigation bar of Table Viewer.
  2. Crashed when pasting SQL in Query Editor.
  3. Error occurred when opening MySQL databases in HTTP connection if enabled "Encode outgoing query with base64" setting.
  4. End Process item in the context menu was disabled in Server Monitor.
  5. Syntax error occurred when transferring MySQL data.
  6. Incorrect field names were shown in code completion suggestion list.

To upgrade, please visit our Customer Center.

Jul 10 2017
Navicat for MySQL (macOS) version 12.0.8

Bug Fixes:

  1. Fixed displaying object list slow issue.
  2. Fixed selecting user slow issue.
  3. Fixed the query builder window resize issue.
  4. Unable to show users in the Objects tab in some cases.
  5. Foreign key's Source Fields list was empty in Table Viewer.
  6. "Invalid default value" error occurred when transferring MySQL data.
  7. The Identifiers list in Query Editor did not show items.
  8. "Data Length" displayed in Bytes in Detail view.
  9. "Name" column width was too narrow in Detail view.

To upgrade, please visit our Customer Center.

Jul 4 2017
Navicat for MySQL (macOS) version 12.0.7

Bug Fixes:

  1. Unable to restore in some cases.
  2. Query Table shortcut was missing in Table Viewer.
  3. Foreign Key's reference database was not changed after transferring to other database.
  4. Crashed when launching the application.
  5. Unable to set range in Schedule Setup.
  6. SSH password was not imported when upgrading to Navicat 12.
  7. Memory leak issue in SQL Editor.
  8. Current active server/database was not selected when using CMD-Y shortcut to open New Query window.
  9. Syntax error occurred in Data Transfer.
  10. Sorting by modified/create date did not work for details view in main window.
  11. Unable to copy and paste data in Table Viewer.

To upgrade, please visit our Customer Center.

Jun 26 2017
Navicat for MySQL (macOS) version 12.0.6

Bug Fixes:

  1. Shift-Option-Arrow did not work for selecting a word in SQL Editor.
  2. Command-R did not refresh the list when database was selected.
  3. Unable to resize window in some cases.
  4. Unable to type some characters in editor when using international keyboard.
  5. Unable to sort the object list in the main window.
  6. Unable to log in Oracle server using lower case username.
  7. Exporting data with commas to CSV file issue.

To upgrade, please visit our Customer Center.

Jun 16 2017
Navicat for MySQL (macOS) version 12.0.5

Bug Fixes:

  1. Crashed when exporting large query results.
  2. Connection name was missing on the tab of Table Viewer.
  3. Crashed when exporting query results to CSV file.
  4. Query prompted for inputting the same parameter for every occurrence.
  5. Unable to accept Terms and Conditions when first login Navicat Cloud.

To upgrade, please visit our Customer Center.

Jun 9 2017
Navicat for MySQL (macOS) version 12.0.4

Bug Fixes:

  1. Crashed when accessing Function Object List.
  2. Wrongly showed primary key warning in View Viewer.
  3. 1142 error occurred when transferring data for MySQL.
  4. Query did not pop up Input Parameter dialog in some cases.
  5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jun 2 2017
Navicat for MySQL (macOS) version 12.0.3

Bug Fixes:

  1. Failed to connect MySQL with socket file.
  2. Crashed when opening Privilege Manager.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

May 31 2017
Navicat for MySQL (macOS) version 12.0.2

New Features:

  1. New UI/UX.
  2. On Startup: open favorite tabs automatically when Navicat launches.
  3. Code Snippet.
  4. Advanced Code Completion with better suggestions.
  5. Brand new Structure Synchronization: visually show side-by-side DDL comparison between two databases.
  6. Brand new Data Synchronization: show particular status to distinguish the differences between records easily.
  7. New Automation: easy to find desired profiles and create automated batch jobs.
  8. Responsiveness and performance improved.
  9. Many other new features and improvements.

To upgrade, please visit our Customer Center.

May 5 2017
Navicat for MySQL (Mac) version 11.2.18

Bug Fixes:

  1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Mar 1 2017
Navicat for MySQL (Mac) version 11.2.17

Bug Fixes:

  1. Failed to move procedures to a virtual group.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Dec 19 2016
Navicat for MySQL (Mac) version 11.2.16

Bug Fixes:

  1. Unable to show errors when running query in some cases.
  2. Failed to import JSON files in some cases.
  3. Query Editor window has disappeared when it lost focus.
  4. Some options were wrongly displayed in Essentials Edition.
  5. Settings Location was wrongly copied when duplicating connection.

To upgrade, please visit our Customer Center.

Oct 24 2016
Navicat for MySQL (Mac) version 11.2.15

Bug Fixes:

  1. The default date time format and delimiter of Export Wizard did not follow Import Wizard.

To upgrade, please visit our Customer Center.

Aug 31 2016
Navicat for MySQL (Mac) version 11.2.14

Improvements:

  1. Added some common keyboard shortcuts.

Bug Fixes:

  1. Failed to transfer tables when enabled "Convert object name" in Data Transfer.
  2. Crashed when opening Query view in some cases.
  3. Crashed when running backup tasks in Batch Job.

To upgrade, please visit our Customer Center.

Aug 3 2016
Navicat for MySQL (Mac) version 11.2.13

Bug Fixes:

  1. Crashed after exporting in some cases.
  2. Crashed when importing files with long field name.
  3. Failed to run "LOAD DATA LOCAL INFILE" statement in Query Editor.
  4. Column titles was unable to display properly in Form view when using large font size.
  5. Crashed when deleting tables with relations in Diagram view.

To upgrade, please visit our Customer Center.

Jul 5 2016
Navicat for MySQL (Mac) version 11.2.12

Improvements:

  1. Support utf8mb4 Character Set in MySQL and MariaDB connections.
  2. Support smart quotes in Query Builder.

Bug Fixes:

  1. Progress bar did not update in Data Transfer.
  2. Unable to expand connection tree in some case if the corresponding tab was not selected.
  3. Crashed while working with a profile in a virtual group.
  4. Unable to perform data synchronization using command line.
  5. Crashed when inserting record with RAW mode in Table Viewer.
  6. Failed to move multiple objects into a virtual group by right-click menu in Navicat Cloud connections.

To upgrade, please visit our Customer Center.

Apr 29 2016
Navicat for MySQL (Mac) version 11.2.11

Bug Fixes:

  1. Crashed when opening or closing Navicat Cloud database in some cases.
  2. Unable to beautify SQL keywords to upper case in Query Editor.

To upgrade, please visit our Customer Center.

Mar 30 2016
Navicat for MySQL (Mac) version 11.2.10

Bug Fixes:

  1. Fixed the column order issue when using Copy As Insert/Update in Table Viewer.
  2. Unable to insert empty string to fields with date time types if import date is empty since MySQL 5.7.
  3. Failed to close the parameter window after opening in Function Designer.
  4. App Store Essentials version: Failed to keep the "Show Object List" state in Query.

To upgrade, please visit our Customer Center.

Mar 1 2016
Navicat for MySQL (Mac) version 11.2.9

Bug Fixes:

  1. Functions were removed after editing the query in Query Builder.
  2. Unable to remember the file path if the path contains space in Export Wizard.
  3. Model History pane showed many changing color histories in some cases.

To upgrade, please visit our Customer Center.

Jan 28 2016
Navicat for MySQL (Mac) version 11.2.8

Bug Fixes:

  1. Background color of keyword "SUM" did not change with non-white background in Query Editor.
  2. Auto-completion did not work for 1 char alias in Query Editor.
  3. Extra database name was added when drag and drop a table to Query Builder.
  4. Crashed when creating backup in Cloud connections.
  5. Unable to create MySQL Enum column in Table Designer.
  6. Crashed when double-clicking the "Find in Database" result in some cases.
  7. Queries with "JOIN" was not parsed correctly in some case in Query Editor.

To upgrade, please visit our Customer Center.

Jan 14 2016
Navicat for MySQL (Mac) version 11.2.7

Bug Fixes:

  1. Wrongly added extra " char in the exported data when the data contained " char.
  2. Unable to open the Find result in "Find in Database".
  3. Unable to change the field order by dragging in the SELECT tab of View Builder.
  4. "Show Result" setting of Query was not saved immediately.
  5. Unable to disable the folding setting of Query Editor in Preferences.
  6. Crashed when double-click to select the query and run selected.
  7. User Name and Host were empty when duplicating a MySQL user.
  8. Crashed when loading server preferences from preference.plist file on launching Navicat.
  9. Unable to open the saved import profile.
  10. The http tunneling script was using the mysql extension of PHP which did not work in PHP 7.
  11. Unable to show [] with black background in Query Editor.
  12. Shortcuts CTRL-A, CTRL-E were missing in Query Editor.

To upgrade, please visit our Customer Center.

Dec 28 2015
Navicat for MySQL (Mac) version 11.2.6

Bug Fixes:

  1. Adding multiple relations issue in Model's Table Designer.
  2. Unable to uncheck the "Limit records per page" box in Table Viewer.
  3. Crashed when pasting SQL to Query Editor.
  4. Error occurred when saving views after applying Beautify SQL.

To upgrade, please visit our Customer Center.

Dec 22 2015
Navicat for MySQL (Mac) version 11.2.5

Bug Fixes:

  1. Unable to save the "Show Object List" option in Query.
  2. There was no syntax highlight in the SQL Preview tab.
  3. Unable to show the cursor in Query Editor with black background.
  4. Failed to drag and drop connection in some cases.
  5. Smart quote issue in Query Editor.
  6. Font issue in Query Editor.
  7. Find feature issue in Query Editor.
  8. Unable to copy more than 30 rows in Table/Query Viewer.

To upgrade, please visit our Customer Center.

Dec 16 2015
Navicat for MySQL (Mac) version 11.2.3

Bug Fixes:

  1. Pop-up options of selected cell were missing in Table Viewer.
  2. Objects tab was not selected when clicking an item in the Connection pane.
  3. Unable to resize the width of main window as Version 11.1.
  4. All field names were placed on the same line after applying Beautify SQL.
  5. Unable to show the column list of "Show/Hide Columns" in Table Viewer on Mac OS X 10.10.
  6. CMD+F shortcut did not work in the main window on Mac OSX 10.11.

To upgrade, please visit our Customer Center.

Dec 10 2015
Navicat for MySQL (Mac) version 11.2.2

Major New Features:

Navicat Cloud Collaboration

  1. Create/Modify/Delete projects.
  2. Add members to project for sharing connection settings, queries and models.
  3. View Project Activity Log.

Data Modeling Tool

  1. Support Model Conversion.
  2. Support Views.
  3. Enhanced Table Designer.

Others

  1. Enhanced Filter Wizard.
  2. Enhanced Query Designer.

To upgrade, please visit our Customer Center.

Nov 18 2015
Navicat for MySQL (Mac) version 11.1.17

Bug Fixes:

  1. Failed to log in Navicat Cloud in some cases.
  2. Crashed when running Structure Synchronization.

To upgrade, please visit our Customer Center.

Nov 3 2015
Navicat for MySQL (Mac) version 11.1.16

Bug Fixes:

  1. Unable to copy backup files to another database by drag and drop method.
  2. Crashed when running Data Transfer more than once on OS X 10.11.
  3. Froze when operating Table Viewer with longtext data.
  4. Crashed when running stored procedures on OS X 10.11.
  5. Crashed when adding password using MD5 function in Table Viewer Raw mode.
  6. Crashed when running SQL multi times in Console.
  7. Unable to set the default value of the bit type in Table Designer.

To upgrade, please visit our Customer Center.

Sep 16 2015
Navicat for MySQL (Mac) version 11.1.15

Bug Fixes:

  1. Showed wrong database in Connection Tree.
  2. Execute SQL file did not output errors in some cases.
  3. Lost local connections after Navicat crashed during synchronizing to Navicat Cloud.
  4. App Store version: In-App Purchase did not work in Mac OS X 10.11.

To upgrade, please visit our Customer Center.

Aug 3 2015
Navicat for MySQL (Mac) version 11.1.14

Improvements:

  1. Supported format strings in Schedule email body.

Bug Fixes:

  1. Unable to send notification email in Schedule.
  2. Created a new connection when previewing a view.
  3. Unable to change the case of the backup file name.
  4. Failed to synchronize Row Format when creating MySQL tables in Structure Synchronization.
  5. Lost connections in some cases.

To upgrade, please visit our Customer Center.

May 20 2015
Navicat for MySQL (Mac) version 11.1.13

Bug Fixes:

  1. Crashed when importing connections.
  2. Crashed when reversing database to model.

To upgrade, please visit our Customer Center.

Apr 20 2015
Navicat for MySQL (Mac) version 11.1.12

Bug Fixes:

  1. Object List tab did not change when selecting nodes from connection tree.
  2. Unable to send email when running batch jobs using Command Line.
  3. Failed to save the order of connections in Navicat Cloud.

To upgrade, please visit our Customer Center.

Mar 20 2015
Navicat for MySQL (Mac) version 11.1.11

Bug Fixes:

  1. Unable to edit BLOB field's text data on TEXT editor.
  2. Unable to use CMD-Y New Query shortcut after selected Tables, Views, etc nodes on Connection Tree.
  3. Failed to create/edit users for MySQL 5.7.6.
  4. Failed to run schedule for connections in Navicat Cloud.
  5. Cursor did not focus on Query Editor when opening a query.

To upgrade, please visit our Customer Center.

Mar 12 2015
Navicat for MySQL (Mac) version 11.1.10

Bug Fixes:

  1. Wrongly showed MySQL/MariaDB TEXT fields with collation xxx_bin as BLOB fields in Table Viewer.
  2. Fixed import DBF file with empty datetime value issue.

To upgrade, please visit our Customer Center.

Feb 5 2015
Navicat for MySQL (Mac) version 11.1.9

Improvements:

  1. Added the ability to copy column name with data and copy records as Insert/Update statements in Query/View Result.

Bug Fixes:

  1. Fixed the time interval setting issue in Schedule.
  2. Fixed the multi headers issue when exporting multi SELECT query to XML file.
  3. Fixed the warning issue when renaming query.
  4. Fixed unable to handle delimiter statements issue in Execute SQL File.

To upgrade, please visit our Customer Center.

Jan 20 2015
Navicat for MySQL (Mac) version 11.1.8

Improvements:

  1. Added the ability to copy column name with data in Table Viewer.

Bug Fixes:

  1. Crashed in SSH re-connection.
  2. Fixed the smart quotes/dashes issue in Query Builder.
  3. Fixed the data type issue when importing xlsx in Import Wizard.
  4. Fixed the creation of database/schema issue when no target database/schema name provided in Data Transfer.

To upgrade, please visit our Customer Center.

Dec 16 2014
Navicat for MySQL (Mac) version 11.1.7

Improvements:

  1. Show popup message if errors occur during dumping tables/databases/schemas to SQL file.

Bug Fixes:

  1. Crashed when using "Reverse Database to Model" feature.
  2. Crashed when the connection between server and client is disconnected.
  3. Unable to scroll on long query.
  4. Unable to re-send Navicat Cloud verification email.
  5. Result set scrolled to line 2 after executing the query in OS X 10.10 .

To upgrade, please visit our Customer Center.

Dec 2 2014
Navicat for MySQL (Mac) version 11.1.6

Improvements:

  1. Supported copy data as INSERT/UPDATE statements in Table Viewer.

Bug Fixes:

  1. Wrongly changed field type varchar(400) to BLOB for MySQL version 5.0.4 or above in Data Transfer.
  2. Editing data was not allowed sometimes in Table Viewer TEXT editor for MySQL/MariaDB.
  3. Failed to transfer MySQL tables with trigger in Data Transfer.
  4. Error occurred when changing the case of the connection name.
  5. Crashed when importing database/schema to Model.
  6. Crashed when creating Navicat Cloud account.
  7. Wrongly applied "Use smart quotes and dashes" setting in Console.

To upgrade, please visit our Customer Center.

Oct 13 2014
Navicat for MySQL (Mac) version 11.1.5

Bug Fixes:

  1. Navicat Cloud login checking restriction.
  2. The Select/Where/Group By/Having/Order By clasue bar disappeared in Query/View Builder.
  3. Connections are moved out from virtual groups after upgrading from version 11.0.
  4. Crashed when saving profiles.
  5. Failed to import date time field and float number from DBF files..
  6. Select fields panel in Table Designer did not update after the table was saved.
  7. INT type values were rounded up when importing XLS files.
  8. Table Designer view was not displayed corrently in HTTP connections.

To upgrade, please visit our Customer Center.

Sep 24 2014
Navicat for MySQL (Mac) version 11.1.4

Improvements:

  1. Customized column width and column order in Table Design are saved.

Bug Fixes:

  1. Failed to run Backup Server jobs for cloud connections in Schedule.
  2. Generated wrong query for field name with "." in Filter Wizard.
  3. Crashed when removing connection from a virtual group.
  4. Unable to save the Word Wrap setting in Table Text Editor.
  5. Crashed when creating a new virtual group in fresh installed Navicat.
  6. Connection list did not refresh automatically after dragging connections between Navicat Cloud and My Connections.

To upgrade, please visit our Customer Center.

Sep 17 2014
Navicat for MySQL (Mac) version 11.1.3

Bug Fixes:

  1. App Store Full version: Wrongly changed referenced schema after altered foreign key's referenced schema, table and fields in Table Design.
  2. The Object list could not display properly in Navicat main window.
  3. Failed to import all records from xls/xlsx files in Import Wizard.

To upgrade, please visit our Customer Center.

Sep 15 2014
Navicat for MySQL (Mac) version 11.1.1

Improvements:

  1. Added Show in Finder feature for Query, Backup and Model.
  2. Added Open with External Editor feature for Query.

Bug Fixes:

  1. Press CMD-F again did not highlight the text of the search field in Table Viewer.
  2. Crash when control-click a database in connection tree on OS X 10.9 below in Essentials version.
  3. Failed to save SSH password for Navicat Cloud connection.
  4. Unable to close Navicat with CMD-Q when opened more than one tabbed windows.

To upgrade, please visit our Customer Center.

Aug 25 2014
Navicat for MySQL (Mac) version 11.1.0

New Features:

  1. Support to sync selected connection settings, queries, model files and virtual group information to Navicat Cloud. For more information, please visit here.

Improvements:

  1. Support adding shapes in Model.

To upgrade, please visit our Customer Center.

Jul 31 2014
Navicat for MySQL (Mac) version 11.0.20

Bug Fixes:

  1. Crashed when adding foreign key under Table Designer in Data Modeling Tool.
  2. Crashed when running delimiter statement in Query Viewer.

To upgrade, please visit our Customer Center.

Jul 9 2014
Navicat for MySQL (Mac) version 11.0.19

Improvements:

  1. Support length of SSH password/private key passphrase increased from 99 to 255.
  2. Support to save name with "/" for Connection Save Path, Query, Import/Export/Backup profile, Backup, Schedule, Model, Data Transfer/Synchronization profile.
  3. Support syntax "ON UPDATE CURRENT_TIMESTAMP" and default value "CURRENT_TIMESTAMP" for datetime type (since MySQL 5.6.5) in Table Designer.

Bug Fixes:

  1. Crashed after opening Navicat for long time.
  2. Crashed when prompted to input password for SSH connection in Data Transfer, Data/Structure Synchronization and Server Monitor.
  3. Reduced the time needed to wait for connection timeout when disconnected to server.
  4. Non-ASCII characters not able to show in Hex Editor under Table Viewer.
  5. Some operations in main window did not popup error when error occurred.
  6. Time in Schedule tab for existing event did not show in Event Designer.
  7. When generated update query, identity column did not skip in Import Wizard.
  8. Crashed when modifying an error view.
  9. Website version: "SSH:Unknown Error!" error occured if doing any further action for SSH connection.

To upgrade, please visit our Customer Center.

May 22 2014
Navicat for MySQL (Mac) version 11.0.18

Bug Fixes:

  1. Crashed when copied and pasted a new row and committed the changes by clicking the "tick" button in Table Viewer.
  2. Export Wizard window did not show up for exporting query results.
  3. The title in Console window did not update into newly changed connection name.
  4. When typing single/double quote in Console, the quote would be changed into other char that did not recognized by server.

To upgrade, please visit our Customer Center.

May 8 2014
Navicat for MySQL (Mac) version 11.0.17

Improvements:

  1. Allow drag to reorder field as default in Table Designer.

Bug Fixes:

  1. Connection password was unable to be saved.
  2. The database names were truncated and the right half of the list was completely empty under advanced connections list in Connection Properties.
  3. The state of running in full screen was unable to be saved, so that Navicat only started up in window mode.
  4. Error message occured while viewing table structure to show the file path.
  5. Default value '''' turned into ''' in Table Designer.
  6. Disabled the vertical elastic effect to avoid wrong colour drawing for row index < 0 in Table Viewer.
  7. When previewed and enabled save queries to file, queries were not correctly written to the file in Data Synchronization.
  8. The file and file size position in Model info view were wrong.
  9. Crashed when right-clicked on an open area and seleted "Restore Backup".
  10. The bookmark setting of saved path was incorrect in Backup schedule.

To upgrade, please visit our Customer Center.

Mar 5 2014
Navicat for MySQL (Mac) version 11.0.16

Improvements:

  1. Now only column titles of the first result included when exporting multi dataset to the same file using Export Wizard.

Bug Fixes:

  1. Tab was unable to be dragged and reordered in full screen mode.
  2. Crashed when using Find function in Table Viewer.
  3. Copy and Paste did not work on tables with auto-incremented columns while saving a record by clicking "tick" icon in the Table Viewer.
  4. Crashed after changed the "Use advanced connections" and press "ok" button in Table Viewer.
  5. Parameter list not able to show while including CHARACTER type in function parameters in Function Designer.
  6. Crashed when selecting a suggested word that required quoting in Scintilla auto completion.
  7. Crashed while scrolling table in Query Builder and exited Navicat.
  8. int with "." as Thousand Separator did not import correctly in Import Wizard.
  9. The datetime format showed in the export profile did not match the format used in the original table.
  10. Date and time were exported incorrectly while using a EDT time zone.
  11. Message Log was unable to save correctly for the Preview function in Data Synchronization.
  12. Table dataset and collation info on CREATE TABLE queries not able to synchronize in Structure Synchronization.
  13. When changing a relation's referencing schema, the relation remained in the table but the relation line in diagram was removed under Table Designer in Data Modeling Tool.
  14. Crashed when double-clicking the connection tree under Synchronize to Database in Data Modeling Tool.
  15. Schedele helper did not work although jobs still run in old version.
  16. Website version: Typed in the export queries filepath directly would cause file creation error in Data Synchronization.
  17. App Store Essentials version: Crashed when purchasing Code Completion feature without SQL Builder in View Designer.

To upgrade, please visit our Customer Center.

Jan 7 2014
Navicat for MySQL (Mac) version 11.0.15

Improvements:

  1. Improved connection tree behavior in main window.
  2. Added Dynamic Column Editor for MariaDB in Table Viewer.

Bug Fixes:

  1. Database name was changed if failed to open it.
  2. Popup menu was shown far away when clicking on Diagram View or Model Design in retina display.
  3. Crashed when deleting active connection.
  4. Crashed when typing single digit in hour/minute/second field and press OK in table viewer.
  5. Unable to show error when getting database on open connection.
  6. Wrongly transformed MySQL date value in exported file.
  7. Crashed when closing the Export Wizard for exporting selected row in Table Viewer.

To upgrade, please visit our Customer Center.

Dec 20 2013
Navicat for MySQL (Mac) version 11.0.14

Improvements:

  1. Disabled zooming by magic mouse in Query Editor.

Bug Fixes:

  1. Failed to open table on Mac OS X 10.6.
  2. Unable to add view's profile to the virtual group.
  3. Unable to duplicate profiles.

To upgrade, please visit our Customer Center.

Dec 18 2013
Navicat for MySQL (Mac) version 11.0.13

Improvements:

  1. Added shortcut keys for "Save" and "Save As" in Data Synchronization.
  2. Enhanced Data Synchronization.
  3. Allow to select tag to identify data when exporting table to JSON format.
  4. Saved field selection window size in Table Designer.

Bug Fixes:

  1. Failed to duplicate MariaDB tables with virtual columns.
  2. Failed to copy Binary value in Table Viewer for MySQL 4.1.
  3. Crashed when running Explain on Mac OS X 10.6.
  4. Unable to close Server Monitor's popup dialog in Mac OS X 10.9.
  5. Enabled Open button and Restore Backup menu item when no backup profile is selected.
  6. Wrongly quoted the value in Export output file.
  7. Failed to save connection order in main window.
  8. Editor failed to show when first open the Table/View Viewer.
  9. Unable to save the resultset's column width after re-run the query.
  10. App Store version: Failed to list tables after connected.
  11. Website version: Unable to send attachments in Schedule.

To upgrade, please visit our Customer Center.

Nov 8 2013
Navicat for MySQL (Mac) version 11.0.12

Bug Fixes:

  1. Command-F unable to close the search function in main window.
  2. Export Wizard wrongly to get Time Delimiter as Decimal Delimiter.
  3. Crashed while printing diagram in Data Modeling Tool.
  4. Data Synchronization dialog window stayed opened.

To upgrade, please visit our Customer Center.

Oct 31 2013
Navicat for MySQL (Mac) version 11.0.11

Improvements:

  1. Compatible with Mac OS X 10.9 Mavericks.

Bug Fixes:

  1. Crashed on tabbed window.
  2. Failed to import JSON file.
  3. App Store version: Error on export path during Export Wizard in Mac OS X 10.9.

To upgrade, please visit our Customer Center.

Sep 30 2013
Navicat for MySQL (Mac) version 11.0.10

Improvements:

  1. Suppport larger row limit for xlsx version, 1048576 rows in Export Wizard.

Bug Fixes:

  1. No popup error showed in Table Viewer.
  2. Failed to find the next match in Find Next action after selecting a cell in Table Viewer.
  3. Crash occured in Query Editor.
  4. Fixed the auto increment value while altering table in Structure Synchronization.

To upgrade, please visit our Customer Center.

Sep 9 2013
Navicat for MySQL (Mac) version 11.0.9

Improvements:

  1. New tab window control.

Bug Fixes:

  1. Crash occured while deleting tables with foreign keys on ER diagram.
  2. Options missing in Export profile.
  3. Fixed support "," in schedule time setup.
  4. The text colour in Text Editor did not follow the "Common" colour in Preferences.
  5. Corrupt occured after updating and showing binary type text in Table Viewer.
  6. After selected a cell in Table Viewer, cmd + F not able to focus on the search field if search bar was already shown.
  7. Failed to update setting controls immediately after guessing the field type from newly added field name in Table Designer.
  8. Website version: Failed to show Navicat 10 Import file entries in Navicat 11.

To upgrade, please visit our Customer Center.

Aug 7 2013
Navicat for MySQL (Mac) version 11.0.8

Bug Fixes:

  1. Default value of date, time, datetime, timestamp type was not quoted for Create SQL in Table Designer and Data Transfer.
  2. Error not log during fetching rows in Data Transfer.

To upgrade, please visit our Customer Center.

Jul 25 2013
Navicat for MySQL (Mac) version 11.0.7

Bug Fixes:

  1. Crashed when set objects as auto-save.
  2. Failed to save position and size when closing windows.
  3. Default value was double quoted for Create SQL in Table Designer and Data Transfer.

To upgrade, please visit our Customer Center.

Jul 23 2013
Navicat for MySQL (Mac) version 11.0.6

Improvements:

  1. Added Crontab Format: range, list, step to date settings in Schedule.

Bug Fixes:

  1. Crashed while created and saved foreign key in main window with HTTP connection.
  2. Wrong SQL was generated when setting default value to empty string and not able to select "(EMPTY STRING)" after saved in MySQL Table Designer.
  3. Crashed when opening server/catalog level export profiles.
  4. Failed to set the string in Export Wizard's export file path text field.
  5. Failed to open export profile as file in veriosn 11.0.5.
  6. Failed to import number from Excel in Import Wizard.

To upgrade, please visit our Customer Center.

Jul 10 2013
Navicat for MySQL (Mac) version 11.0.5

Improvements:

  1. Updated libxl to 3.5.3.
  2. Adjusted caret color same in Scintilla.
  3. Support sorting items by name inside a virtual group.

Bug Fixes:

  1. SSH connection random crashed.
  2. Fixed number of virtual grouping issues.
  3. Crashed in Query Viewer.
  4. Select/Paste function did not work on the newly added rows in Table Viewer/Query Viewer.
  5. Text/Blob Editor in Table Viewer was reallocated the data in selected cell after refreshed.
  6. Values did not always change in Table Viewer if modified in Query Viewer.
  7. Query not found error occured in Query Favorites feature.
  8. Fixed scrolling issue in Store Procedure.
  9. Export failed in query result.
  10. Crashed in Structure Synchronization.
  11. Create table did not work on different source and target version in Structure Synchronization.
  12. Fixed auto increment value for create and alter SQL in Structure Synchronization.
  13. "Commands out of sync; you can't run this command now" error occured while creating new user with table privileges.
  14. App Store version: Error occured when adding images in Data Modeling Tool.

To upgrade, please visit our Customer Center.

Jun 10 2013
Navicat for MySQL (Mac) version 11.0.4

Bug Fixes:

  1. HTTP connection did not work properly.

To upgrade, please visit our Customer Center.

Jun 7 2013
Navicat for MySQL (Mac) version 11.0.3

Bug Fixes:

  1. Crashed occured when connection opened for a long time.
  2. SSH Public key settings was unable to be saved in duplicate connection.
  3. Crashed occured when deleting objects from ER Diagram view.
  4. Crashed occured when applying filter during the data loading process.
  5. Crashed occured in Query Editor when running an empty query.
  6. Progress indicator in Query viewer result kept spinning after rows inserted.
  7. View definers was unable to be saved.
  8. Infinite looping in Export Wizard while exporting selected rows.
  9. Crashed occured in Server Monitor while getting the process list.
  10. Data model files not opened while they were not saved in default folder.

To upgrade, please visit our Customer Center.

May 26 2013
Navicat for MySQL (Mac) version 11.0.2

Bug Fixes:

  1. SSH connection would keep asking for public key passphrase even the save passphrase/password was checked.
  2. Crashed in ER Diagram when loading and showing diagrams simultaneously.
  3. When exported dataset from and unsaved query, the export file name is now marked as "Untitled".
  4. Duplicated queries were run when exporting result set in Query Viewer.
  5. Crashed occured when closing the Export Wizard after exported the result set in Query Viewer.

To upgrade, please visit our Customer Center.

May 22 2013
Navicat for MySQL (Mac) version 11.0.1

Improvements:

  1. Improved tab behavior in Navicat main.
  2. Reduced memory usage when opening Table Viewer.
  3. Support to print and export PDF files with paper size that not available for the printer in Data Modeling Tool.

Bug Fixes:

  1. Crashed in Table Designer with HTTP connection established.
  2. Sorting function did not work properly.
  3. Find Next/Previous in Find and Replace function went wrong after drag and drop column.
  4. The result range not highlighted in Find function.
  5. Blank page appeared in Table Viewer while scrollling down to the end of the page and switching to the last page, when the table contained more than 1000 rows.
  6. Links between join tables would lost in Query/View Builder.
  7. Query was unable to parse the delimiter properly.
  8. Duplicated queries were run when exporting result set in Query Viewer.

To upgrade, please visit our Customer Center.

Apr 30 2013
Navicat for MySQL (Mac) version 11.0.0

Major New Features:

Native 64-bit version

Interface

  1. New User Interface
  2. New docking system

Connection

  1. New SSH Manager
  2. Connection Tree Filter

Table Viewer

  1. Find and Replace data
  2. Search Columns
  3. Support Transaction

Table Designer

  1. Search Columns
  2. Field Type Prediction

Query

  1. Support showing multiple results

Import Wizard

  1. JSON file
  2. Excel file 2007 (*.xlsx, *.xlsm)
  3. MS Acess database (*.mdb, *.accdb)

Export Wizard

  1. JSON file
  2. Excel file 2007 (*.xlsx)

Others

  1. New Registration and Activation System
  2. New Updater

To upgrade, please visit our Customer Center.

Feb 7 2013
Navicat for MySQL (Mac) version 10.1.3

Bug Fixes:

  1. Connection kept opening even the form was closed.
  2. Table names in ER Disgram view could not be renamed.
  3. Font size in SQL Editors were too large in retina display.
  4. Crashed while opening DBF import profile with Field Delimiter = "" in Import Wizard.
  5. "Disable foreign key checks" option in Data Synchronization was ignored in Schedule.
  6. Stored Procedure failed to catch the returned error message when saving an illegal statements.
  7. Definition in Function Designer was unable to return correctly with COLLATE attribute.

To upgrade, please visit our Customer Center.

Nov 15 2012
Navicat for MySQL (Mac) version 10.1.2

Improvements:

  1. Support Turkish char input in scintilla.
  2. Allowed to save an export profile for a running query.

Bug Fixes:

  1. Slow performance experienced when editing on grid due to allocation of field editor menu on demand.
  2. Export file name with date format was excluded in the saved export profile.
  3. Incorrect orientation and size were set while printing model in Data Modeling Tool.
  4. Error messages occurred when adding a pkey auto-increment column in Synchronize to Database function under Data Modeling Tool.
  5. Sorting columns with numeric values was not working properly in Server Monitor.
  6. The Explain tab in Query did not return error message when query contained a non-existent column.
  7. When scheduling an export job with sending mail attachment, the attachment failed when the exported file name contained datetime.

To upgrade, please visit our Customer Center.

Aug 8 2012
Navicat for MySQL (Mac) version 10.1.1

Improvements:

  1. The full queries are now shown in Tooltips in "Synchronize to Database" under Data Modeling Tool.

Bug Fixes:

  1. Scintilla font size doubled in Apple retina display.
  2. Popup window did not show while clicking on Delete item button with no rows being selected in Table Designer.
  3. Datetime value was not obtained correctly from ODBC in Import Wizard.
  4. Index and unique were missing under Data Modeling Tool Table Designer.

To upgrade, please visit our Customer Center.

Jun 15 2012
Navicat for MySQL (Mac) version 10.1.0

Improvements on Data Modeling Tool:

  1. Support Unsigned for Numeric Type.
  2. Support Auto Increment for Integer Type.
  3. Build model with multiple schemas.
  4. New wizard "Import from Database".
  5. New wizard "Synchronize to Database".
  6. Align/Distribute diagram objects.

To upgrade, please visit our Customer Center.

Mar 15 2012
Navicat for MySQL (Mac) version 10.0.7

Improvements:

  1. Increased the limit of number of joins allowed in Query Builder.
  2. Improved the working area on Query Builder.

Bug Fixes:

  1. Fixed a crash issue when re-running a query in Query Viewer.
  2. Fixed the failure of sending email in Schedule.

To upgrade, please visit our Customer Center.

Jan 19 2012
Navicat for MySQL (Mac) version 10.0.6

Bug Fixes:

  1. Fixed the failure of printing PDF in Model Designer.
  2. Fixed the bug of DISTINCT clause disappeared in Query Editor after using Query Builder.
  3. Fixed the slow response issue when opening Execute SQL File window.
  4. Fixed a crash issue when using Beautify SQL.
  5. Fixed the crash issue when quitting process in Server Monitor.

To upgrade, please visit our Customer Center.

Dec 9 2011
Navicat for MySQL (Mac) version 10.0.5

Bug Fixes:

  1. Fixed the crash issue when clicking on an object inside a virtual group, having "Click to refresh object list" option was enabled in Preferences.
  2. Fixed the SQL error when using Custom Filter in Filter Wizard.
  3. Fixed the bug in Query Builder where functions were not displayed properly.

To upgrade, please visit our Customer Center.

Nov 24 2011
Navicat for MySQL (Mac) version 10.0.4

Improvements:

  1. SQL scripts copy from Structure and Model Synchronization comparison results are now formatted properly.
  2. Field orders are now properly synchronized in Structure Synchronization.

Bug Fixes:

  1. Fixed the crash issue when importing tab-delimited file on Mac OS X 10.5.
  2. Fixed the problem of importing null values into newly created fields in Import Wizard.

To upgrade, please visit our Customer Center.

Nov 4 2011
Navicat for MySQL (Mac) version 10.0.3

Improvements:

  1. Added hidden option to disable transaction in Stored Procedure in connection.

Bug Fixes:

  1. Fixed Data Transfer encoding issue when charset was disabled.
  2. Fixed the bug on the comparison of field character set.
  3. Fixed the refresh problem after reordered the fields in ER diagram view.
  4. Fixed the reload time issue after saving table.
  5. Fixed the bug occurred when selecting weekday in Schedule setup panel.

To upgrade, please visit our Customer Center.

Sep 30 2011
Navicat for MySQL (Mac) version 10.0.2

New Feature:

  1. Support connection coloring.

Improvements:

  1. Settings are now stored in ~/Application Support/PremiumSoft CyberTech folder instead of ~/Application Support/Navicat.
  2. Support of setting socket timeout in Connection Properties.
  3. Support of dumping SQL file with selected tables.
  4. Added option to enable/disable comparing character set in Structure Synchronization.

Bug Fixes:

  1. Fixed the Structure Synchronization index and default problem.
  2. Fixed the missing Foreign Keys when reversing tables to model.
  3. Fixed the issue of selecting wrong database type when reversing tables to model.

To upgrade, please visit our Customer Center.

Sep 12 2011
Navicat for MySQL (Mac) version 9.1.8

Bug Fixes:

  1. Fixed the problem of wrong encoding used when loading queries.
  2. Fixed the issue of not saving a Data Synchronization advanced setting as profile.
  3. Fixed the crash problem when started with the main toolbar hidden.
  4. Fixed the issue of not quoting keyword when creating table.
  5. Fixed the problem of returning wrong value for FOUND_ROWS() function.

To upgrade, please visit our Customer Center.

Sep 6 2011
Navicat for MySQL (Mac) version 10.0.1

Major New Features:

  1. Data Modeling Tools.
  2. ER Diagram view.
  3. SQL Minifier.
  4. Database Wide Search.

Improvements:

  1. Ability to run transaction backup for MySQL database (InnoDB only).
  2. Added object list in Query Editor.
  3. Added DDL tab in Object Information.

To upgrade, please visit our Customer Center.

Jun 2 2011
Navicat for MySQL (Mac) version 9.1.7

Improvements:

  1. Improved the situation of losing connection in connection.

Bug Fixes:

  1. Fixed the occasionally hang problem in Query Builder.
  2. Fixed the problem of failing to run Data Synchronization batch job.
  3. Fixed the problem of improperly quoted index expressions in Backup and Table Designer.
  4. Fixed the problem of occasionally displaying blank cell in Table Viewer.
  5. Fixed the problem of continuously adding row when pressing Down Arrow button in Table Viewer.

To upgrade, please visit our Customer Center.

Apr 14 2011
Navicat for MySQL (Mac) version 9.1.6

Improvements:

  1. Shorten the timeout when attempting to reconnect to server.

Bug Fixes:

  1. Append/Update option did not work in Import Wizard.
  2. Unable to open SQL files with some encodings.

To upgrade, please visit our Customer Center.

Feb 21 2011
Navicat for MySQL (Mac) version 9.1.5

Bug Fixes:

  1. High CPU usage when pausing the process of Data Transfer/Data Sync/Structure Sync/Execute SQL File.
  2. Cmd-Shift + Arrow Key shortcut keys were improperly overwritten by the shortcut keys of the tabbed windows.

To upgrade, please visit our Customer Center.

Jan 18 2011
Navicat for MySQL (Mac) version 9.1.4

Improvements:

  1. Elapsed time is now shown for each query in Query Viewer.
  2. The first level tag in XML file is now recognized as the record indicator during Import Wizard.

Bug Fixes:

  1. Queries list in main window was not refreshed after transferring queries.
  2. Crashed when refreshing tables after Record per Page setting had changed in Table Viewer.
  3. After deleting a record, the next record is now selected instead of the final record in Table Viewer.
  4. Improper ENUM fields default values were listed for selection in Table Designer.
  5. Mode selections were ignored under "Advanced Settings" tab in Data Synchronization.

To upgrade, please visit our Customer Center.

Dec 14 2010
Navicat for MySQL (Mac) version 9.1.3

Bug Fixes:

  1. Crashed when synchronizing data between MySQL 4 to MySQL 5.
  2. Failed to add object privileges in User Designer form.

To upgrade, please visit our Customer Center.

Dec 1 2010
Navicat for MySQL (Mac) version 9.1.2

Bug Fixes:

  1. Data Synchronization did not working properly.
  2. Crashed when trying to add row in Form Viewer.

To upgrade, please visit our Customer Center.

Nov 25 2010
Navicat for MySQL (Mac) version 9.1.0

Major New Features:

  1. Support of MySQL Server 5.5.
  2. Support of geometry data type.
  3. Support BTREE and HASH index methods.
  4. New Privilege Manager.
  5. Enhanced User management.
  6. Data Synchronization performance improved with new engine.

To upgrade, please visit our Customer Center.

Oct 27 2010
Navicat for MySQL (Mac) version 9.0.12

Improvements:

  1. "Explain Selected" is now added to context menu in Query Viewer.

Bug Fixes:

  1. Failed to save the status of "Save Passphrase" in SSH panel in Connection properties.
  2. Create time and update time were not displayed properly in Information View.
  3. Crashed when applied searching on some columns which were hidden under Show/Hide Columns panel in Table Viewer.
  4. Crashed when switching from Query Editor to Query Builder with a specific SQL statement.
  5. Crashed if failed to open view in View Designer.
  6. Failed to backup binary/varbinary.

Upgrade Procedure : click here to upgrade

Sep 21 2010
Navicat for MySQL (Mac) version 9.0.11

Improvements:

  1. Shortcut keys are now added back in Query Viewer.
  2. Text Qualifier can now be manually set during Export Wizard.

Bug Fixes:

  1. Crashed if the returned error messages contain specific character in Query Viewer.
  2. Long column names were truncated in Query Builder.
  3. Incorrect time values were sometimes imported during Import Wizard.

Upgrade Procedure : click here to upgrade

Aug 30 2010
Navicat for MySQL (Mac) version 9.0.10

Improvements:

  1. "Test Connection" action can now be canceled in Connection Properties.
  2. Text Qualifier can now be freely set to any characters during Import Wizard.

Bug Fixes:

  1. If a group contained more than two connections, error would occur when trying to delete the group.
  2. Updated rows in Query Viewer were reverted back to their previous value after highlighting another rows.
  3. Navicat hanged when importing multiple files using Import Wizard.
  4. Error message could not be displayed if "Continue on Error" was not checked in Data Transfer.
  5. Memory allocation problem when the manual was opened.

Upgrade Procedure : click here to upgrade

Jul 29 2010
Navicat for MySQL (Mac) version 9.0.9

Bug Fixes:

  1. Changes on SSH settings in Connection Properties would only be applied after Navicat restarted.
  2. In Mac OS X 10.4, Navicat would crash when opening tables with foreign keys.
  3. Menu bar did not display properly when running in Mac OS X 10.4.
  4. Navicat hanged when switching to some object pages in main window when running in Mac OS X 10.4.
  5. Some buttons and text were not displayed properly in Mac OS X 10.4.

Upgrade Procedure : click here to upgrade

Jul 5 2010
Navicat for MySQL (Mac) version 9.0.8

Improvements:

  1. Connection name is now shown in the title bar of Console window.

Bug Fixes:

  1. Query results were unable to be edited under HTTP Tunnel connection.
  2. Failed to display Unsigned bigint values properly.
  3. The referencing database of foreign keys were not properly transferred to files.
  4. If the decimal symbol was not set as period (.), incorrect decimal values may be imported for excel files.

Upgrade Procedure : click here to upgrade

Jun 23 2010
Navicat for MySQL (Mac) version 9.0.7

Bug Fixes:

  1. HTTP Tunnel did not work properly when some specific characters appeared in username or password.
  2. Failed to prompt for entering HTTP authentication password even password was not saved.
  3. MySQL Bit fields were not displayed properly in Console.

Upgrade Procedure : click here to upgrade

Jun 9 2010
Navicat for MySQL (Mac) version 9.0.6

Improvements:

  1. Show the host information under Connection Information view.

Bug Fixes:

  1. Failed to transfer Foreign Key to target server if the target database name was different to the source database name.
  2. Memory allocation problem which may cause Navicat to crash when transferring data using Data Transfer.
  3. Incorrect values were synchronized during Data Synchronization.
  4. Crashed easily when running queries in Query Viewer.

Upgrade Procedure : click here to upgrade

May 20 2010
Navicat for MySQL (Mac) version 9.0.5

Improvements:

  1. If the row is selected, Filter Wizard will now display the words in white color.
  2. Query Builder supports to show diagram for some incomplete statement.

Bug Fixes:

  1. Crashed when getting server Information on Information View if connection failed.
  2. Improper join lines were displayed when joining multiple tables in Query Builder.
  3. Crashed when parsing some improper SQL statements.
  4. Wrong bit field default values were displayed in Table Designer for MySQL version 5.1.31 or above.

Upgrade Procedure : click here to upgrade

May 11 2010
Navicat for MySQL (Mac) version 8.1.12

Bug Fixes:

  1. Wrong Bit field default value got from MySQL Server 5.1.30 or below.

Upgrade Procedure : click here to upgrade

May 6 2010
Navicat for MySQL (Mac) version 9.0.4

Improvements:

  1. Added a section in Query View Result tab so that it can now show the sql and the query time.
  2. Query result data can now be exported even if the sql is not saved.

Bug Fixes:

  1. Failed to edit table data under HTTP Tunnel connection.
  2. Failed to edit data in Views.
  3. View Builder could not generate the corresponding GUI component from the query in View Editor.
  4. Crashed when running SQL query under HTTP tunnel connections.
  5. Failed to delete data inside the cells in Table Viewer by pressing Delete button.

Upgrade Procedure : click here to upgrade

Apr 30 2010
Navicat for MySQL (Mac) version 9.0.3

Improvements:

  1. Added shortcut keys for bottom bar buttons in Table Viewer.
  2. Adjusted the cell editable only when those data is allowed to update in Query Viewer.
  3. Improved the dynamic width for Code/Word completion window.
  4. New lines are now not exported as \n during Export Wizard.

Bug Fixes:

  1. Dragging images into Image Editor were converted to tiff format.
  2. "Format" menu flashed frequently on Mac 10.5.
  3. Some SQL statements would cause Navicat crashed when switching to Query Builder.

Upgrade Procedure : click here to upgrade

Apr 16 2010
Navicat for MySQL (Mac) version 8.1.11

Bug Fixes:

  1. Crashed when comparing non-ascii table name during Structure Synchronization.
  2. MySQL Event status shown incorrectly in Detail View/Information View.
  3. Hangged when executing some SQL file using Execute SQL File function in Mac 10.6.

Upgrade Procedure : click here to upgrade

Apr 12 2010
Navicat for MySQL (Mac) version 9.0.2

Main New Features:

  1. Import/Export connection.
  2. Significant Improvements made in code/word completion.
  3. Code Folding.
  4. Matched Brace/Bracket Highlighting.
  5. Parameter Tips.
  6. Zoom In/Out for SQL editors.
  7. SQL Beautifier.
  8. Favorites.
  9. Object Filter.
  10. Individual database objects backup.
  11. Unicode Character Report.
  12. Auto save in Query, Function etc.
  13. Custom sort in Tabler Viewer.
  14. Significant Improvements made in editor and data grid searching.
  15. Notification email supports SSL/TLS in Schedule.
  16. History Log Viewer.

Upgrade Procedure : click here to upgrade

Mar 26 2010
Navicat for MySQL (Mac) version 8.1.10

Improvements:

  1. Maintain Table will now show the full message reported by the server after operation.

Bug Fixes:

  1. Failed to import xml file with values inside xml attributes during Import Wizard.
  2. Failed to backup the server in schedules.
  3. Wrong File menu would be shown sometimes in main window.

Upgrade Procedure : click here to upgrade

Feb 11 2010
Navicat for MySQL (Mac) version 8.1.9

Improvements:

  1. Improved the compatibility in MySQL SSL connection.
  2. Improved the support of bigger data in each cell of Excel file during Export Wizard.
  3. It now has no restriction on jointing the data type fields in Query Builder.

Bug Fixes:

  1. Deadlock occured when opening new windows using SSH Connection.
  2. Fixed crash problem during Import Wizard.
  3. The "Run" button would be disabled in some cases even the SQL stopped running in Query Editor.

Upgrade Procedure : click here to upgrade

Jan 21 2010
Navicat for MySQL (Mac) version 8.1.8

Bug Fixes:

  1. Connections were not freed before quitting Navicat.
  2. Failed to establish MySQL SSL connection.
  3. Form View would crash when editing with no row selected.
  4. Wrong linkage was shown for field name with capital letters in Query Builder.

Upgrade Procedure : click here to upgrade

Dec 21 2009
Navicat for MySQL (Mac) version 8.1.7

Improvements:

  1. MySQL Triggers will now include in Dump SQL file.
  2. Improved the internal code to avoid some crash that would occur.

Bug Fixes:

  1. Error would occur when importing date with 2 digit with "Four Digit Years" checked in Import wizard.
  2. Failed to list MySQL Views in Manage User window.
  3. MySQL Table Viewer would crash after added a row without changing its value.
  4. Crashed when saving views with name in capital letter on MySQL server with lower_case_table_names variable not equal to 0.
  5. MySQL syntax error occurred when creating tables with foreign key in Table Designer.

Upgrade Procedure : click here to upgrade

Nov 19 2009
Navicat for MySQL (Mac) version 8.1.6

Bug Fixes:

  1. Failed to change the definition of an existing MySQL Foreign Key in Table Designer.
  2. The SQL statement to create foreign key mistakenly included the name of source database in MySQL Structure Synchronization.
  3. Data Transfer, Data Synchronization and Structure Synchronization Profiles selection box would display improperly if Toolbar Appearance was set as "Text Only".
  4. Navicat Import Wizard was unable to recognize some xml attributes properly.
  5. When modified Index in Table Designer, Some changes could not be recognized.
  6. Failed to display the referencing table list when editing existing Foreign Key in Table Designer.
  7. The first record could not be selected in Table Form View under Mac OS 10.6.
  8. Navicat crashed if the network drive could not be found during the Backup process.

Upgrade Procedure : click here to upgrade

Oct 16 2009
Navicat for MySQL (Mac) version 8.1.5

Improvements:

  1. Improved compatibility to some ODBC drivers for Import Wizard.

Bug Fixes:

  1. Incorrect use of hexadecimal format in MySQL data types other than BLOB in Data Transfer.
  2. Data grid was unable to be opened properly when some kind of text were displayed.
  3. Removed some internal SQL run by Navicat in Query Viewer.
  4. Unable to change the default value of an existing field from NULL to other values in Table Designer.

Upgrade Procedure : click here to upgrade

Sep 21 2009
Navicat for MySQL (Mac OS X) version 8.1.4

Improvements:

  1. Export Wizard is now able to export data filering result.
  2. Text fields are now imported with text data instead of hex to prevent potential encoding problems which may occur for MySQL server.

Bug Fixes:

  1. When set Foreign Keys in MySQL Table Designer, foreign key info could not be displayed properly if the Reference Database field included dot character.
  2. Foreign Key Data Selection window was unable to show Text field data, it showed [TEXT] instead.
  3. When set criteria using BETWEEN keyword in Filter Wizard, error message would occur.
  4. Crashed when running sql in MySQL 4.1.14.

Upgrade Procedure : click here to upgrade

Sep 1 2009
Navicat for MySQL (Mac OS X) version 8.1.3

Improvements:

  1. Compatible with Mac OS X Snow Leopard.
  2. Stability improvement on tabbed window.

Bug Fixes:

  1. Import Wizard would be launched if the Data format was not properly set.

Upgrade Procedure : click here to upgrade

Jul 29 2009
Navicat for MySQL (Mac OS X) version 8.1.2

Improvements:

  1. Support quitting the Console window by "exit", "quit" or "\q" command.
  2. Improved the stability when running a query.

Bug Fixes:

  1. Some windows size and position were not saved after closed.
  2. Recalling multi-line history commands in Console were not displayed properly.
  3. "Copy to Clipboard" did not show host name.

Upgrade Procedure : click here to upgrade

Jul 15 2009
Navicat for MySQL (Mac OS X) version 8.1.1

Enhancement:

  1. Support choosing server version for SQL to be generated in Data Transfer, support more transfer options.
  2. Added connection tree to support batch jobs from different databases.
  3. Compatibility and speed improvement in exported excel format.
  4. Notification email in batch job is now delivered in MIME format.
  5. Support Profile and Status in Query View for MySQL server.
  6. Allow setting fonts in Data Grid, and apply Editor Font to View/Edit Text.

Bug Fixes:

  1. Navicat could not quit normally in some senarios.
  2. View Builder did not display properly.
  3. Slow problem when opening Query View.
  4. Improper ordering of the generated SQL during Structure Synchronization.

Upgrade Procedure : click here to upgrade

May 18 2009
Navicat for MySQL (Mac OS X) version 8.0.7 is now available

Bug Fixes:

  1. Duplicated tables are sometimes displayed in Query Builder.
  2. Crash when changing the default value of bit fields in Table Design.
  3. Crash when no profile name are specified in command line backup and export.
  4. Code completion not working properly on unicode characters.

Upgrade Procedure : click here to upgrade

Apr 27 2009
Navicat for MySQL (Mac OS X) version 8.0.6

Enhancement:

  1. Added Control-click menu on Form View of Table View.

Bug Fixes:

  1. Crash when running some custom queries in Query View.
  2. Backup failed to restore after renaming.

Upgrade Procedure : click here to upgrade

Apr 2 2009
Navicat for MySQL (Mac OS X) version 8.0.5

Improvement:

  1. Improved speed to open a Query View window.

Bug Fixes:

  1. Only one Foreign Key Data Selection button is shown even when multiple Foreign Key fields are found.
  2. "Copy to Clipboard" feature crash Navicat if Advanced Connection is set.
  3. Slow loading large sql into Query View.
  4. Error generating SQL in some cases.
  5. Crash when running empty statements.

Upgrade Procedure : click here to upgrade

Mar 10 2009
Navicat for MySQL (Mac OS X) version 8.0.4

Bug Fixes:

  1. Navicat hung when running Data Transfer in Batch Job.
  2. Decimal value cannot be set inside the Parameter edit control in Stored Procedure.
  3. Failed to synchronize views in Structure Synchronization.
  4. Failed to re-create the original trigger if error occured when saving in Table Designer.
  5. The status of Grid View/Form View cannot be saved in Table Viewer.

Upgrade Procedure : click here to upgrade

Mar 3 2009
Navicat for MySQL (Mac OS X) version 8.0.3

Bug Fixes:

  1. Data synchronization does not working properly when synchronizing tables with multiple fields.
  2. Cannot alter stored procedures in MySQL server versions below 5.0.20.
  3. Some connection info are not displayed in HTTP tunnel connections.
  4. Null values are not properly handled in ODBC Import.
  5. Error messages cannot be displayed if xml files failed to parse.

Upgrade Procedure : click here to upgrade

Feb 23 2009
Navicat for MySQL (Mac OS X) version 8.0.2

Bug Fixes:

  1. Failed to export excel files in PPC mac.
  2. SQL generated from query builder included database names.
  3. Improper length for text fields in Form View.
  4. Error when exporting queries which are not yet saved.
  5. Failed to display escaped characters in stored procedures.
  6. Numbers are imported improperly.

Upgrade Procedure : click here to upgrade

Feb 16 2009
Navicat for MySQL (Mac OS X) version 8.0.1

Major new features:

  1. Enhanced support of new MySQL server versions.
  2. Partitioning support for MySQL 5.1.
  3. Support of Form View.
  4. Support of Code Completion in all SQL Editor.
  5. Support of ODBC Import.
  6. Support of exporting Excel file.
  7. Support of View, Store Procedure and Event in Structure Synchronization.
  8. Ability to send notification e-mail for schedule task, with an option to attach file output from Export Wizard or Data Transfer.
  9. Support of creating table, view, import/export profile shortcut on desktop.
  10. Support of SQL Preview for all object design forms.
  11. More table/column properties can be adjusted in Table design form.

Other enhancements:

User Interface

  1. Object information is now shown in pane inside Navicat main form rather than pop-up modal dialog.
  2. Support of drag and drop files (e.g. csv, excel....) to connection tree/table pane, Import Wizard will be launched.
  3. Support of drag and drop SQL files to connection tree - Excute SQL Batch Wizard will be launched.
  4. Tabs are scrollable, having a button on the right side to select the tab.
  5. "Comment" is now shown in a separated tab for all object design forms.
  6. Support of setting font styles for object lists and editors.
  7. More shortcut keys are supported.
Database Objects
  1. Added Data Time control in Table Viewer.
  2. Added "Definer" property in Event.
  3. Added control for setting Stored Procedure parameters and return types.
Connection
  1. Added Rename and Duplicate connection.
  2. Ability to copy Connection Information into Clipboard.
Import Wizard
  1. Line breaks support for CSV and Text Import.
  2. Improved recognition accuracy for XML file.
  3. Unlimited import record sizes supported.
Export Wizard
  1. A new interface supported.
  2. Support of multiple tables Export.
  3. Options to choose which fields to export.
  4. Additional options to set Date and Time format.
Data Synchronization
  1. Added option to disable Foreign Key checking.
Structure Synchronization
  1. Increased Speed.
  2. Options to choose which objects to compare.
  3. Options to choose execution methods.
Data Transfer
  1. Increased Speed.

Backup

  1. Support of saving profile, running schedule with specified backup options.

Navicat Release Notes.

Upgrade Procedure : click here to upgrade

Jan 6 2009
Navicat for MySQL (Mac OS X) version 7.1.7

Bug Fixes:

  1. Changed the default cipher specification in SSH Connection.
  2. Data Transfer failed to drop views which exist in the target server.
  3. Multi-lines parameter lists are not displayed properly.
  4. Non ascii password failed in Test Connection.
  5. Zero value is not updated for auto-increment columns in Table View.
  6. Wrong date imported for excel files using 1904 date system.
  7. Failed to import xml files with empty tag.

Upgrade Procedure : click here to upgrade

Oct 8 2008
Navicat for MySQL (Mac OS X) version 7.1.6

Bug Fixes:

  1. Crash when parameter query is executed for the second time.
  2. Stored Procedure - Text fields not properly aligned when resizing the windows.
  3. Data Transfer - transferring all procedures/functions may not work in some situations.
  4. Structure Sync - fields character sets are not compared.
  5. Backup - Crash when user does not have enough privileges on the Stored Procedure/Function.
  6. Bit type not displayed properly in Table View.
  7. Failed to create user in MySQL 4.x.
  8. A useless SQL executed during Data Transfer.
  9. Username with more than 16 characters are cut off.
  10. File menu is not properly displayed after a window is closed.

Upgrade Procedure : click here to upgrade

Aug 15 2008
Navicat for MySQL (Mac OS X) version 7.1.5

Bug Fixes:

  1. Crash when creating table for MySQL version 4 or below.
  2. foreign_key_check is not set in data transfer when using HTTP tunnel.

Upgrade Procedure : click here to upgrade


Jul 30 2008
Navicat for MySQL (Mac OS X) version 7.1.4

Minor Changes:

  1. New Query button now creates a new query based on the database you are working on as in Query View Window.
  2. The Cancel button in Backup Window has now been changed to Close.

Bug Fixes:

  1. Test Connection failed if socket file is set.
  2. Records with multi-lines cannot be copied in Table Designer (e.g. Trigger statements).
  3. Foreign Key Data Selection/Set selection panel sometimes disappear immediately after showing (bug in Mac OS X 10.5 only).
  4. Import Wizard crashs easily if the message log display many messages within a short period.
  5. Failed to create user in Manage User if no password is specified in a specifc mode of MySQL.
  6. Some privileges are not duplicated in Duplicate User in Manage User.

Upgrade Procedure : click here to upgrade

May 8 2008
Navicat for MySQL (Mac OS X) version 7.1.3

Improvements:

  1. Object list sorting now follows Finder's convention.
  2. Floating point values are now displayed in the same format as what MySQL returns.
  3. Disallow using socket file if SSH Tunnel or HTTP Tunnel is used.

Bug Fixes:

  1. Failed to backup functions in MySQL 5.1.
  2. Occasionally crash when using "Run Statements From Here" in Query.
  3. Data accuracy problem when importing data from formula in Excel file.
  4. Query View failed to display results when a SELECT query start with a blanket.
  5. Failed to create index if the relevant fields are composed of MySQL reserved words.

Upgrade Procedure : click here to upgrade

Mar 8 2008
Navicat for MySQL (Mac OS X) version 7.1.2

Improvements:

  1. Timeout reconnection - auto-reconnection will be made to the MySQL server.
  2. Ability to stop while establishing connection to MySQL server.

Bug Fixes:

  1. Better handling when SSH connection is lost.
  2. Deleting existing trigger while encountering error on modification.
  3. Ths tab note holds the previous query/procedure name during the Save As process.
  4. Indentation problem for stored procedures.
  5. Server password not being saved in the Connection Properties. (Lite version)
  6. The button to trigger the Field Selection panel in Table Design sometimes disappear when running in Leopard.

Upgrade Procedure : click here to upgrade

Jan 31 2008
Navicat for MySQL (Mac OS X) version 7.1.1

Improvements:

  1. Improve the memory management for drag and drop in Virtual Grouping.
  2. Re-order the SQL to be executed during Structure Synchronization.
  3. Improved the connection management. Freed up connections when they are not used.
  4. Export Wizard - remove the limitation on the size of each cell.
  5. Table View - allow skipping the auto-increment column when pasting data to Table View.
  6. Sort Connection list by name in Data Transfer.

Bug Fixes:

  1. Fixed problem on Batch Job (Schedule) while connecting via SSH connection.
  2. Fixed the improper behavior when SSH connection is lost.
  3. Execute Batch File not work in some special cases.

Upgrade Procedure : click here to upgrade

Jan 10 2008
Navicat for MySQL (Mac OS X) version 7.1.0

Enhancements:

  1. Tabbed Windows - support dragging tabs in and out of the tabbed windows.
  2. SSH Connection - support public key authentication.
  3. Structure Synchronization - support synchronizing foreign keys and triggers.

Upgrade Procedure : click here to upgrade

Nov 19 2007
Navicat for MySQL (Mac OS X) version 7.0.10

Major new features:

  1. New Import Wizard - support Excel file; Improves performance, usability, and much more.
  2. Tabbed Window - perform multiple operations in a single window.
  3. Virtual Grouping - provides better categorization for objects.
  4. Event Scheduler - new MySQL feature as of MySQL 5.1.

Other enhancements:

  1. Compatible with any MySQL server version up to 5.1.x.
  2. Improved memory managment in Import Wizard.
  3. Keyboard shortcut (Control-Tab) to switch between tabs.
  4. Incremental Search, Hex Editor and more supports in Table View.
  5. Usability enhancement in Table Design.
  6. Many other improvements on features and user-friendliness.

Navicat Release Notes.

Upgrade Procedure : click here to upgrade

Nov 1 2007
Navicat for MySQL (Mac OS X) version 7.0.9
* Compatible with Mac OS X Leopard . For the current 7.0.x users, please click for the free upgrade Now!

Enhancements:

  1. Import improved memory allocation in Import wizard.
  2. Adding shortcut keys for switching tabs.

Navicat Release Notes.

May 25 2006
Navicat for MySQL (Mac OS X) version 6.3.1

New features:

Lastest MySQL versions support:

  1. Compatible with any MySQL server version up to 5.1.x.
  2. Support of Triggers.
  3. BINARY, VARBINARY Data Type support.
  4. BIT Data Type support from MySQL 5.0.3.

Support of HTTP Tunnel:

  1. Enable [Use HTTP Tunnel] option to access MySQL Server through HTTP protocol. Upload the provided php file called [ntunnel_mysql.php] to the web server and enter the URL of the tunneling script.

    [ntunnel_mysql.php] is available in installation directory of the program.

Support of Foreign Key Data Selection:

  1. Table Viewer supports to get available value from Foreign Key Reference Table.

Upgrade Procedure : click here to upgrade

Apr 6 2006
Navicat for MySQL (Mac OS X) version 6.1.16

New features:

  1. Compatible with any MySQL server version up to 5.X.
  2. Support of Triggers.
  3. BINARY, VARBINARY Data Type support.
  4. BIT Data Type support from MySQL 5.0.3.

New powerful data management tools:

  1. Support of Views/Stored Procedures Backup and Restore.
  2. Support of Views/Stored Procedures Data Transfer.
  3. Support of Delimiter in Query.
  4. Support of Views in Query Builder.
  5. Support of Views/Stored Procedures in Manage Users.

Upgrade Procedure : click here to upgrade

Nov 9 2005
Navicat for MySQL (Mac OS X) version 6.0.10

New features:

  1. SSH Tunnel.
  2. Data Synchronization.
  3. Structure Synchronization.
  4. Build in SQL Console.
  5. View Builder.

Enhancements:

  1. Support latest version of MySQL server.
  2. Support of Query Parameter. For example: Select * from table_A where id = [$id].
  3. Support of Drag and Drop functionality. You can transfer table from one place to another by using mouse - drag and drop tables from a database into another database.

Bug Fixes

  1. Fixed Filter Wizard Loading Profile problem in Tiger.
Mar 9 2005
Navicat for MySQL (Mac OS X) version 5.3.2

New features:

  1. Supports Character Set.
  2. Filter Wizard.
  3. History Log of executed SQL statements

Bug fixes and enhancements:

  1. Support old MySQL version (version 3.22).
  2. Improved XML Import feature.
  3. Customizable History Log path.
  4. Resizable Manage User window.
  5. Bug fixed for default table type in TableDesign window.
  6. Bug fixed for loading Filter Wizard profile.
Oct 15 2004
Navicat for MySQL (Mac OS X) version 5.2.3

New features:

  1. Support MySQL version 4.1.6.
  2. Batch Job and Scheduling - support Backup/Restore database, Import/Export Wizard, Data Transfer.
  3. Support [Set Null] in table data grid.
May 14 2004
Navicat for MySQL (Mac OS X) version 5.1

New features:

  1. Support editing text in Blob field.
  2. Support MySQL 4.1.x and MySQL 5.0 Alpha (support stored procedure).
  3. Bug Fixes on decimal display.
  4. Combo box for enum values.
Jan 15 2004
Navicat for MySQL (Mac OS X) version 5.0

New features:

  1. Visual Query Builder.
  2. View table structure function.
  3. Bug Fixes on importing csv file and dbf file.
  4. User friendliness improvement.

Dec 1 2003
Navicat for MySQL (Mac OS X) version 4.4.2

Bugfix on Import Wizard (CSV file : fixed the import-only-one-row problem)

Nov 12 2003
PremiumSoft Navicat (Mac OS X) version 4.4

New features:

  1. You can convert your DBF, CSV, Text or XML files to MySQL databases, eliminating time-consuming data entry and the errors that accompany it. You can also use Export Wizard to export your data into DBF, CSV, Text or XML files.
  2. Duplicate Tables.
  3. Empty Tables.
  4. Export Wizard for Queries. You can export queries result into DBF, CSV, Text or XML files.
  5. Execute SQL Batch file.
  6. Support copying multiple rows from one table to another table.
  7. User friendliness improvement.

Oct 21 2003
PremiumSoft Navicat (Mac OS X) version 4.3.1

Import/Export wizard in Navicat 4.3.1 (Mac OS X).

Oct 1 2003
Survey for New Features: In order for us to further enhance our Navicat, please tell us your comments through [Navicat Survey]
Sep 11 2003
PremiumSoft Navicat (Mac OS X) ) (formerly PremiumSoft MySQL Studio) version 4.2.5

This release will support to configure Foreign Keys and contains many enhancements and refinements to other features.

Aug 5 2003
PremiumSoft Navicat (Mac OS X) version 4.2.4

This release contains several minor enhancements and bug fixes for PremiumSoft Navicat. We have fixed the bug of backup feature and trial period.

Jul 14 2003
PremiumSoft Navicat (Mac OS X) version 4.2.3
This release contains several minor enhancements and bug fixes for PremiumSoft Navicat. Among other things we have enhanced MySQL Connection settings and backup feature, improved support for MySQL 4.X and made some minor changes to the data transfer for MySQL.
Jun 6 2003
PremiumSoft Navicat (Mac OS X) version 4.2

It supports Mac OS X 10.1 or above and compatible with any MySQL server version up to 4.x.x.

New enhancements and improvements:

  1. Data Transfer.
  2. Server Monitor.
  3. User Management.
  4. Easy-to-use backup feature.

Mar 5 2024
Navicat for MySQL (Linux) version 16.3.4

Bug-fixes:

  1. Incorrect json array index syntax was generated when transferring MySQL tables.
  2. Some labels disappeared after adding the chart to the dashboard.
  3. Unable to display proportion percentages in the chart axis.
  4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Dec 27 2023
Navicat for MySQL (Linux) version 16.3.3

Bug-fixes:

  1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Nov 23 2023
Navicat for MySQL (Linux) version 16.3.2

Improvements:

  1. Support enabling or disabling "Detect Data Types" in Import Wizard.

Bug-fixes:

  1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Nov 2 2023
Navicat for MySQL (Linux) version 16.3.1

Bug-fixes:

  1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Oct 17 2023
Navicat for MySQL (Linux) version 16.3.0

Improvements:

  1. Support setting MySQL descending primary key.

Bug-fixes:

  1. Crashed when using Structure Synchronization.
  2. Crashed when changing data display in Charts.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Sep 13 2023
Navicat for MySQL (Linux) version 16.2.7

Bug-fixes:

  1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Sep 5 2023
Navicat for MySQL (Linux) version 16.2.6

Bug-fixes:

  1. Beautify SQL incorrectly added spaces between the function name and parentheses.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Aug 10 2023
Navicat for MySQL (Linux) version 16.2.5

Bug-fixes:

  1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jul 14 2023
Navicat for MySQL (Linux) version 16.2.4

Bug-fixes:

  1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jun 9 2023
Navicat for MySQL (Linux) version 16.2.2

Bug-fixes:

  1. "is in list" operator did not work in Table Filter.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

May 31 2023
Navicat for MySQL (Linux) version 16.2.1

Main New Features:

  1. Support sequence design for MariaDB.
  2. Show fields, indexes and more under tables in Navigation Pane.
  3. Minor bug fixes and improvements.
  4. Navicat for Redis is released.

To upgrade, please visit our Customer Center.

Apr 26 2023
Navicat for MySQL (Linux) version 16.1.8

Bug-fixes:

  1. High CPU usage when using SSH connection.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Mar 1 2023
Navicat for MySQL (Linux) version 16.1.7

Bug-fixes:

  1. Memory utilization issue.
  2. Table Viewer did not show the SQL if errors occurred.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Feb 8 2023
Navicat for MySQL (Linux) version 16.1.6

Bug-fixes:

  1. Filter value was not highlighted in the pop up window.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Dec 12 2022
Navicat for MySQL (Linux) version 16.1.5

Bug-fixes:

  1. Unable to copy field names in Table Designer.
  2. Unable to open Comment window in Table Designer.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Nov 21 2022
Navicat for MySQL (Linux) version 16.1.4

Bug-fixes:

  1. 1267 error occurred when clicking the "Users" button.
  2. Bar chart label display issue.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Sep 29 2022
Navicat for MySQL (Linux) version 16.1.3

Bug-fixes:

  1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Aug 31 2022
Navicat for MySQL (Linux) version 16.1.2

Bug-fixes:

  1. Crashed when changing the chart type in some cases.
  2. Text color issue in Dark Mode.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Aug 16 2022
Navicat for MySQL (Linux) version 16.1.1

Bug-fixes:

  1. Unable to open the objects in the "Find in Database" window.
  2. Crashed when updating query results in some cases.
  3. Crashed when foreign key selection window popped up.
  4. Crashed when clicking on the value box in table filter.
  5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jul 21 2022
Navicat for MySQL (Linux) version 16.1.0

Main New Features:

  1. Support OceanBase Community Edition.
  2. Support Trend Line for several chart types.
  3. Support adding On-Prem Server with URI.
  4. Allow skip preview of changes in data sync.
  5. Enhanced responsiveness and performance.
  6. Improved UI/UX.
  7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jun 9 2022
Navicat for MySQL (Linux) version 16.0.12

Bug-fixes:

  1. Slowdown when querying more than 150 columns.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

May 10 2022
Navicat for MySQL (Linux) version 16.0.11

Bug-fixes:

  1. Chart title display issue.
  2. Slowdown when querying more than 150 columns.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Mar 29 2022
Navicat for MySQL (Linux) version 16.0.10

Bug-fixes:

  1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Mar 9 2022
Navicat for MySQL (Linux) version 16.0.9

Bug-fixes:

  1. Unable to enter text in the filter criteria value box.
  2. Batch job stuck issue.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Feb 8 2022
Navicat for MySQL (Linux) version 16.0.8

Bug-fixes:

  1. Unable to open old version profiles.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jan 13 2022
Navicat for MySQL (Linux) version 16.0.7

Bug-fixes:

  1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jan 5 2022
Navicat for MySQL (Linux) version 16.0.6

Bug-fixes:

  1. Crashed when adding a new field to an existing table.
  2. Table was not removed from the object list after deletion.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Dec 15 2021
Navicat for MySQL (Linux) version 16.0.5

Bug-fixes:

  1. Connection encoding issue in Navicat Cloud.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Nov 23 2021
Navicat for MySQL (Linux) version 16.0.4

Main New Features:

  1. New Data Generation Tool
  2. Enhanced Charts Feature
  3. Support of Navicat On-Prem Server

Additional Features:

  1. Connection Profiles
  2. Field Information Pane
  3. Query Execution Summary
  4. Navicat On-Prem Server is released
  5. Many other new features and improvements

To upgrade, please visit our Customer Center.

Oct 20 2021
Navicat for MySQL (Linux) version 15.0.30

Bug-fixes:

  1. Unable to launch Navicat after upgrading the system to use GLib-2.70.0 .
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Sep 7 2021
Navicat for MySQL (Linux) version 15.0.29

Bug-fixes:

  1. Crashed when viewing or adding emoji data.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Aug 16 2021
Navicat for MySQL (Linux) version 15.0.28

Bug-fixes:

  1. The Stop button did not work when processing deletion in the table viewer.
  2. Error occurred when editing data in query results.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jun 16 2021
Navicat for MySQL (Linux) version 15.0.27

Bug-fixes:

  1. "2013 - Lost connection to MySQL" error often occurred when the "Keepalive interval" option was enabled.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

May 26 2021
Navicat for MySQL (Linux) version 15.0.26

Bug-fixes:

  1. Crashed when the query returned a large result set.
  2. Not all matching data was highlighted when searching the query results.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Apr 14 2021
Navicat for MySQL (Linux) version 15.0.25

Bug-fixes:

  1. Crashed after refreshing the table.
  2. Hanged when dragging a table from the main window to the model window.
  3. Incorrect default field size issue in Table Designer.
  4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Mar 10 2021
Navicat for MySQL (Linux) version 15.0.24

Bug-fixes:

  1. CTRL+R shortcut did not apply the filter.
  2. Unable to view TEXT data in Data Synchronization.
  3. Unable to show the input text in Table Viewer when using Dark Mode.
  4. Missing the primary key warning in Table Viewer.
  5. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jan 13 2021
Navicat for MySQL (Linux) version 15.0.23

Bug-fixes:

  1. Unable to export the fractional part when the decimal separator was comma.
  2. Unable to select privileges in the "Add Privilege" window by using the Space key.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Nov 25 2020
Navicat for MySQL (Linux) version 15.0.22

Bug-fixes:

  1. Crashed when restoring the backup file to another database.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Oct 27 2020
Navicat for MySQL (Linux) version 15.0.21

Bug-fixes:

  1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Sep 16 2020
Navicat for MySQL (Linux) version 15.0.20

Bug-fixes:

  1. Crashed when using Charts in some cases.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Aug 5 2020
Navicat for MySQL (Linux) version 15.0.19

Bug-fixes:

  1. The number of processes was missing in the Server Monitor window.
  2. Unable to delete multiple fields in Table Designer.
  3. The tab of Table Designer did not mark with * after deleting a field.
  4. Some buttons were disabled at all times in New Query.
  5. Unable to copy and paste multiple rows data to another table.
  6. Right-clicking a row header in data grid highlighted the corresponding column.
  7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jun 24 2020
Navicat for MySQL (Linux) version 15.0.18

Bug-fixes:

  1. Crashed when editing functions.
  2. No server, database and schema were selected when opening query.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jun 17 2020
Navicat for MySQL (Linux) version 15.0.17

Bug-fixes:

  1. Negative default value displayed as "-" in MariaDB.
  2. An empty diagram was created when reversing a database to a model.
  3. Unable to change font for Editor and Records.
  4. The selected privileges were inverted when adding database privileges.
  5. Error occurred when changing user password in MySQL 5.6.
  6. CREATE USER statement on the SQL Preview tab was wrong.
  7. Query returned different results for an empty row.
  8. Unable to copy the selected text with shortcut in Console.
  9. Crashed when importing tables to a model.
  10. Unable to add a table to the model using the mouse.
  11. Delay when pasting with CTRL+V.
  12. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

May 12 2020
Navicat for MySQL (Linux) version 15.0.16

Bug-fixes:

  1. Crashed when synchronizing Navicat Cloud on Ubuntu OS.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

May 6 2020
Navicat for MySQL (Linux) version 15.0.15

Bug-fixes:

  1. CTRL+Z, CTRL+Y, ESC shortcuts did no work when editing table columns.
  2. Unable to change MySQL/MariaDB user password.
  3. Unable to copy variables in Server Monitor.
  4. Virtual field expression was displayed as ******.
  5. Unable to copy and paste views to other databases.
  6. Unable to copy and paste indexes in Table Designer.
  7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Apr 15 2020
Navicat for MySQL (Linux) version 15.0.14

Bug-fixes:

  1. Crashed when creating new connection.
  2. Unable to open Console using F6 shortcut.
  3. Unable to set default value for fields in Table Designer.
  4. Unable to import XML file data into an existing table if source and target field names were different.
  5. Copy and paste issue in Table Designer.
  6. Sort issue in Data Viewer.
  7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Mar 23 2020
Navicat for MySQL (Linux) version 15.0.12

Bug-fixes:

  1. Query Empty error occurred when selecting a user in the user list.
  2. Crashed when clicking the Next button without choosing a target database in Data Transfer.
  3. Crashed when running scheduled tasks in some cases.
  4. F2 shortcut did not work for changing group names.
  5. Unable to refresh the database list by the context menu.
  6. CTRL+Q shortcut did not open a new query on the correct server.
  7. Unable to select or copy an index in Table Designer.
  8. Crashed when searching in Query Editor.
  9. "Do you want to save changes" dialog popped up even without making any changes in Table Designer
  10. The log messages were duplicated in Data Transfer.
  11. CTRL+Left Mouse Button did not copy the content of the columns in Table Viewer.
  12. Unable to create a new query by pressing CTRL+Q once in Query Editor.
  13. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Feb 28 2020
Navicat for MySQL (Linux) version 15.0.10

Bug-fixes:

  1. Crashed when adding an index to MySQL table.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Feb 24 2020
Navicat for MySQL (Linux) version 15.0.9

Improvements:

  1. Added "Table Relation" and "Field Relation" options to Query Builder.
  2. Added Connection Coloring to Query windows.

Bug-fixes:

  1. "Use custom database list" displayed double entries.
  2. "Show objects under schema in navigation pane" option did not work.
  3. Cursor was focus the bottom of the code when opening or saving functions / events.
  4. Unable to create new query by shortcut CTRL+Q in some cases.
  5. Crashed when accessing MariaDB users.
  6. Unable to save MariaDB users by clicking the Save button.
  7. CTRL+F did not open the search box in main window.
  8. F5 did not refresh the navigation pane.
  9. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jan 15 2020
Navicat for MySQL (Linux) version 15.0.7

Improvements:

  1. Added "Keep Orthogonal Layout" to Model.

Bug-fixes:

  1. The Code Snippet pane status was not retained when opening new window.
  2. "Stored Type" column was empty in Function object list.
  3. "Table Type" column was empty in Table object list.
  4. Opening query with External Editor did not use the selected editor.
  5. Customizing Date Delimiter did not work when exporting files.
  6. Unable to create new query by shortcut CTRL+Q in some cases.
  7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jan 6 2020
Navicat for MySQL (Linux) version 15.0.6

Improvements:

  1. Added shortcuts for "Run Current Statement" and "Select Current Statement" in Query Editor.

Bug-fixes:

  1. New Query shortcut (CTRL+Q) did not work in some cases.
  2. Unable to hide the Code Snippet pane.
  3. Wrong icon was shown in the Stored Procedure window frame.
  4. The default operator of string was not "contains" in Filter wizard.
  5. Crashed when using Datetime picker.
  6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Dec 19 2019
Navicat for MySQL (Linux) version 12.1.26

Bug-fixes:

  1. Unable to connect Azure Database for MariaDB.
  2. Wrong options were selected when loading another Data Transfer profile.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Dec 19 2019
Navicat for MySQL (Linux) version 15.0.5

Bug-fixes:

  1. "Open Containing Folder" option was disabled in some cases.
  2. "Open External Query", "Open External Model" and "Open External Workspace" options were missing in the context menu.
  3. Search box closed unexpectedly in main window.
  4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Dec 10 2019
Navicat for MySQL (Linux) version 15.0.4

Bug-fixes:

  1. Search box closed unexpectedly in main window.
  2. Unable to execute SQL files
  3. Wrong SQL was generated when creating MariaDB trigger.
  4. Unable to select object by typing in main window.
  5. Crashed when deleting column in Table Designer.

To upgrade, please visit our Customer Center.

Nov 25 2019
Navicat for MySQL (Linux) version 15.0.3

New Features:

  1. Native Linux Support
  2. New Charts
  3. Advanced Data Transfer
  4. Brand new Query Builder
  5. Enhanced Data Modeling Tool
  6. Dark theme UI and Diagram
  7. Many other new features and improvements

To upgrade, please visit our Customer Center.

Oct 31 2019
Navicat for MySQL (Linux) version 12.1.25

Bug-fixes:

  1. Unable to list tables when connecting to MyCat.
  2. Down arrow key did not highlight table grid cell in some cases.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Oct 2 2019
Navicat for MySQL (Linux) version 12.1.24

Bug-fixes:

  1. Failed to update records in table viewer.
  2. "Input profile is invalid" error occurred when opening export query profiles.
  3. Tab was exported instead of "," when scheduling to export CSV files.
  4. Automation was failed when scheduling export profile and import profile.
  5. Unable to copy and paste "," comma decimal separator.
  6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Sep 17 2019
Navicat for MySQL (Linux) version 12.1.23

Bug-fixes:

  1. Export process was slow.
  2. Unable to dump the default value of TIMESTAMP field.
  3. Synchronize to Database feature wrongly detected differences of unique constraints.
  4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Aug 1 2019
Navicat for MySQL (Linux) version 12.1.22

Bug-fixes:

  1. Copy and paste data issue in Table Viewer.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jul 30 2019
Navicat for MySQL (Linux) version 12.1.21

Bug-fixes:

  1. Unable to list users for MariaDB 10.4.
  2. Code Completion did not work in some cases.
  3. Unable to import signed numbers when there was spaces between the sign and the number.
  4. Unable to map a source field to multiple target fields in Import Wizard.
  5. "Cannot open file" error occurred when scheduling export profiles in some cases.
  6. Unable to show empty fields in query result sets.
  7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jun 10 2019
Navicat for MySQL (Linux) version 12.1.20

Bug-fixes:

  1. "Unknown Internal Error" occurred when opening Table Designer.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

May 23 2019
Navicat for MySQL (Linux) version 12.1.19

Bug-fixes:

  1. Text editor did not display the full text in some cases.
  2. Data Synchronization inserted values into Generated Columns.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Apr 17 2019
Navicat for MySQL (Linux) version 12.1.18

Bug-fixes:

  1. Error occurred when connecting to MySQL 4.0.
  2. Primary Key checkbox was deselected when tabbing to the next field in Table Designer.
  3. "Unknown Internal" error occurred when importing data.
  4. Table Designer cannot show the definition of MySQL 5.0 triggers.
  5. The deployment scripts generated incorrect default value in Structure Synchronization.
  6. "Access Violation" error occurred after editing the data pipeline in Report.
  7. "Unknown Internal" error occurred when using Automation.
  8. Unable to duplicate model files.
  9. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Mar 21 2019
Navicat for MySQL (Linux) version 12.1.17

Bug-fixes:

  1. Query result pane size did not retain after minimizing the window.
  2. Paradox tables cannot be imported.
  3. Unknown Internal error occurred when importing data.
  4. "On Update Current Timestamp" option did not reflect the settings when using ANSI_QUOTES SQL mode.
  5. Column order was incorrect when importing database to model.
  6. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Feb 26 2019
Navicat for MySQL (Linux) version 12.1.16

Bug-fixes:

  1. "Replace All" button was unable to replace the last occurrence in Query Editor.
  2. "Profile Location (MariaDB)" option was missing in Navicat for MySQL.
  3. Code completion suggestion list did not show on the same screen as the editor.
  4. A table was mistakenly transferred even it was not selected.
  5. Incorrect syntax highlighting issue in Query Editor.
  6. MySQL trigger definition displayed \\ as \ .
  7. Filter criteria input box was not retained when switching applications.
  8. Drag and drop selected text on Query Editor did not move the text.
  9. JSON expression did not display correctly in Table Designer.
  10. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Feb 13 2019
Navicat for MySQL (Linux) version 12.1.15

Bug-fixes:

  1. Code completion box displayed off the bottom of the screen and partially obscured.
  2. Unable to customize query result tab name by using /*NAME:XYZ*/ .
  3. Boolean or BIT(1) values importing, exporting and transferring issue.
  4. Copying table field names in Table Designer was slow.
  5. Table Form view was unable to show jpg images.
  6. Unable to import data when using Append/Update mode.
  7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jan 10 2019
Navicat for MySQL (Linux) version 12.1.12

Bug-fixes:

  1. SQL order issue in Structure Synchronization.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Nov 23 2018
Navicat for MySQL (Linux) version 12.1.10

Improvements:

  1. Added the "Include Owner" or "Include Definer" option in Data Transfer.

Bug-fixes:

  1. Geometry field precision was lost when transferring MySQL/MariaDB tables.
  2. List index out of bounds error occurred when inserting data in Table Viewer.
  3. Unable to shrink the last column on the Process List tab in Server Monitor.
  4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Nov 6 2018
Navicat for MySQL (Linux) version 12.1.9

Improvements:

  1. Added the "Compare owners" option in Structure Synchronization.

Bug-fixes:

  1. Slow performance when editing users or roles.
  2. Floating point numbers were rounded to decimals when import.
  3. <html> tag was repeated twice when exporting HTML files.
  4. "Add Database to List" button was enabled when the "Use custom database list" option was not checked.

To upgrade, please visit our Customer Center.

Oct 5 2018
Navicat for MySQL (Linux) version 12.1.8

Bug-fixes:

  1. Custom Filter was cleared when editing it.
  2. HTML export did not specify charset.
  3. "Show/Hide Columns" option was missing in Form View.
  4. The hidden Information pane was shown when switching from Form View to Grid View.
  5. Cursor focus issue in Form View.
  6. Code Completion did not work in some cases.
  7. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Sep 10 2018
Navicat for MySQL (Linux) version 12.1.7

Bug-fixes:

  1. Unable to scroll inside the text box in Form View.
  2. "is in list" operator in Filter Wizard did not working correctly.
  3. Structure Synchronization compared table options.
  4. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Aug 21 2018
Navicat for MySQL (Linux) version 12.1.6

Bug-fixes:

  1. Unknown Internal Error occurred when showing data "{}" in TEXT editor.
  2. Precision value in CURRENT_TIMESTAMP(6) was missing when synchronizing structure.
  3. Esc shortcut did not work when error occurred during deleting records.
  4. Error occurred when renaming an existing column and adding a new one.
  5. Filter value did not displayed when the string exceeded 5880 characters.
  6. Unable to display the columns list in Table Designer's Index tab when there was no index.
  7. Unable to apply Filter profile.
  8. Unable to scroll to right in Filter Wizard.
  9. Opening Design Table froze in large database.
  10. "Open Table" and "Design Table" were not properly synchronized.
  11. Import Target and Field Mapping changed after changing the source file in profile.
  12. "Date" and "Time" field data were shown as blank in Table Viewer.

To upgrade, please visit our Customer Center.

Jul 31 2018
Navicat for MySQL (Linux) version 12.1.5

Improvements:

  1. Improved Filter Wizard.
  2. Supported expression for default field value in Table Designer.

Bug-fixes:

  1. Crashed when applying filter in Foreign Key Selection window.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jul 26 2018
Navicat for MySQL (Linux) version 12.1.4

Main New Features:

  1. Support Roles for MySQL 8
  2. Support Roles for MariaDB 10
  3. Brand new Filter Wizard
  4. UI and UX Improvement
  5. MongoDB is added in Navicat Premium
  6. Navicat for MongoDB is released

To upgrade, please visit our Customer Center.

May 29 2018
Navicat for MySQL (Linux) version 12.0.29

Bug Fixes:

  1. File encoding was incorrect when transferring database to SQL file.
  2. The generated CREATE PROCEDURE statement was incorrect when dumping database to SQL file.
  3. Structure Synchronization detected differences after synchronizing.
  4. Incorrect unique values were imported from .dbf file.
  5. Crashed when saving the modified field names in some cases.
  6. Extra "(" was added to INSERT statements when deploying scripts in Data Synchronization.
  7. Unable to restore LONGTEXT data completely from .psc file.

To upgrade, please visit our Customer Center.

May 8 2018
Navicat for MySQL (Linux) version 12.0.28

Bug Fixes:

  1. 80041318 error occurred when saving a task schedule.
  2. The cursor position row moved to the bottom line after saved the procedure/function.
  3. Syntax error occurred when updating MySQL user password.
  4. Transaction did not end after closing the table in some cases.

To upgrade, please visit our Customer Center.

Apr 25 2018
Navicat for MySQL (Linux) version 12.0.27

Bug Fixes:

  1. Unable to transfer objects between different server types by drag-and-drop.
  2. Zero decimal place digits were not displayed in Table Viewer.
  3. Exported SQL file did not have table name when exporting an unsaved query.
  4. Incorrect SQL "ON UPDATE CURRENT_TIMESTAMP(0)" was dumped for MariaDB 5.5 tables.
  5. Syntax error occurred when importing CSV files in some cases.
  6. Database names were missing in the Drop SQL generated by Structure Synchronization.
  7. Unable to change the Tab Width in Query Editor.
  8. Unable to edit query results when tables had alias.
  9. Procedure parameters were missing in the scripts generated by Structure Synchronization.
  10. Unknown Internal Error occurred when Automation ran.
  11. Unable to transfer tables with HEX format.
  12. Encoding issue of the exported text file.

To upgrade, please visit our Customer Center.

Mar 28 2018
Navicat for MySQL (Linux) version 12.0.26

Bug Fixes:

  1. "Access Violation" error occurred when creating new connections in fresh installed Navicat.

To upgrade, please visit our Customer Center.

Mar 27 2018
Navicat for MySQL (Linux) version 12.0.25

Bug Fixes:

  1. Unable to create a query inside a group.
  2. The color of function keywords did not change according to the Font Color settings in Options.
  3. Column width did not retain after hide and show the column in Table Viewer.
  4. Unable to drag and drop a query into a group in some cases.
  5. Unable to edit query results in some cases.
  6. Unable to disable Foreign Key constraint in Data Synchronization.
  7. Crashed when dumping table to sql file in some cases.
  8. DROP PROCEDURE statements in Structure Synchronization did not include the schema name.
  9. Foreign Key constraint issue in Import Wizard.
  10. Code completion replaced the text after caret.
  11. Exported file was not attached to the notification email.
  12. Keepalive Interval setting attempted to connect continuously even the database was down.
  13. If a query was opened, abnormal behavior happened when closing Navicat.
  14. Automation did not start when the computer was logged out.
  15. Unable to create new table with primary key settings in Import Wizard.
  16. Navicat was not responded when performing Structure Synchronization.

To upgrade, please visit our Customer Center.

Feb 22 2018
Navicat for MySQL (Linux) version 12.0.24

Improvements:

  1. Supported Microsoft Azure Database for MySQL.

Bug Fixes:

  1. Spaces were missing in the SQL exported from Model.
  2. Extra newlines were added to the SQL exported from Model.
  3. "Hourly" option was missing on Task Schedule's Trigger tab.
  4. Wrong datestamp was appended to the exported files.
  5. Slow issue when searching in Table Viewer.
  6. Unable to move functions into a group.
  7. Syntax error occurred when running query in some cases.
  8. Unable to select Enum data in query results.
  9. Target functions/procedures were not dropped before create when synchronizing structure.
  10. Unable to synchronize models/queries in Navicat Cloud.
  11. Exported Excel files were corrupted in some cases.

To upgrade, please visit our Customer Center.

Jan 22 2018
Navicat for MySQL (Linux) version 12.0.23

Bug Fixes:

  1. Error occurred when synchronizing structure in some cases.
  2. Replace All did not work in Table Viewer.
  3. Cell selection disappeared after pressing CTRL+C in Table Viewer.
  4. Error occurred when running query in some cases.
  5. "Unknown Internal Error" occurred when exporting query results.

To upgrade, please visit our Customer Center.

Jan 15 2018
Navicat for MySQL (Linux) version 12.0.22

Bug Fixes:

  1. Unknown Internal error occurred when editing/adding connections.
  2. Adding self-referencing table issue in Query Builder.
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Jan 11 2018
Navicat for MySQL (Linux) version 12.0.21

Bug Fixes:

  1. Out of memory issue when running Data Transfer.
  2. "Unknown Internal Error" occurred when loading profiles in Structure Synchronization.
  3. Export Float data to csv files issue.
  4. Syntax error occurred when synchronizing MySQL functions.
  5. Crashed when importing Excel or Text files in some cases.
  6. Opening large databases in List View took long time.
  7. Unable to show query files with ".SQL" extension in Objects tab.
  8. Errors occurred when executing MySQL Dump files.
  9. CTRL+SPACE shortcut were missing in Query Editor.
  10. Null date values were exported wrongly as "1900-01-00" in Excel files.
  11. Tables Viewer displayed wrong number of digits.
  12. Input parameter window did not pop up when exporting query.
  13. High CPU usage issue.

To upgrade, please visit our Customer Center.

Dec 5 2017
Navicat for MySQL (Linux) version 12.0.20

Bug Fixes:

  1. Unable to transfer POINT data type from MySQL to MariaDB.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Dec 1 2017
Navicat for MySQL (Linux) version 12.0.19

Bug Fixes:

  1. Unable to zoom in/out Query Editor using mouse wheel.
  2. Unable to connect Sphinx servers.
  3. Swapping connections did not work when re-comparing in Data Synchronization.
  4. Syntax errors occurred when running query in some cases.
  5. Unknown Internal error occurred when performing Structure Synchronization.
  6. No records was transferred when the target connection was using HTTP Tunnel.
  7. Query syntax highlight was wrong after switching tabs.
  8. DateTime field Not Null checkbox unchecked wrongly in Table Designer.
  9. Unable to export table to xlsx with name longer than 31 characters.
  10. Hanged when searching in Table Viewer in some cases.
  11. Unable to change editor color in Linux version.

To upgrade, please visit our Customer Center.

Nov 13 2017
Navicat for MySQL (Linux) version 12.0.18

Bug Fixes:

  1. The database/schema combo-box did not work in Query.
  2. Manual refresh did not work in Server Monitor when auto-refresh was enabled.
  3. Unknown Internal Error occurred when performing Structure Synchronization.

To upgrade, please visit our Customer Center.

Nov 7 2017
Navicat for MySQL (Linux) version 12.0.17

Bug Fixes:

  1. Fixed importing connections with Settings Location issue.
  2. Fixed ER diagram layout issue.
  3. Table groups were not synchronized to other members in Navicat Cloud.
  4. Add Index statements were generated wrongly when opening Table Designer.
  5. Wrong SQLs were generated when inserting fields in Table Designer.
  6. Unable to run CREATE PROCEDURE statements in Query Editor.
  7. Unable to save function after changing parameter names.
  8. Unable to import DBF files.
  9. Identifiers panel retained when opening new query window.
  10. Access denied error occurred when transferring tables with triggers in some cases.
  11. The Stop button in Export Wizard did not work properly.
  12. Unknown Internal Error occurred when typing in Query Editor.

To upgrade, please visit our Customer Center.

Oct 10 2017
Navicat for MySQL (Linux) version 12.0.16

Bug Fixes:

  1. Structure Synchronization detected differences wrongly in some cases.
  2. Record delimiter was wrong when exporting to text file using Automation.
  3. Table Viewer moved back to the first page when refreshing a table.
  4. Characters displayed wrongly in Table Viewer.
  5. Unable to select fields when exporting to Excel file.

To upgrade, please visit our Customer Center.

Sep 27 2017
Navicat for MySQL (Linux) version 12.0.15

Bug Fixes:

  1. Error occurred when deleting INT field value in Table Viewer.

To upgrade, please visit our Customer Center.

Sep 26 2017
Navicat for MySQL (Linux) version 12.0.14

Bug Fixes:

  1. Wrongly shown differences when synchronizing structure.
  2. The DDL tab in Information pane did not updated after saving changes in sub forms.
  3. Unknown Internal Error occurred when synchronizing structure/data in some cases.
  4. Unable to schedule Data Synchronization profiles.
  5. Syntax error occurred when filtering with ' character in Table Viewer.
  6. Compared table comments in Structure Synchronization.
  7. Input decimal separator issue in Table Viewer.
  8. Unable to import date from Excel to VARCHAR field.
  9. Query Builder loading was slow.
  10. Custom backup file name was ignored when scheduling in Automation.
  11. Re-registration issue.
  12. Unable to create new table in Import Wizard in some cases.

To upgrade, please visit our Customer Center.

Sep 5 2017
Navicat for MySQL (Linux) version 12.0.13

Bug Fixes:

  1. Table triggers was not included when backing up tables.
  2. Auto increment field was ignored when importing
  3. Unable to set the default value of TEXT/BLOB field for MariaDB 10.2.1 or above.
  4. Navicat hanged when running a query export profile in some cases.
  5. Error occurred when running LOAD DATA LOCAL queries.
  6. Unknown Internal error occurred when saving changes in Table Designer.
  7. Double-quote encased text fields were split into new records when importing a record which multiple lines.
  8. Syntax error occurred when performing data transfer in some cases.
  9. Unknown Internal error occurred when adding multiple records in Table Viewer.
  10. Two identical functions declared as different in Structure Synchronization.

To upgrade, please visit our Customer Center.

Aug 8 2017
Navicat for MySQL (Linux) version 12.0.11

Bug Fixes:

  1. Unable to open Information pane by context menu.
  2. Unable to import fixed width text file in some cases.
  3. Access Violation error occurred when creating models / tables in some cases.
  4. Access Violation error occurred after Navicat was idle.
  5. Unable to import the CDATA data in XML files.
  6. Number values were exported as text in Excel files.
  7. Code completion did not work for alias in SQL Editor.
  8. Beautify SQL did not format multiple statements properly in SQL Editor.
  9. Unknown Internal error occurred when running query with parameters.
  10. Table menu displayed wrong item in some cases.
  11. Unknown Internal error occurred when running old version export profiles in Automation.
  12. Unknown Internal error occurred when opening tables in some cases.
  13. "_Navicat_Temp_Stored_Proc() does not exist" error occurred when saving functions.
  14. High memory usage issue in Data Synchronization.
  15. "Use empty string as NULL" option did not work in Import Wizard.
  16. Unknown Internal error occurred when writing query in some cases.
  17. Unknown Internal error occurred when backup in Automation in some cases.
  18. Hang issue occurred when launching Import Wizard.
  19. Unable to connect with SSL in some cases.

To upgrade, please visit our Customer Center.

Jul 14 2017
Navicat for MySQL (Linux) version 12.0.10

New Features:

  1. New UI/UX.
  2. On Startup: open favorite tabs automatically when Navicat launches.
  3. Code Snippet.
  4. Advanced Code Completion with better suggestions.
  5. Brand new Structure Synchronization: visually show side-by-side DDL comparison between two databases.
  6. Brand new Data Synchronization: show particular status to distinguish the differences between records easily.
  7. New Automation: easy to find desired profiles and create automated batch jobs.
  8. Responsiveness and performance improved.
  9. Many other new features and improvements.

To upgrade, please visit our Customer Center.

Mar 16 2017
Navicat for MySQL (Linux) version 11.2.16

Bug Fixes:

  1. Error occurred when exporting with Time field type.
  2. "Argument out of range" occurred when running "Reverse Database to Model".
  3. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Dec 22 2016
Navicat for MySQL (Linux) version 11.2.15

Bug Fixes:

  1. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Dec 7 2016
Navicat for MySQL (Linux) version 11.2.14

Bug Fixes:

  1. Crashed when using Query in some cases.
  2. Query auto-save feature did not work in some cases.
  3. Set task schedule in Batch Job did not work.
  4. Fixed UI font issue in Ubuntu 16.10.

To upgrade, please visit our Customer Center.

Oct 31 2016
Navicat for MySQL (Linux) version 11.2.13

Bug Fixes:

  1. Error occurred when getting MySQL query status.
  2. Minor bug fixes and improvements.

To upgrade, please visit our Customer Center.

Oct 24 2016
Navicat for MySQL (Linux) version 11.2.12

Bug Fixes:

  1. MySQL floating point fields were exported to decimal values.
  2. Error occurred when profiling query with sql_mode "ONLY_FULL_ GROUP_BY" for MySQL 5.7.5 or above.
  3. Fixed the sorting issue in Table Viewer.

To upgrade, please visit our Customer Center.

Aug 3 2016
Navicat for MySQL (Linux) version 11.2.11

Bug Fixes:

  1. Copy and paste issue in Table Viewer's Memo Editor.

To upgrade, please visit our Customer Center.

Jun 15 2016
Navicat for MySQL (Linux) version 11.2.10

Improvements:

  1. Support inputting tabs in the editor of Table Designer.
  2. Support UTF16 formatted files in Execute SQL File and Query's Import SQL functions.

Bug Fixes:

  1. The media keys (play, pause, next etc) did not work.
  2. Unable to connect MariaDB 5.5 with SSL.
  3. Failed to transfer data in Chinese locale OS.
  4. Foreign keys check SQL was missing at the end of the dumped SQL file.
  5. Crashed when synchronizing model to database in some cases.
  6. Unable to show the light coloring when the tab is non-active.

To upgrade, please visit our Customer Center.

May 10 2016
Navicat for MySQL (Linux) version 11.2.9

Bug Fixes:

  1. The datetime field values were inconsistent in exported file.

To upgrade, please visit our Customer Center.

Apr 29 2016
Navicat for MySQL (Linux) version 11.2.8

Bug Fixes:

  1. Unable to set "On Update Current_Timestamp" setting in some cases for MySQL version 5.6.5 or above.
  2. Error occurred when logging in Navicat Cloud if profile path contained Unicode.

To upgrade, please visit our Customer Center.

Mar 30 2016
Navicat for MySQL (Linux) version 11.2.7

Bug Fixes:

  1. Fixed multi-monitor with different dpi issue.
  2. Column import definition broken when importing.
  3. Saved Import profile mapped columns wrongly.
  4. "invalid varient operation" error occurred when import from ODBC.
  5. "Argument out of range" error occurred when importing CSV file.
  6. Primary Key settings were deleted when modifying import profile.
  7. Error occurred when exporting connections.
  8. Error occurred when saving profiles.

To upgrade, please visit our Customer Center.

Mar 1 2016
Navicat for MySQL (Linux) version 11.2.6

Improvements:

  1. Support field type JSON in MySQL 5.7.8 or above.

Bug Fixes:

  1. Errors occurred when running LOAD DATA LOCAL queries in 64-bit version.
  2. Error "Diagram table already exists" occurred when opening some model files.
  3. Crashed when exporting connections.
  4. "Access violation" error occurred when importing CSV file.

To upgrade, please visit our Customer Center.

Jan 15 2016
Navicat for MySQL (Linux) version 11.2.5

Major New Features:

Navicat Cloud Collaboration

  1. Create/Modify/Delete projects.
  2. Add members to project for sharing connection settings, queries and models.
  3. View Project Activity Log.

Data Modeling Tool

  1. Support Model Conversion.
  2. Support Views.
  3. Enhanced Table Designer.

Others

  1. Enhanced Connection Coloring.
  2. Search database object structure.

To upgrade, please visit our Customer Center.

Aug 3 2015
Navicat for MySQL (Linux) version 11.1.13

Bug Fixes:

  1. Exported result incorrect for TIME field type in Export Wizard.
  2. File name with appended timestamp issue in Export Wizard.
  3. Slow performance when showing/hiding column with Memo editor opened.
  4. SSH protocol error issue.

To upgrade, please visit our Customer Center.

May 20 2015
Navicat for MySQL (Linux) version 11.1.12

Bug Fixes:

  1. Generated object SQL identifier without escaping quote characters in Model.
  2. Unable to load the virtual group settings file created by old versions of Navicat.
  3. After sorted a selected column in Table Viewer, access violation occurred when resizing column width.

To upgrade, please visit our Customer Center.

Apr 20 2015
Navicat for MySQL (Linux) version 11.1.11

Improvements:

  1. Reset the field length to default value after changing the auto guessed field type in Table Designer.

Bug Fixes:

  1. Access violation error occurred when entering SQL in Query.
  2. Cannot access field 'Super_priv' as type Boolean error occurred when managing Users.
  3. Unable to download source files with HTTPS connection in Import Wizard.
  4. Failed to create/edit users for MySQL 5.7.6.

To upgrade, please visit our Customer Center.

Mar 12 2015
Navicat for MySQL (Linux) version 11.1.10

Improvements:

  1. Improved the Message Log information.

Bug Fixes:

  1. Table Designer did not allow to edit MySQL table partition’s Values setting.
  2. Unable to identify equality of trigger definitions with different system line breaks in Structure Synchronization.
  3. Unable to generate MySQL table SQL with charset binary properly in Structure Synchronization.
  4. Code Completion added smart quote wrongly for utc_date() in Query Editor.
  5. Unable to convert object names in Data Transfer when using Schedule.
  6. Unable to transfer MariaDB triggers in Data Transfer.

To upgrade, please visit our Customer Center.

Jan 20 2015
Navicat for MySQL (Linux) version 11.1.9

Bug Fixes:

  1. Unable to run in Windows Server 2003.
  2. Fixed the color issue in the connection tree.
  3. Wrong handling for field type BIT.

To upgrade, please visit our Customer Center.

Dec 9 2014
Navicat for MySQL (Linux) version 11.1.8

Improvements:

  1. Allow copying field names in Table Viewer and Query's Result.

Bug Fixes:

  1. "Argument out of range" error occurred after running MySQL/MariaDB queries in Query.
  2. Crashed after multiple drag & drop tables in Model Designer.

To upgrade, please visit our Customer Center.

Dec 2 2014
Navicat for MySQL (Linux) version 11.1.7

Improvements:

  1. Error counting in Data Transfer's Message Log changed from records to records and objects.

Bug Fixes:

  1. Structure Synchronization was unable to compare the difference between Null and empty default value for MySQL/MariaDB fields.
  2. Unable to select new mode in connection tree using Alt+MouseDown.
  3. Duplicated foreign key names issue in Model.
  4. Unable to recognize the Row Delimiter when importing from CSV files.
  5. Import Wizard was unable to import currency data from DBF files.
  6. Advanced settings were saved incorrectly in Data Transfer profiles.

To upgrade, please visit our Customer Center.

Sep 18 2014
Navicat for MySQL (Linux) version 11.1.6

Bug Fixes:

  1. Synchronized Navicat Cloud model files even they did not have any changes.

To upgrade, please visit our Customer Center.

Sep 15 2014
Navicat for MySQL (Linux) version 11.1.5

Improvements:

  1. Added press and hold Alt key and double-click table to open Table Design.

Bug Fixes:

  1. Failed to dump SQL file from Navicat Cloud connection.
  2. Unable to select foreign key for new table in Table Design.

To upgrade, please visit our Customer Center.

Sep 1 2014
Navicat for MySQL (Linux) version 11.0.19

Bug Fixes:

  1. Unable to set default value to empty string for columns with SET data type in Table Design.

To upgrade, please visit our Customer Center.

Aug 25 2014
Navicat for MySQL (Linux) version 11.1.3

New Features:

  1. Support to sync selected connection settings, queries, model files and virtual group information to Navicat Cloud. For more information, please visit here.

Improvements:

  1. Support adding shapes in Model.

To upgrade, please visit our Customer Center.

May 21 2014
Navicat for MySQL (Linux) version 11.0.18

Improvement:

  1. Query profile now support to show in server level.

Bug Fixes:

  1. Date time picker was not shown fully in some Linux environments.
  2. Unable to save local file if database name contained heading/tailing space.
  3. Crashed when loading and parsing a long incorrect syntax SQL in Query.
  4. After adding a new row, pressing next/last button would freeze the Form View in Table Viewer.
  5. Number of rows selected incorrectly when using shift+up/down keys in Table Viewer.
  6. Multiple selection not working properly with shift+keys in Table Viewer.
  7. When using CTRL+A to select text inside a data cell, all cells were incorrectly selected in Table Viewer.
  8. Import Paradox not able to import data properly in Navicat 64bits.
  9. Backup not able to backup table with foreign key.
  10. Wrong NullsOrder setting was shown for foreign key fields under Table Designer in Data Modeling Tool.
  11. Wrong CREATE TABLE SQL with character set and comment exported under Export SQL in Data Modeling Tool.

To upgrade, please visit our Customer Center.

Feb 25 2014
Navicat for MySQL (Linux) version 11.0.17

Improvement:

  1. Table Viewer is now able to update a row even not all the keys are input for numeric columns.
  2. Always import as NULL value if "Use empty string as NULL" option is checked in Import Wizard.
  3. All records are now able to show under the Fixed Width window in step 3 of Import Wizard.

Bug Fixes:

  1. 'Control 'Dock2Form_1' has no parent window' error occured while docking in and out of windows.
  2. Connection was deleted after renamed to capitalized name.
  3. Foreign key information with two words identifier not able to get correct correctly in Table Designer.
  4. Foreign key information with NDB cluster storage engine not able to get correctly in Table Designer.
  5. Parameter list not able to show in Function Designer when there was CHARACTER type in function parameters.
  6. 'Table does not exist' error occured while opening an export profile.
  7. Server with unsaved password not able to connect under 'Import from Database' in Data Modeling Tool.

To upgrade, please visit our Customer Center.

Jan 9 2014
Navicat for MySQL (Linux) version 11.0.16

Improvements:

  1. Added Dynamic Column Editor for MariaDB in Table Viewer.

Bug Fixes:

  1. Lose focus in Table Viewer.
  2. Function parser error.
  3. Access Violation error occurred when designing MariaDB tables with foreign keys.
  4. Access Violation error occurred when importing invalid connections.
  5. ERegistry Exception error occurred when starting Navicat.
  6. Wrong Date Editor frame size in Table Viewer.
  7. Stack Overflow error when running Query.
  8. Data Synchronization failed when MySQL or MariaDB table has multi-fields Primary Key.
  9. Permissions issue of the Updater.
  10. Cursor was missing in Stored Procedure.
  11. Failed to create MySQL user with special characters password.

To upgrade, please visit our Customer Center.

Nov 13 2013
Navicat for MySQL (Linux) version 11.0.12

Bug Fixes:

  1. Wrong handling on Integer type.
  2. Changed properties not check properly in Table Designer.

To upgrade, please visit our Customer Center.

Nov 8 2013
Navicat for MySQL (Linux) version 11.0.11

Bug Fixes:

  1. Missed to mark quotation on keywords in Query Builder.
  2. Process was unable to stop while running query in Essentials version.
  3. Failed to include auto increment column setting for floating point data types.
  4. Access Violation occured when executing query clause with 'GROUP BY _xxx, _yyy'.

To upgrade, please visit our Customer Center.

Sep 10 2013
Navicat for MySQL (Linux) version 11.0.10

Bug Fixes:

  1. Failed to show definition/DDL for View.
  2. Failed to check/uncheck column fields in Show/Hide Columns using space key in Tabler Viewer.
  3. Failed to scroll horizontally for wide content after applying Filter Wizard in Table Viewer.

To upgrade, please visit our Customer Center.

Aug 7 2013
Navicat for MySQL (Linux) version 11.0.9

Bug Fixes:

  1. Access violation occured in 64-bit scintilla (Text Editor) after Navicat used huge memory (>4G).
  2. Access violation occured while copying and pasting field in Table Designer.
  3. No respond from Filter Wizard in Table Viewer after execution error of filter query.
  4. Failed to replace text with an empty string using the Find and Replace feature.
  5. Fixed the scrolling issue in docking window on secondary display.
  6. Failed to display unicode user name and organization in Navicat About box.

To upgrade, please visit our Customer Center.

Jul 3 2013
Navicat for MySQL (Linux) version 11.0.8

Bug Fixes:

  1. Default value could not be kept longer than 255 characters in Table Designer.
  2. Column width not able to be reset after showing the hidden column in Table Viewer.
  3. Access violation occured in Table Viewer while reconnecting SSH connection with another port.
  4. Query message in status bar not updated if no result return after Run.
  5. Fixed concat string (with date) in Query.
  6. Access violation occured when entering query clause with 'GROUP BY _xxx, _yyy'.

To upgrade, please visit our Customer Center.

May 27 2013
Navicat for MySQL (Linux) version 11.0.7

Bug Fixes:

  1. Key was rejected for SSH connection.
  2. Access violation occured while running report in command line.
  3. Losing searched position in Memo editor after first searching or clicked into the Memo editor.
  4. Fixed query parser error.
  5. Invalid relation cardinality not showed in red color in Data Modeling Tool.

To upgrade, please visit our Customer Center.

May 9 2013
Navicat for MySQL (Linux) version 11.0.6

Bug Fixes:

  1. Fixed "Keyboard Interactive Failed" error for SSH tunnel connection.
  2. Crashed while using SSH tunnel connection for both source and target servers in Data Transfer.
  3. "Access violation" error occurred while entering query clause with 'ORDER BY _xxx ASC/DESC' in Query.
  4. Notification email not sent with an unsaved batch job.

To upgrade, please visit our Customer Center.

Apr 30 2013
Navicat for MyQL (Linux) version 11.0.5

Major New Features:

Interface

  1. New User Interface
  2. New docking system

Connection

  1. New SSH Manager
  2. Connection Tree Filter

Table Viewer

  1. Find and Replace data
  2. Box Selection
  3. Multi-Cell Editing
  4. Search Columns
  5. Web Viewer
  6. Memo Editor with syntax highlight
  7. Support Transaction
  8. Support animated gif in Image viewer
  9. Copy data as INSERT/UPDATE statement

Table Designer

  1. Search Columns
  2. Field Type Prediction

Query

  1. Enhanced Query Builder

Import Wizard/Export Wizard

  1. JSON file
  2. CSV file
  3. Improved binary data handling

Others

  1. New Registration and Activation System
  2. New Updater

To upgrade, please visit our Customer Center.

Feb 4 2013
Navicat for MySQL (Linux) version 10.1.8

Bug Fixes:

  1. "Access violation" error occurred while applying an existing table name on a new table in Data Modeling Tool.

To upgrade, please visit our Customer Center.

Dec 11 2012
Navicat for MySQL (Linux) version 10.1.7

Improvement:

  1. Support fractional seconds precision of time, datetime, timestamp data types for MySQL 5.6.4/MySQL MariaDB 5.3 or above.
  2. The Profile tab under Query is now displayed without sorting.
  3. Support date time format 2012-12-31T01:02:03.456 in Import Wizard.
  4. Support fractional seconds precision of time, datetime, timestamp data types for MySQL 5.6.4 or above under Synchronize to Database function in Data Modeling Tool.
  5. Support to ignore comparing DEFINER clause of view, event, trigger, procedure and function in Structure Synchronization.

Bug Fixes:

  1. Create function statement which was after DELIMITER change statement was unable to be executed in Query.
  2. "List index out of bounds" error occurred when some source fields were removed after import profile were created during Import Wizard.
  3. Binary data from Access/ODBC was imported incorrectly during Import Wizard.
  4. Synchronize to Database function in Data Modeling Tool genarated incorrect comparison result for equivalent source and target foreign keys.
  5. Records were unable to generate for Federated table in Dump SQL File and Data Transfer.

To upgrade, please visit our Customer Center.

Sep 19 2012
Navicat for MySQL (Linux) version 10.1.6

Improvement:

  1. Added data format options for XML file in Export Wizard.

Bug Fixes:

  1. Wrong time unit (ms) was shown under Messages tab in Query function.
  2. Table Designer in Data Modeling Tool was unable to save newly added index and foreign key.
  3. Synchronize to Database function in Data Modeling Tool was unable to generate the referencing table schema name in the SQL scripts.

To upgrade, please visit our Customer Center.

Aug 23 2012
Navicat for MySQL (Linux) version 10.1.5

Bug Fixes:

  1. Empty named relation was unable to load back in Data Modeling Tool.
  2. Unable to generate sync queries for fields with auto increment and primary key in Data Modeling Tool.
  3. "Access violation" error occurred while opening "Import from Database" form in Data Modeling Tool.

To upgrade, please visit our Customer Center.

Jul 27 2012
Navicat for MySQL (Linux) version 10.1.3

Bug Fixes:

  1. Minimized docked window could not restore normally.

To upgrade, please visit our Customer Center.

Jul 19 2012
Navicat for MySQL (Linux) version 10.1.2

Improvement:

  1. Added font selection in Option for ER Diagram.

Bug Fixes:

  1. 1064 error occured when running Store Procedure.

To upgrade, please visit our Customer Center.

Jul 6 2012
Navicat for MySQL (Linux) version 10.1.1

Bug Fixes:

  1. If the table contained many columns, new column would be inserted to wrong position in Table Designer (Data Modeling Tool).

To upgrade, please visit our Customer Center.

Jun 15 2012
Navicat for MySQL (Linux) version 10.1.0

Improvements on Data Modeling Tool:

  1. Support Unsigned for Numeric Type.
  2. Support Auto Increment for Integer Type.
  3. Build model with multiple schemas.
  4. New wizard "Import from Database".
  5. New wizard "Synchronize to Database".
  6. Search filter.
  7. Align/Distribute diagram objects.

To upgrade, please visit our Customer Center.

Mar 28 2012
Navicat for MySQL (Linux) version 10.0.11

Bug Fixes:

  1. Navicat got hanged while performing a search in Table Viewer.
  2. Incorrect excel file format was exported while having data started with 0 in Export Wizard.
  3. Copy and paste was not working on index in Table Designer.

To upgrade, please visit our Customer Center.

Jan 31 2012
Navicat for MySQL (Linux) version 10.0.10

Improvement:

  1. Import speed has been improved in Import Wizard.
  2. Export speed has been improved in Export Wizard.

Bug Fixes:

  1. Navicat generated 'Not Implemented' error when running under replacement shell UI.

To upgrade, please visit our Customer Center.

Jan 4 2012
Navicat for MySQL (Linux) version 10.0.9

Bug Fixes:

  1. While scrolling index fields, the scrolled position could not be reflected in Table Designer.
  2. Table Designer generated incorrect SQL statement in field ordering.
  3. The comparison in columns ordering were generated incorrectly in Structure Synchronization, and Synchronize to Database in Modeler.
  4. Extra SET FOREIGN_KEY_CHECKS queries were generated even if the comparison results were identical in Structure Synchronization.
  5. Crash occurred when closing Synchronize to Database in Modeler during the comparison in progress.
  6. Crash occurred while renaming table failed with server error in ER-diagram view.
  7. Data Transfer would hang in Navicat Scheduler.

To upgrade, please visit our Customer Center.

Nov 24 2011
Navicat for MySQL (Linux) version 10.0.8

Improvement:

  1. Enhanced Model transformation.

Bug Fixes:

  1. "Access violation" error occurred when dragging n dropping a server node in connection tree together with the Model/Schedule object pane were opened.
  2. When created a virtual group in the connection tree, it would be added under Model/Schedule object pane while they were opened.

To upgrade, please visit our Customer Center.

Nov 14 2011
Navicat for MySQL (Linux) version 10.0.7

Improvement:

  1. Source field order is now kept in target table after running "Synchronize to Database".

Bug Fixes:

  1. Incorrect field type showed in ER Diagram.
  2. Fixed-width and row delimiter were unable to retrieve from a profile in Import Wizard.
  3. Print report to PDF file would generate a blank file.
  4. Non-latin characters with different collation columns were unable to search in "Find in Database" feature.

To upgrade, please visit our Customer Center.

Oct 17 2011
Navicat for MySQL (Linux) version 10.0.6

Improvement:

  1. Support column comment up to 1024 characters for MySQL 5.5.3.
  2. Support table comment up to 2048 characters for MySQL 5.5.3.

Bug Fixes:

  1. Data Modeling Tool was unable to set the reference field of foreign key.
  2. Data Modeling Tool was unable to print with landscape page setting.
  3. When importing data from an URL, it failed to create a temporary file if the same temporary file was being accessed.
  4. Tables contained geometric point data was failed in Data Transfer and Data Synchronization.
  5. Restore didn't work with the .pmb file created from Navicat version 5.
  6. Connection Information could not display properly in large font size.
  7. Default value of bit field was shown incorrectly in Table Viewer.

To upgrade, please visit our Customer Center.

Sep 19 2011
Navicat for MySQL (Linux) version 10.0.5

Improvements:

  1. Improved performance of "Reverse Database to Model" and "Reverse Tables to Model.
  2. Foreign Keys is now able to be imported into Model.
  3. Spacing issue has been improved in Beautify SQL.

Bug Fixes:

  1. Import from paradox file was unable to get signed short integer values.
  2. User Privileges typo was fixed.

To upgrade, please visit our Customer Center.

Sep 12 2011
Navicat for MySQL (Linux) version 9.1.12

Improvements:

  1. Indexes is now included in Create Table during Data Transfer.

Bug Fixes:

  1. The highlighted items from the previous searching results in Table Designer was failed to clear for the next searching.
  2. Foreign key was unable to be created in Table Designer when referencing a destination field requiring index.
  3. Default scale of 4 was applied when encountering currency data during the Import of Access file.
  4. "SET FOREIGN_KEY_CHECKS=1" did not generate while running Structure Synchronization.

To upgrade, please visit our Customer Center.

Sep 6 2011
Navicat for MySQL (Linux) version 10.0.3

Major New Features:

  1. Data Modeling Tools.
  2. ER Diagram view.
  3. SQL Minifier.
  4. Database Wide Search.

Improvements:

  1. Ability to run transaction backup for MySQL database (InnoDB only).
  2. Added object list in Query Editor.
  3. Added DDL tab in Object Information.

To upgrade, please visit our Customer Center.

Jun 1 2011
Navicat for MySQL (Linux) version 9.1.11

Improvements:

  1. Added Ctrl+a as shortcut key for "select all" in Form View.

Bug Fixes:

  1. './start_navicat: 10: arithmetic expression: expecting EOF: "2*100+13 2"' error would occur when starting up Navicat.
  2. Wrong table would be copied while running "Duplicate Table" function.
  3. Object Information was unable to be refreshed when under "List" view mode.
  4. Foreign Key Check box under Table Designer was unable to be toggled using space bar.
  5. Searching in Table Viewer would freeze when no record showed on the existing view.

To upgrade, please visit our Customer Center.

Apr 11 2011
Navicat for MySQL (Linux) version 9.1.10

Bug Fixes:

  1. Scroll bar in Trigger Definition editor was missing.
  2. Object List frozen.
  3. The size of the width in Run Result columns were too large in Stored Procedure form.
  4. "Grid index out of range" error occured while refreshing in Table Viewer.
  5. Connection combo box showed wrongly in Data Synchronization.
  6. Query was unable to execute a SQL containing DROP statement inside Create Statement.

To upgrade, please visit our Customer Center.

Feb 21 2011
Navicat for MySQL (Linux) version 9.1.9

Improvements:

  1. Added "Grant All", "Revoke All" etc in Server Privileges tab of User Designer.

Bug Fixes:

  1. Imported text-based file with UTF-8 encoded data to blob field incorrectly.
  2. "Use empty string as NULL" option while importing from XLS/XLSX formats is now working correctly.
  3. Procedure/Function Designer was unable to get the body part correctly.
  4. Failed to run multiple Data Synchronization at the same time.
  5. Table with identity fields was not working correctly in Data Synchronization.
  6. Invalid pointer error would occur after editing procedure/function during Structure Synchronization.

To upgrade, please visit our Customer Center.

Jan 17 2011
Navicat for MySQL (Linux) version 9.1.8

Improvements:

  1. Improved sorting order in Connection Tree and Object list.

Bug Fixes:

  1. Table Designer was unable to handle field insertion.
  2. Table Designer was unable to insert a field as first since Navicat modifies the second field to reference the not yet inserted field.
  3. Table Designer now supports primary key fields ordering.
  4. Table Designer was unable to show/edit trigger definition.

To upgrade, please visit our Customer Center.

Jan 12 2011
Navicat for MySQL (Linux) version 9.1.7

Major New Features:

  1. Support of MySQL Server 5.5.
  2. Support of geometry data type.
  3. Support BTREE and HASH index methods.
  4. New Privilege Manager.
  5. Enhanced User/Role Management.
  6. Data Synchronization performance improved with new engine.
  7. Connection Coloring.

To upgrade, please visit our Customer Center.

Oct 4 2010
Navicat for MySQL (Linux) version 9.0.15

Bug Fixes:

  1. "700 - Invalid response: 403" error occured when using HTTP tunnel connection.
  2. "Out of memory" error occured when running a long SQL in Query function.
  3. "Access violation" error occurred when running an invalid SQL syntax in Query function e.g. SELECT DBMS_OBFUSCATION_TOOLKIT.MD5 (input_string=>'1') FROM DUAL.
  4. Result form showed in Query Editor would be closed after a new query was run.
  5. Beautify SQL returned an invalid SQL syntax, e.g. formatted xxx@yyy into xxx @ yyy.
  6. "Cannot call Start on a running or suspended thread" error occured when exporting tables with mutli resultsets.

Upgrade Procedure : click here to upgrade

Sep 15 2010
Navicat for MySQL (Linux) version 9.0.14

Bug Fixes:

  1. When pasting an enum type value using CTRL+V in Tabler Viewer, the drop down list box would be shown in wrong position.
  2. "Access violation" error occurred when running an invalid SQL syntax in Query Builder, e.g. select ... from ,table01.
  3. Imported string data as blob data incorrectly to database using Import Wizard.
  4. In Structure Synchronization, when the queries generated in the "Queries for Modification" list were too long (e.g. 8000 characters), the whole line would become blank.

Upgrade Procedure : click here to upgrade

Aug 30 2010
Navicat for MySQL (Linux) version 9.0.13

Improvements:

  1. Horizontal scrollbar is now reset to the left position after applying Beautify SQL feature.

Bug Fixes:

  1. "Access violation" error sometimes occurred when running an invalid SQL syntax in Query Editor.
  2. "Access violation" error occurred when running union/join/inner query in Query Editor.
  3. "Error in updating task" error occurred when saving a scheduled task.
  4. Error occurred when schedule name and path contained unicode string.

Upgrade Procedure : click here to upgrade

Aug 2 2010
Navicat for MySQL (Linux) version 9.0.12

Bug Fixes:

  1. Brackets in FROM clause could not be parsed between Query Editor and Query Builder.
  2. When exporting numeric data with comma as decimal seperator to access file, the numbers were displayed without the comma.
  3. When exporting numeric data to excel file, it would be exported as string type.
  4. Sort by time could not work properly in Server Monitor.
  5. Process ID became negative value in Server Monitor.

Upgrade Procedure : click here to upgrade

Jul 15 2010
Navicat for MySQL (Linux) version 9.0.11

Bug Fixes:

  1. "Access Violation" error occured when printing database/table structure to PDF, HTML etc.
  2. "Open Table (Quick)" could not work properly in some machines issues.
  3. "List Index our of bounds (58)" error occured when trying to enter/edit SQL in query Definition tab.
  4. Foreign Key link position in Visual Builder were not accurate enough.
  5. Fixed "mysql.proc" error occured in Table Designer.
  6. Fixed bug when parsing FROM clause with brackets in Visual Builder, e.g. select ... from ((...)).
  7. Codepage problem in Data Transfer feature.
  8. Server Monitor would crash if being opened for a while.
  9. The info column in Server Monitor only showed (WIDEMEMO).
  10. Database/table Privileges were unable to show with uppercase names.

Upgrade Procedure : click here to upgrade

Jun 23 2010
Navicat for MySQL (Linux) version 9.0.10

Improvements:

  1. libcurl.dll library updated.
  2. Structure Synchronization will now not compare MySQL table comment.

Bug Fixes:

  1. Auto-reconnection did not work on SSH tunnel connection to MySQL server.
  2. Fixed the unicode display problem on Text field with MySQL 4.0 or below.
  3. Beautify SQL would cause error if extra spaces existed in aggregate function.
  4. Fixed error when importig XML files from the Interent.
  5. When exported data to Excel spreadsheet, string start with zero (e.g. 009123) would be changed to integer (9123).
  6. "Access Violation" error occured in Manage User when MySQL user did not have enough privilege.
  7. "Ask to save new queries" in Options would be reset to unchecked after Navicat restarted.

Upgrade Procedure : click here to upgrade

Jun 8 2010
Navicat for MySQL (Linux) version 9.0.9

Main New Features:

  1. Import/Export connection.
  2. Significant Improvements made in code/word completion.
  3. Code Folding.
  4. Matched Brace/Bracket Highlighting.
  5. Parameter Tips.
  6. Zoom In/Out for SQL editors.
  7. SQL Beautifier.
  8. Favorites.
  9. Object Filter.
  10. Individual database objects backup.
  11. Auto save in Query, Function etc.
  12. Custom sort in Tabler Viewer.
  13. Significant Improvements made in editor and data grid searching.
  14. Notification email supports SSL/TLS in Schedule.
  15. History Log Viewer.

Upgrade Procedure : click here to upgrade

Feb 24 2010
Navicat for MySQL (Linux) version 8.2.20

Improvements:

    In Table Viewer, MySQL Limit clause will now exclude from the Update/Delete statement if primary key does not exist.

Bug Fixes:

  1. Collations could not be changed for MySQL 4.1.
  2. When altered MySQL View definer, wrong quoting applied.
  3. Word Wrap status did not save in the Query Editor.
  4. "Access violation" error occured when adding "Order By" or selecting any fields after "Select * from table" being run several times in Query Builder.
  5. When import from ODBC with empty tables, "BOF/EOF access" error would occur.
  6. Error dialog occured when selecting target connection in Data Transfer.

Upgrade Procedure : click here to upgrade

Jan 19 2010
Navicat for MySQL (Linux) version 8.2.19

Bug Fixes:

  1. Restore function could not work properly.
  2. Insert Field did not work in Table Designer.

Upgrade Procedure : click here to upgrade

Jan 12 2010
Navicat for MySQL (Linux) version 8.2.18

Improvements:

  1. If length does not specify for MySQL char/varchar, 255 value will now be assigned when saving a table.

Bug Fixes:

  1. Connection Name in Connection Properties sometime would show empty value.
  2. When using MySQL HTTP Tunnel connection and user tried to add/duplicate an user. After pressing OK to close the user form, Navicat would sometimes causes "Access Violation" error.
  3. When altered a MySQL data type that contains unsigned/zerofill properties into BIT type, table could not be saved in Table Designer.
  4. BIT type default value could not be handled properly in some MySQL server.
  5. "1055" errod occured when running MySQL queries after the SQL mode was set into 'TRADITIONAL, ONLY_FULL_GROUP_BY NO_AUTO_VALUE _ON_ZERO'.
  6. "1045 - Access denied" error occured when a target server was not selected during MySQL Data Transfer.
  7. Events and Sequences could not shown under Object Selection tab in Restore form.

Upgrade Procedure : click here to upgrade

Nov 18 2009
Navicat for MySQL (Linux) version 8.2.17

Improvements:

  1. In step 6 of Import Wizard, Source field name would be truncated if longer than 255 characters. Now, Navicat supports up to 5000 field name characters.

Bug Fixes:

  1. When a schedule is set by a root user, other user which did not contain privileges enough would be unable to modified that schedule profile.
  2. MySQL Auto increment value could not be altered if "Use DDL from SHOW CREATE TABLE" option was disabled with "Include Auto Increment" option being checked in Data Transfer.
  3. Refresh did not work for getting update data.
  4. When import text-based file using Import Wizard, Navicat was unable to get the number of columns correctly if the file did not contain field name row or there were empty lines existed before first data row.

Upgrade Procedure : click here to upgrade

Oct 28 2009
Navicat for MySQL (Linux) version 8.2.16

Bug Fixes:

  1. The cursor position moved to end-of-line after saved the Stored Procesure/Function.
  2. "Access Violation" error occured when getting the Event information from Linux server.
  3. Failed to establish SSH connection when the private key path contained unicode.
  4. when the server name contain unicode characters, this server name was unreadable in SQL file which created using Data Transfer feature.
  5. "Control 'ppParameterEditor' has no parent window" error occured when clicked on the ParametersEditor button which under Generation topic in Report Builder.
  6. When a table contained some long field names, those field names were only partialy visible or even invisible in Form View.
  7. When resizing the Data Transfer/Data Synchronization/Structure Synchronization window, all data fields expanded to display longer content except the "profile" drop down list.

Upgrade Procedure : click here to upgrade

Oct 5 2009
Navicat for MySQL (Linux) version 8.2.15

Bug Fixes:

  1. "Truncate Table" function did not work with multiple tables if using HTTP Tunnel connection.

Upgrade Procedure : click here to upgrade

Sep 25 2009
Navicat for MySQL (Linux) version 8.2.14

Improvements:

  1. "Exceed package size..." error will now occur to remind you to enlarge the max_allowed_packet variable if the records larger than the maximum packet size setting when running Data Synchronisation for MySQl server.

Bug Fixes:

  1. "Property cannot be found" error occured when importing Access file with datatype that may involve decimal places info, e.g.currecy, number, floating point value.
  2. BLOB data in text file was unable to import successfully.
  3. When added a new field (without labelling its name) in MySQL server usng Table Designer, then click the Move Up button. The last field in the table would be disappeared.
  4. "List index out of bound" error occured when using an account, which did not have enough privileges, to open MySQL Stored Procedure/Function.
  5. "Access Violation" error occured when exporting data to Access file if using HTTP Tunnel connection.

Upgrade Procedure : click here to upgrade

Sep 3 2009
Navicat for MySQL (Linux) version 8.2.13

Improvements:

  1. The Data Synchronization message log will not show server name rather than Host/IP.

Bug Fixes:

  1. When applied comma as decimal seperator, Data Synchronization would cause problem.
  2. Date field was not converted correctly when exported to DBF file.
  3. Undo (Ctrl + z) function did not work properly on memo editor in Table Viewer.
  4. Email attachment in Schedule could not be sent if "Add timestamp" option was enabled in Export Wizard.

Upgrade Procedure : click here to upgrade

Aug 11 2009
Navicat for MySQL (Linux) version 8.2.12

Latest MySQL versions support

  1. Compatible with any MySQL server version.
  2. Support all MySQL objects: tables, views, stored procedures/functions and events.
  3. Support all subobjects: fields, indices, foreign keys and triggers.
  4. Support of partitioning.
  5. Support of Unicode / Character Set.

Connection options:

  1. Support of password and public/private key for SSH Tunnel.
  2. Support of HTTP Tunnel for MySQL and PostgreSQL Servers.

Well-designed user interface:

  1. Grid View and Form View support.
  2. Virtual Grouping for connections and objects.

Powerful Data Manipulation Tools:

  1. Import and Export tool.
  2. Data Transfer tool.
  3. Data and Structure synchronization.
  4. Backup and Restore.
  5. Ability to set schedule on backup, query execution, import/export, data transfer and data synchronization.
  6. Ability to attach Export Wizard/Report result files in Batch Job notification email.

SQL Processing:

  1. Visual query/view builder to facilitate the process of building complicated queries.
  2. Ability to create parameter queries.
  3. Multiple SQL editors with syntax highlighted feature.
  4. Code completion for SQL editors.
  5. Ability to preview SQL before execution.
  6. Support to return multi-resultsets.

Upgrade Procedure : click here to upgrade

Jan 6 2009
Navicat for MySQL (Linux) version 8.0.29

Bug Fixes:

  1. Fixed timeout problem during the Backup run in Command Line.
  2. Fixed Data Transfer (without target database name) access violation in Command Line.
  3. Fixed system color shows in grid.

Upgrade Procedure : click here to upgrade

Sep 18 2008
Navicat for MySQL (Linux) version 8.0.28

Bug Fixes:

  1. Fixed e-mail sending with authentication setting in Schedule.
  2. Fixed Print Database/Table issue, while printing non-english field name, table name etc.
  3. Fixed dbf import,while importing Float type with NULL value.
  4. Fixed Open Table shortcut issue.
  5. Fixed Command Line crash.

Upgrade Procedure : click here to upgrade

Apr 30 2008
Navicat for MySQL (Linux) version 8.0.27

Improvements:

  1. Provide better error log system for Data Synchronization.
Bug Fixes:
  1. Fixed "Invalid class typecast" error in Server Monitor.
  2. Closed the docking windows using Alt+F4 would give Access Violation error.
  3. Structure Synchronization will not synchronize field comments.

Navicat Release Notes.

Upgrade Procedure : click here to upgrade

Apr 7 2008
Navicat for MySQL (Linux) version 8.0.25

Improvements:

  1. The outcome from Navicat "Dump SQL File" feature (both database and table) includes "drop table if exists" statement.
  2. Ability to remember size and position for "New Query" window.
  3. Set focus on Query Editor when opening a new query.
Bug Fixes:
  1. Fixed the backup problem which would generate error if object name contains apostrophe(').
  2. No need to save the query before export to excel file.
  3. Scheduled Job does not populate "from" field in email.
  4. Restore window position problem.
  5. Export dbf with or without memo issue.
  6. Fixed uppercase StoredProc in Manage users.
  7. Overflow in Server Monitor.
  8. Unicode problem in StoredProc designer.
  9. Comment are not shown in StoredProc designer after save.
  10. Fixed import dbf float/double issue.
  11. Fixed Import xml issue - while xml file contains ampersands(&).
  12. Fixed popup position with dual monitor.
  13. Fixed number of crashes from query.

Navicat Release Notes.

Upgrade Procedure : click here to upgrade

Jan 28 2008
Navicat for MySQL (Linux) version 8.0.23

Major new features:

  1. Support of connection to MySQL Server through SSH.
  2. Support of character set and unicode.
  3. Support all MySQL objects: tables, views, stored procedures/functions and events.
  4. Support data and structure synchronization.
  5. Virtual Grouping - provides better categorization for objects.
  6. Form View - enjoy a clear display of field name and its value with focus on current record.
  7. Code Completion - speedup your sql writing.
  8. E-mail Notification - send notification e-mail for schedule task.

Other enhancements:

  1. Compatible with any MySQL server version up to 5.1.x.
  2. Enhanced Import and Export Wizard.
  3. Incremental Search, Hex Editor and more supports in Table View.
  4. Usability enhancement in Table Design.
  5. Further data are shown in the tree view.
  6. Support of raw mode edit: apply MySQL built-in function.
  7. Timeout reconnection - auto-reconnection will be made to the SQL server.

Navicat Release Notes.

Upgrade Procedure : click here to upgrade

Oct 3 2005
Navicat for MySQL (Linux) version 6.0.2

Navicat 2005 for Linux combines the following new features and enhancements:

New features:

  1. SSL Connection.
  2. Filter Wizard.
  3. Import Wizard.
  4. Export Wizard.
  5. Visual Query Builder.

Enhancements

  1. Supports MySQL server 4.1.14

Upgrade Procedure : click here to upgrade

Sep 13 2004
Navicat for MySQL (Linux) version 5.0.2

New features:

  1. Support MySQL server version up to 4.1.
  2. Support of Foreign Key.
  3. Support of Stored Procedure.
  4. Batch Job and Scheduling - You can create a schedule for Backup, Data Transfer or saved queries execution.
  5. Execute SQL Batch file.
Oct 1 2003
Survey for New Features: In order for us to further enhance our Navicat, please tell us your comment through [Navicat Survey]