I have a Laravel app on my local PC. I want to use a remote database instead of the local DB. I know we can change the host to the other server's IP but in my case I have to access MySQL only through SSH credentials. I only have the SSH user/password.
In Laravel how can I use the SSH user/pass to connect to the MySQL DB from a remote PC?
Possibly the following can be one solution but I don't want to go for this: Laravel MySql DB Connection with SSH
DB server has a dedicated IP but my webserver doesn't have any dedicated IP and is subject to change at any time. I am not allowed to execute any kind of SSH command on remote DB server.
For now I am able to connect to this DB through SQL-Yog using the SSH credentials even without executing the SSH command as suggested in the above mentioned solution. So I wonder if there can be some solution to this in Laravel as well.