• Welcome to Navicat MySQL
• System Requirements
• Feature Matrix
• Registration
• Installation
• Upgrade
• License Agreement

• Getting Started
• Installing MySQL for Linux
• Localhost Connection Settings
• Remote Connection Settings
• First time started
• Working with databases
• Working with databases objects
• Using Navigation Pane
• Using connection popup menu
• Using database popup menu
• Using object popup menu
• Virtual Grouping

• Connection Settings
• General Settings
• SSH Settings
• Benefit of SSH Tunneling
• Password Authentication
• Publich Key Authentication
• SSL Settings
• Installation of OpenSSL and MySQL
• Setting up SSL Certificate for MySQL
• Setting up Client Certificate for Navicat
• Advanced Settings
• Database Management
• Setting Advanced Database Properties

• Database Object Management
• Tables
• Table Designer
• Fields
• Setting Field Name and Data Type
• Setting Field Size and Decimals
• Setting Field Flags
• Setting Other Field Properties
• Indexes
• Settng Index Name and Index Type
• Setting Single- and Multi- Field Indexes
• Foreign Keys
• Setting Foreign Key Name and Table Fields
• Setting On Delete and On Update Actions
• Triggers
• Setting Trigger Name, Time and Statement
• Setting Trigger Event
• Options
• Setting Table Properties
• Setting Auto Increment and Table Flags
• Comment
• Table Viewer
• Data View
• Grid View
• Using Navigation Bar
• Limit Record Setting
• Editing Records
• Editing Records with Special Handling
• Editings Records with Foreign Key
• Copying/Pasting Data from/into Navicat
• Sorting and Finding Records
• Filtering Records
• Manipulating Raw Data
• Formatting Table Grid
• Form View
• Text/Blob View
• Viewing/Editing Text field as Memo
• Viewing/Editing Text/Blob field as Hexadecimal
• Viewing/Editing Blob field as Graphical Image
• Filter Wizard
• Adding New Filter Condition
• Setting Filter Criteria
• Setting Filter Operator
• Setting Filter Criteria Values
• Setting Filter Group
• Applying Filter Conditions
• Views
• View Designer
• Working with Visual Builder
• Editing SQL Definition
• Setting Advanced View Properties
• View Viewer
• Stored Procedures/Functions
• Stored Procedure Designer
• Editing Stored Procedure/Function Definition
• Setting Advanced Stored Procedure/Function Properties
• Editing Stored Procedure/Function Comment
• Viewing Stored Procedure/Function Result
• Events
• Event Designer
• Editing Event Definition
• Setting Advanced Event Properties
• Editing Event Comment

• Queries
• Query Builder
• Working with Diagram Area
• Setting Field Association
• Setting Output Fields
• Setting Criteria
• Setting Grouping Criteria
• Setting Sorting Criteria
• Setting Limit Criteria
• Query Editor
• Working with Code-Completion
• Query Results
• Query Explain
• Query Parameters

• Data Management Tools
• Import Wizard
• Setting Import File Format (Step 1)
• Setting Source File Name (Step 2)
• Setting Additional Options for Specific Table Type
• Setting Delimiter (Step 3) - TXT, XML
• Setting Data Format (Step 4) - TXT, XML, Excel, HTML
• Setting Target Table (Step 5)
• Adjusting Field Structures and Mapping Fields (Step 6)
• Selecting Import Mode (Sep 7)
• Saving and Confirming Importing (Step 8)
• Export Wizard
• Setting Export File Format
• Setting Destination File Name and Encoding
• Selecting Fields for Export
• Setting Data Format
• Saving and Confirming Export
• Data Transfer
• General Settings
• Advanced Settings
• Message Log
• Data Synchronization
• General Settings
• Advanced Settings
• Message Log
• Structure Synchronization
• General Settings
• Advanced Settings
• Message Log
• Backup/Restore
• Backup
• General Settings
• Advanced Settings
• Message Log
• Backup by Dumping SQL File
• Restore
• General Settings
• Object Selection
• Advanced Settings
• Message Log
• Restore by Execute Batch File
• Extract SQL
• Batch Job/Schedule
• General Settings
• Advanced Settings (E-mail Notification)
• Message Log
• Schedule Setting Examples
• Print Database/Table Structure
• Log Files

• Server Security Management
• Privileges Provided by MySQL
• User Editor
• Setting Advanced User Properties
• Setting User SSL Properties
• Setting Global Privileges
• Setting Database Specific Privileges
• Setting Table Specific Privileges
• Setting Column Specific Privileges
• Stored Procedure Specific Privileges

• MySQL Maintenance Tasks
• Analyze Tables
• Check Tables
• Optimize Tables
• Repair Tables
• Server Monitor
• Process List
• Variables
• Status
• Flush

• Options
• General Options
• Code Insight Options
• Appearance Options
• Color Options
• Main Window Options
• Detail View Options
• Data/Grid Options
• Display Format Options
• Miscellaneous Options