Navicat (MySQL GUI) version 8.1.x is a MySQL database management tool, which can convert XML, CSV, MS Excel, MS Access, and popular data formats to MySQL databases, eliminating time-consuming data entry and the errors that accompany it. Other useful major features include Import and Export wizard, Unicode support, HTTP/SSH Tunnel, Batch Job Scheduling, Data Synchronization, Data Transfer, Visual Query Builder, and Visual Report Builder. Navicat features importing data from ODBC and batch job scheduling.
Version 8.1.20 includes: Enhanced support of new MySQL server versions; Support of Table Partitioning; Support of Show Profile and Status in Query; Support of multi-result set in Query and Stored Procedure; Ability to attach Export Wizard/Report result files in a Batch Job notification e-mail; Support of SQL Preview for all object design forms; More table properties can be adjusted in Table design form; Support of Preview and Explain in View Design Form.
What's new in this version:
Version 8.1.20 includes: Enhanced support of new MySQL server versions; Support of Table Partitioning; Support of Show Profile and Status in Query; Support of multi-result set in Query and Stored Procedure; Ability to attach Export Wizard/Report result files in a Batch Job notification e-mail; Support of SQL Preview for all object design forms; More table properties can be adjusted in Table design form; Support of Preview and Explain in View Design Form.
Pros: Connect to localhost or to remote server (you'll need to set your server to accept remote connection). Edit individual records just by entering data. Change table structure. Great program.
Cons: It might take some knowledge to get connected to a remote server. You will need the url of your computer. You will need to tell your server to accept a remote connection (Remote MySql in CPanel). But once you have taken these steps all is easy.
Summary: This puts complete control of your database at your fingertips. Great program. Free!