[TUTORIAL] How to access cyberpanel MySQL Remotely

CyberPanel Project Documentation Requests
, ,
1

You already know how to set up Remote SQL for CyberPanel for mysql databases in another destination separate from cyberpanel server.

This tutorial is for users who have cyberpanel server using local mysql or its own installed mysql (as installed by cyberpanel) and want to work on their databases remotely on their devices. Sort of “take your data with you” type of thing for purposes of visualization, analysis, inegration to desktop applications, data manipulation on the fly etc.

  1. Download the latest DBeaver database administration tool as a Eclipse plugin or better yet as a desktop app for Linux (RPM, DEB, snap, flatpak), Windows, Mac (Intel, Apple Silicon).

  2. Install it and setup a New Connection by adding localhost as your server host, port 3306, and your cyberpanel based database e.g. if you create a website mywpsite.com then if you create the database would be myw_database1

DBeaver-PRO
DBeaver-PRO685×536 21.3 KB

  1. Add SSH Tunnel by adding your server ipv4 address, port, sudo username/root, sudo username/root password. Choose authentication method as either PubKey or Password (preferred)

DBeaver-PRO(2)
DBeaver-PRO(2)685×536 20.7 KB

  1. Test Connection and if all goes well you should see everything is all setup

Now you have an end-to-end solution for your website data that you can action on.

2

Very good! I liked the idea. We can access and work on the database, without having to configure remote access directly in the dashboard. :slight_smile:

The option was right there, but sometimes we didn’t test it, well you did. =)