How to connect to mySql with sftp access to the server?

Question

MySQL

They suggest that you need an ssh tunnel to the muscle port. How to do it? Throw materials or so explain. Thanks

Answer 1

Usually having SFTP access = having SSH access, because SFTP runs on top of SSH.
Try connecting with an SFTP account to the server via an SSH client, such as Putty or its Kitty fork. Having opened a connection and logged in under the account, in the connection parameters:
Connection->SSH->Tunnels
Add new forwarded port:
Source port: 3307 (or any other)
Destination: 127.0.0.1:3306
Local, Auto
Add
After that, the client needs connect to 127.0.0.1:3307 (or whatever you specify)

Answer 2

if only sftp then imkho in any way. If the server outside has http - you can put phpmyadmin, if there is php. Or another base taxiing script. Because sftp is an online file transfer protocol.