Access your Database on VPS from your Computer with Navicat

Navicat is software for managing databases from various sources, either from local/personal PCs or from servers. Navicat for MySQL is software for MySQL database administration and development. This software works with MySQL Database Server from version 3.21 or above, and supports most of the latest MySQL features including Trigger. Stored Procedure, Event Function, View, Manage User, etc.

For this configuration, use a VPS that has MySQL installed on the OS:

1. Prepare the MySQL Hostname, port, username, and password, then fill in the following fields according to the data that has been prepared.
2. Next prepare the IP, linux user, and public key server.
3. Then click Test Connection and if successful it displays the following information.

The configuration process has been completed, now you can access the database server using Navicat, you can manage the database easily and quickly (depending on your internet connection) via Navicat.

Thank You.