Navicat for MySQL (64-bit)

What's new in this version:

Navicat for MySQL 16.2.10 (64-bit)
Fixed:
- Crashed when importing Access file
- Minor bug fixes and improvement


Navicat for MySQL 16.2.8 (64-bit)
Improvements:
- Auto guess field types when importing xlsx files

Fixed:
- Beautify SQL incorrectly added spaces between the function name and parentheses
- Unable connect to MySQL via SSH tunnel in some cases
- Minor bug fixes and improvements


Navicat for MySQL 16.2.7 (64-bit)
Fixed:
- Incorrectly triggering code completion when pressing ENTER in Query Editor
- Minor bug fixes and improvements


Navicat for MySQL 16.2.6 (64-bit)
Fixed:
- Unable to close tabs in some cases
- Slashes () were removed from triggers when synchronizing MariaDB structures
- Minor bug fixes and improvements


Navicat for MySQL 16.2.5 (64-bit)
Fixed:
- Cannot type a new name for the table in Import Wizard.
- Minor bug fixes and improvements.


Navicat for MySQL 16.2.3 (64-bit)
Fixed:
- Expressions for virtual columns were truncated
- Minor bug fixes and improvements


Navicat for MySQL 16.2.2 (64-bit)
Improved:
- Support unix socket forwarding in SSH

Fixed:
- Minor bug fixes and improvements


Navicat for MySQL 16.2.1 (64-bit)
- Support sequence design for MariaDB
- Show fields, indexes and more under tables in Navigation Pane
- Minor bug fixes and improvements
- Navicat for Redis is released


Navicat for MySQL 16.1.15 (64-bit)
Fixed:
- High CPU usage when using SSH connection
- Minor bug fixes and improvements


Navicat for MySQL 16.1.12 (64-bit)
Fixed:
- Query Builder window was larger than the screen in some cases
- Unable to display the data differences of TEXT fields in Data Synchronization
- The second field was selected when adding a sort condition in Table Viewer
- Crashed when stopping Data Transfer process
- Minor bug fixes and improvements


Navicat for MySQL 16.1.11 (64-bit)
- Minor bug fixes and improvements


Navicat for MySQL 16.1.9 (64-bit)
Fixed:
- Memory utilization issue
- Table Viewer did not show the SQL if errors occurred
- Minor bug fixes and improvements


Navicat for MySQL 16.1.8 (64-bit)
- Unable to save changes after deleting a cell value in Table Viewer
- Access violation error occurred when opening a model
- Minor bug fixes and improvements


Navicat for MySQL 16.1.7 (64-bit)
Improved:
- Support MariaDB UUID type

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


Navicat for MySQL 16.1.6 (64-bit)
Fixed:
- "Cannot open source table" error occurred when using Condition Query in Import Wizard
- Exporting to Excel file was slow
- Minor bug fixes and improvements


Navicat for MySQL 16.1.4 (64-bit)
Fixed:
- 1267 error occurred when clicking the "Users" button
- Bar chart label display issue
- Unable to export Excel file in some cases
- Hanged when transferring tables
- Minor bug fixes and improvements


Navicat for MySQL 16.1.3 (64-bit)
Fixed:
- Unable to connect server using HTTP tunnel in some cases
- Font size issue in Form View
- Buttons in the lower right corner of the main window were missing in some cases
- Minor bug fixes and improvements


Navicat for MySQL 16.1.2 (64-bit)
Fixed:
- Crashed when changing the chart type in some cases
- Hanged when deleting a table in Query Builder
- Text color issue in Dark Mode
- Unable to connect AWS RDS database via SSH
- Backup and Dump SQL File was slow in some cases
- Minor bug fixes and improvements


Navicat for MySQL 16.1.1 (64-bit)
Fixed:
- Unable to open the objects in the "Find in Database" window
- The first number of every value in the list was removed in the table filter
- Unknown Internal Error occurred when updating query results in some cases
- Unable to use "Copy As" in View results
- Crashed when opening functions in some cases
- Unknown Internal Error occurred when foreign key selection window popped up
- Crashed when clicking on the value box in table filter
- Cannot retain the window size and position for existing objects
- Minor bug fixes and improvements


Navicat for MySQL 16.1.0 (64-bit)
Main New Features:
- Support OceanBase Community Edition
- Support Trend Line for several chart types
- Support adding On-Prem Server with URI
- Allow skip preview of changes in data sync
- Enhanced responsiveness and performance
- Improved UI/UX
- Minor bug fixes and improvements


Navicat for MySQL 16.0.14 (64-bit)
Fixed:
- Query parameters did not work in some cases
- Decimal precision issue when importing from Excel files
- Minor bug fixes and improvements


Navicat for MySQL 16.0.12 (64-bit)
Fixed:
- Extra commas were added to the script in Structure Synchronization
- Unknown Internal Error occurred when exporting large amount of data
- Unable to sign in Subscription plan
- Minor bug fixes and improvements


Navicat for MySQL 16.0.11 (64-bit)
Fixed:
- Crashed when running Automation in some cases
- Missing the first record when import
- Unable to locate project when running batch job
- Unable to get table information when scheduling data synchronization
- Refresh button ran all SQLs in Query Editor
- .0000 data export issue
- Function execution message log issue
- Access Violation error occurred when removing default value
- Navicat exited when clicking the Type column in Table Designer
- Crashed when batch querying tables with FK dependency
- Minor bug fixes and improvements


Navicat for MySQL 16.0.10 (64-bit)
- Change log not available for this version


