How to connect remote database in Laravel using ssh?

Question

SSH

hello, I need to connect the database of one project to another, how can this be done using ssh?

Answer 1

1. you need to establish a tunnel
ssh -i ~/keys/key.pem -N -L 13306:127.0.0.1:3306 [email protected]_ip
2 configure the appropriate connection in the laravel configuration
https://laravel.com/docs/5.8/database# configuration

Answer 2

ssh -i ~/openssh_key -L YOUR_PORT:DATABASE_HOST:DB_PORT [email protected]_HOST