How to make SFTP and MYSQL work remotely?

Question

MySQL

Through SSH I successfully log in and work, but it does not let me through SFTP.
My software:
- FilZilla
- Mysql Query Browser
I can't access either of them.
Server OC: Ubuntu
Optional (from sshd_config):

Protocol 2
Subsystem sftp /usr/lib/openssh/sftp-server

Answer 1

For Mysql, forward the port to your local machine with an ssh tunnel. quintagroup.com/services/support/tutorials/mysql-w...
Then connect to localhost. Well, mysql on the server should listen on 127.0.0.1 (that is, the skip-networking option should not be enabled). Also, if the user is told access denied, then you need to create a user with access from host 127.0.0.1, and not from localhost (localhost in mysql is always a socket).
The option proposed above about creating a user with remote access is extremely insecure - traffic in mysql is not encrypted, you can catch both requests and responses.

Answer 2

Mysql is not clear.
Sftp is simply mounted to the file system, in Windows, in Linux, in Mac. What is your OS?

Answer 3

Filezilla connects fine via SFTP with the same options as SSH.
What error does Filezilla say?

Answer 4

in order to remotely connect to the muscle, you need to create the appropriate user there ( webew.ru/articles/414.webew ). Well, allow the muscle to accept external connections.