Navicat for MySQL 16.0.9 (64-bit)
Fixed:
- The "Compare" button did not work in Data Synchronization in some cases
- "Couldn't open known_hosts file" error occurred when the SSH path contained Chinese characters
- Minor bug fixes and improvements


Navicat for MySQL 16.0.7 (64-bit)
Fixed:
- Unable to show utf8mb4 data
- Minor bug fixes and improvements


Navicat for MySQL 16.0.5 (64-bit)
Fixed:
- Connection encoding issue in Navicat Cloud
- Connection password issue when updating connection in Navicat Cloud
- Error occurred when synchronizing to Navicat Cloud
- Minor bug fixes and improvements


Navicat for MySQL 16.0.4 (64-bit)
Fixed:
- Syntax error occurred when importing data to MySQL table
- Notification Email authentication failed in some cases
- Minor bug fixes and improvements


Navicat for MySQL 16.0.3 (64-bit)
New Features:
- New Data Generation Tool
- Enhanced Charts Feature
- Support of Navicat On-Prem Server

Additional Features:
- Connection Profiles
- Field Information Pane
- Query Execution Summary
- Navicat On-Prem Server is released
- Many other new features and improvements


Navicat for MySQL 15.0.27 (64-bit)
Fixed
- Double foreign key lines were printed when exporting a model to a PDF file
- Access violation error occurred when searching in the Backup's Object Selection tab
- No data value on the label when exporting a chart to a PDF file
- Unable to rename a view inside a group in Navicat Cloud
- Minor bug fixes and improvements


Navicat for MySQL 15.0.26 (64-bit)
Improvements:
- Support tunneling on PHP 8

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


Navicat for MySQL 15.0.25 (64-bit)
Bug fixes:
- Empty rows were added when exporting more than 1.05 M records to Excel file
- Error occurred when using Recordset Generator to generate a record set for the Date field
- Hanged when designing a table with many fields
- Relation lines were disappeared after saving and reopening Logical Model
- Minor bug fixes and improvements


Navicat for MySQL 15.0.23 (64-bit)
Fixed:
- Functions were not properly saved as the default value in MariaDB
- ER diagram was reloaded when clicking the Design Table button
- Unable to toggle "Virtual Type" in an existing table
- Error 1227 occurred when creating or designing a table
- Minor bug fixes and improvements


Navicat for MySQL 15.0.22 (64-bit)
- Change log not available for this version


Navicat for MySQL 15.0.21 (64-bit)
- Change log not available for this version


Navicat for MySQL 15.0.20 (64-bit)
Fixed:
- Flashed in dark mode
- "Unallowed argument in list..." error when running export / import schedule
- Unable to load version 10 data synchronization profiles
- Differences were incorrectly detected in Synchronize to Database
- Minor bug fixes and improvements


Navicat for MySQL 15.0.19 (64-bit)
- Change log not available for this version


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


Navicat for MySQL 15.0.17 (64-bit)
- Change log not available for this version


Navicat for MySQL 15.0.16 (64-bit)
Improvements:
- Integer column exported in Number format when exporting Excel file
- Display export profiles in the same group of queries

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


Navicat for MySQL 15.0.14 (64-bit)
Bug fixes:
- Unable to synchronize data to MySQL 8.0.19
- Unable to connect AnalyticDB
- Unable to export data to .mdb files
- Minor bug fixes and improvements


Navicat for MySQL 15.0.13 (64-bit)
Bug fixes:
- MySQL table row format reverted to Compact after editing
- Syntax error occurred when creating events
- Unable to set default value for fields in Table Designer
- Unable to show SUPER privilege for MariaDB 10.4 in the user object list
- Foreign key was dropped and added when re-comparing the model
- Minor bug fixes and improvements


Navicat for MySQL 15.0.12 (64-bit)
Bug fixes:
- Invalid XML error occurred when importing connections
- Differences was detected in re-comparison in Structure Synchronization and Synchronize to Database
- Incorrect data was updated when saving ; in a non-text field
- Incorrect SQL generated for altering fields in Structure Synchronization
- Incorrect items were displayed in suggestion list when using code completion with alias
- Incorrect SQL generated when enabling "On Update Current_timestamp" in Table Designer
- Minor bug fixes and improvements


Navicat for MySQL 15.0.11 (64-bit)
Bug fixes:
- Query wrongly returned null results in some cases
- "," was replaced by "." when using Custom Filter in Table Viewer
- Minor bug fixes and improvements


Navicat for MySQL 15.0.9 (64-bit)
Bug fixes:
- Only the first batch was transferred when "Number of row per batch" was enabled
- Minor bug fixes and improvements


Navicat for MySQL 15.0.8 (64-bit)
Improvements:
- Added "Keep Orthogonal Layout" to Model

Bug fixes:
- Unable to update bit type data
- Minor bug fixes and improvements


Navicat for MySQL 15.0.6 (64-bit)
Improvements:
- Added shortcuts for "Run Current Statement" and "Select Current Statement" in Query Editor

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


Navicat for MySQL 15.0.5 (64-bit)
Bug fixes:
- "Invalid floating point operation" error occurred when resizing tables in View Builder
- Multiple primary key names were generated when exporting model to SQL files
- Syntax error occurred when connecting to MySQL 4
- Minor bug fixes and improvements


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


Navicat for MySQL 15.0.3 (64-bit)
- New Charts
- Advanced Data Transfer
- Brand new Query Builder
- Enhanced Data Modeling Tool
- Dark theme UI and Diagram
- Many other new features and improvements