I know there are quite a few tutorials about this, but I can not get it to work on my machine.
So I have a MySQL database running on:
Server: dbhost.net Name: mydbuser PW: mydbuserpwd Port: 3306
This database is reachable via an SSH connection as this:
Server: dbhost.net Name: mysshuser PW: using my ssh public key
Now I have a local app installed that is asking me for my MySQL credentials - when I enter my normal MySQL credentials from above this will not work. So I need to enter something (Server, Username, Password) in the app that is then establishing a connection to the database via the SSH connection as mentioned above. How do I do that? I tried it with:
ssh -L 1025:127.0.0.1:3306 -p 22 -l mysshuser -N dbhost.net
And then using
127.0.0.1:1025 in the app, but this doesn't do anything. Can you assist?