Configs

Local database

local

name: localhost
host: 127.0.0.1
port: 3306
user: root
password: root

Remote database

remote

name: server
host: 127.0.0.1
port: 3306
user: <server-mysql-username>
password: <server-mysql-password>
ssl_mode: preferred
over_ssh: true
server: <server-ipv4>

SSH config

port: 22
user: <server-username>
use_ssh_key: <import-ssh-key-private>