Tagged articles
Navicat
19 articles · Page 1 of 1
This article reviews three free MySQL client tools—DBeaver, MySQL Workbench, and HeidiSQL—as alternatives to the paid Navicat, highlighting their supported databases, installation, language support, and unique features like built-in monitoring and ER diagrams in MySQL Workbench, which the author recommends for performance testing.
DBeaverER diagramHeidiSQL
0 likes · 6 min read

The author explains how OpenAI's GPT-6 model family with computer-use capabilities and halved pricing eliminates the need for tools like Navicat and reduces Spring to a template, shifting backend developers from code writing to problem definition and model output auditing.
AI-assisted developmentAutomationBenchDeepSWE
0 likes · 5 min read

In under a month the author migrated more than 100 heterogeneous tables from MySQL and MongoDB to PostgreSQL across isolated networks by automating Navicat's import/export logic, streaming data, handling special characters, configuring flexible sync strategies, and using OSS as a bridge to avoid OOM and lock‑contention.
MongoDBMySQLNavicat
0 likes · 20 min read

The author compares IntelliJ IDEA's built‑in database tool with Navicat for running massive SQL dump files, showing that IDEA consistently achieves higher execution speed, lower CPU usage, and no freezes even on multi‑gigabyte scripts, contrary to common expectations.
BackendIDEALarge Files
0 likes · 5 min read

This article provides an extensive overview of widely used database management tools across various platforms—including DBeaver, Navicat, PL/SQL Developer, Toad for Oracle, SQLyog, MySQL Workbench, HeidiSQL, Percona Toolkit, pgAdmin, SQLite Expert, and SSMS—detailing their supported databases, core features, licensing, download links, and related learning resources.
DBeaverDatabase ToolsMySQL
0 likes · 19 min read

The author compares IDEA's built‑in database tool with Navicat for running massive SQL scripts, showing that IDEA consistently uses less CPU, avoids freezes, and achieves higher execution speed—even on files up to 1.83 GB—making it the preferred choice for large‑scale database migrations.
IDEALarge FilesNavicat
0 likes · 5 min read

Learn how to leverage Navicat’s powerful database design, structure synchronization, and backup features using the Mall e‑commerce project as a case study, with step‑by‑step instructions, screenshots, and tips for managing MySQL models, tables, foreign keys, and environment migrations.
Database DesignNavicatStructure Sync
0 likes · 7 min read

Learn how to install MariaDB on Windows, test local connections with Navicat, set up cpolar to create a TCP tunnel, obtain a public address, and configure a fixed TCP port for stable remote access to your MariaDB database from anywhere.
Database AccessMariaDBNavicat
0 likes · 7 min read

A recent threat intelligence report reveals that Navicat Premium has been poisoned via a cracked version distributed from www.macwk.com, prompting users to urgently check for infections, change database passwords, and consider safer alternatives like Sequel Pro or IntelliJ IDEA's built‑in database client.
Alternative ToolsDatabase ToolsNavicat
0 likes · 5 min read

This article provides a step‑by‑step tutorial for setting up a MySQL database on a CentOS server, covering database creation, import, phpMyAdmin installation and configuration, Navicat installation and activation, opening required ports, and configuring remote user access for successful connections.
CentOSNavicatphpMyAdmin
0 likes · 2 min read

This article walks you through using Navicat for MySQL to create databases and tables, design table structures, and perform native SQL SELECT queries—including filtering, multiple conditions, and column selection—illustrated with step‑by‑step screenshots and code examples.
Database DesignMySQLNavicat
0 likes · 7 min read

Learn how to completely uninstall any existing MySQL, install MySQL 8.0 via dnf or yum, verify the installation, configure it to start on boot, manage root passwords, and set up remote access with Navicat, all with clear commands and screenshots.
Database InstallationLinuxMySQL
0 likes · 6 min read

This article walks through installing MySQL Workbench, demonstrates its core database management features such as creating connections, adjusting appearance, handling tables and data, executing SQL, and managing instances, then compares it with Navicat, highlighting differences in design, backup, multi-database support, and unique capabilities.
MySQL WorkbenchNavicatdatabase management
0 likes · 6 min read

This tutorial walks you through using Navicat 12 to design, relate, and export a database schema for a mall permission management module, covering model opening, table creation, foreign‑key setup, auto‑layout, SQL export, and reverse engineering with clear screenshots.
Database DesignForeign KeysNavicat
0 likes · 7 min read

This tutorial explains how to use Navicat to back up a test database, delete and restore product data, and synchronize schema changes between test and production databases, providing detailed step‑by‑step instructions with screenshots.
NavicatSQLStructure Sync
0 likes · 5 min read

This tutorial walks you through logging into Navicat, creating a MySQL database, designing a table with fields and a primary key, inserting sample data, and running a simple SELECT query, all illustrated with screenshots for clear, hands‑on learning.
Database TutorialMySQLNavicat
0 likes · 5 min read

This step‑by‑step guide shows how to edit MySQL’s my.cnf on Ubuntu 14.04, change the bind‑address, restart the service, grant remote privileges, and verify the connection using Navicat, enabling secure remote database access.
Database ConfigurationMySQLNavicat
0 likes · 6 min read

This tutorial walks you through launching Navicat, creating a new MySQL connection by entering host details, testing the connection, handling common authorization errors, and finally accessing and managing the remote database directly from Navicat.
Connection TutorialMySQLNavicat
0 likes · 4 min read

This article walks you through the complete installation process of Navicat for MySQL on Windows, covering download, version selection, license agreement, installation path, shortcut options, and final setup, with clear screenshots for each step.
Database ToolsMySQLNavicat
0 likes · 4 min read
