Navicat - The World Best MySQL Client - Navicat (phpMyAdmin replacement) 8.1.18

Navicat - The World Best MySQL Client - Navicat (phpMyAdmin replacement) 8.1.18 is a program compatible with all MySQL Database Server version 3.21 or higher, which can support most of the latest MySQL features such asTrigger, Stored Procedure, Function, Event, View, and Manage User.

Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to MySQL. With Navicat well-designed Graphical User Interface (GUI), Navicat for MySQL lets you quickly and easily create, organize, access and share information in a secure and easy way, taking MySQL administration.

Navicat for MySQL connects users to any local/remote MySQL Server, providing several database utilities such as Data/Structure Synchronization, Import/Export, Backup and Report, to facilitate the process of maintaining data.

Major Features:

1. MySQL Objects Management
   • Support MySQL servers 3.21 or above
   • Create / drop databases
   • Support all MySQL objects: tables, views, stored procedures/functions and events
   • Support all subobjects: fields, indices, foreign keys and triggers
   • Support of character set and unicode
2. Connection Management and Navigation
   • Multiple local/remote MySQL server connections
   • Connection to MySQL Server through SSH
   • Connection to MySQL Server through HTTP
   • Support SSL secure connection
   • Keep connection alive
   • Backup connection informations
   • Customize selected databases to work with
3. Data Viewer and Editor
   • Grid view
   • Form view
   • Text, Hex and BLOB viewer/editor
   • Copying and pasting selected records
   • Customize display formats
   • Incremental search, sorting and formatting table grid
   • Support of raw mode edit: apply MySQL built-in function
   • Support of foreign key data selection: locate the available values from the reference table
   • Filtering Records
   • Ability to set number of records showing on each page
4. SQL Processing
   • Visual query/view builder to facilitate the process of building complicated queries
   • Ability to create parameter queries
   • Multiple SQL editors with syntax highlighted feature
   • Code completion for SQL editors
   • Ability to preview SQL before execution
   • SQL console
5. Diversified Import and Export Competence
   • Importing data from ODBC: MSSQL, Oracle etc
   • Importing data from MS Excel
   • Importing data from MS Access
   • Importing data from other file formats : TXT, CSV, XML, DBF etc
   • Exporting data to MS Excel
   • Exporting data to MS Access
   • Exporting data to HTML and PDF
   • Exporting data to most popular formats: TXT, CSV, XML, DBF etc
6. Other Data Manipulation Tools
   • Data transfer
   • Transfering data to SQL script as INSERT statement
   • Data synchronization
   • Structure synchronization
7. Backup/Restore
   • Backing up/restoring database
   • Restoring database with chosen database objects
   • Converting backup file into SQL script
   • Backing up database/table to SQL script
   • Executing SQL script
8. Schedule for Batch Job
   • Ability to set schedule on backup, query execution, import/export, data transfer and data synchronization
   • Sending notification e-mail for schedule task
9. Server Security and Maintenance Services
   • Visual user manager to administer users and privileges
   • Ability to duplicate user
   • Analyzing, checking, optimizing and repairing tables
   • Server Monitor to view and change system variables, to view server status information
10. Other Useful Features
    • Duplicate/empty/ truncate tables
    • Create table/view shortcut on desktop
    • Print database/table Structure
    • Support of docking/tab windows
    • Support of virtual grouping: provide logical organization over connections and objects
    • Ability to run profile from command line
    • Log files: keep track on the actions have been performed in Navicat

Enhancements:

1. Added keyboard interactive authentication for SSH.
2. Adjusted the AutoFill from picklist behavior for Grid View.
3. Bug Fixes:
   
   • Fixed export excel spreadsheet with datetime was set to 0.
   • Fixed wrongly treat empty string as null.
   • Fixed access violation when select BLOB/TEXT issue.
   • Disable KeepAliveTimer before executing SQL.

• Microsoft Windows 2000, XP, Vista or 2003
• Pentium II processor or above
• 64 megabytes (MB) of RAM
• Hard-disk space vary depending on installation. Full installation requires 10 MB of available hard-disk space

 WareSeeker Editor