So I have been fighting this for some time now and I can’t seem to figure out how to properly connect to an online instance of PHPMyAdmin using a local tool such as TablePlus.
PLEASE NOTE: All of the IPs and connection data will be dummy data, but I will use it as an example.
So here are the details:
So I have a DigitalOcean Server with a CyberPanel droplet, I am able to connect to that droplet using: ssh email@example.com - I can also access phpMyAdmin using: https://126.xxx.xxx.xxx:8xxx/dataBases/phpMyAdmin.
On CyberPanel, they allow remote access, so I can set my IP: 99.xxx.xxx.xxx as the host.
When I login to PHPMyAdmin, I can see the following “Database Server” information:
Server: Localhost via UNIX socket
Server type: MariaDB
Server connection: SSL is not being used Documentation
Server version: 10.6.12-MariaDB-0ubuntu0.22.04.1 - Ubuntu 22.04
Protocol version: 10
Server charset: UTF-8 Unicode (utf8mb3)
Yes. You can make it work very easy using DBeaver by creating a connection to localhost if you cannot use remote ip e.g.
Server Host -> localhost Port->3306
Host/IP -> server ip address (ipv4)
Root -> server root/sudo username
Password-> server root/sudo user password
Port-> server port (22 or custom port you set on cyberpanel)
Authentication Method-> Password or PublicKey (if you set pubkey ssh key)