Quickly Set Up Remote MySQL Connections with Navicat – Step‑by‑Step Guide

Previously we shared a detailed Navicat installation guide; this article provides a concise tutorial on using Navicat to connect to a remote MySQL database.

1. Double‑click the Navicat desktop icon to launch the application.

2. The main Navicat window displays the navigation bar and various tabs.

3. Click the connection button at the top left to open the "New Connection" dialog, then enter the host name or IP address, keep the default port, and provide the username and password.

4. After filling in the details, click "Test Connection". If the test fails, an error message will appear.

If the error indicates that the root user lacks privileges, grant the necessary rights on the MySQL server and retry.

5. When the connection test succeeds, the database is added without errors.

6. Click OK; the newly added database (e.g., IP 192.168.255.131) appears in the Navicat main window.

7. Double‑click the listed database to view its information and begin remote operations, which stay synchronized with the MySQL instance on Ubuntu.

At this point, the Navicat remote connection setup is complete.