How to Connect Remote Database in Laravel 5 using ssh

Question

I am using Laravel 5.0. I Want to Know How to Access Remote Database using SSH.

database.php

'mysql' => [
            'driver'    => 'mysql',
            'host'      => 'www.xxxxx.in',
            'port' => '2222',
            'database'  => 'xxxx_xxx',
            'username'  => 'xxxxx_xx',
            'password'  => 'xxxx0xx',
            'charset'   => 'utf8',
            'collation' => 'utf8_unicode_ci',
            'prefix'    => '',
            'strict'    => false,
            'engine'    => null,
        ],

I am interested in the answer to this question. Not only for the Laravel scenario but for others as well — Igbanam
– Igbanam, Commented Mar 16, 2016 at 12:40

Alexey Mezenin · Accepted Answer · 2016-03-16 12:44:14Z

8

You should create SSH tunnel.

More about SSH tunnel and some examples here: http://chxo.com/be2/20040511_5667.html

Example:

ssh -fNg -L 3307:127.0.0.1:3306 [email protected]
mysql -h 127.0.0.1 -P 3307 -u dbuser -p db

Of course, then you need to change credentials:

'mysql' => [
            'driver'    => 'mysql',
            'host'      => 'www.xxxxx.in',
            'port'      => '3307',
            'database'  => 'xxxx_xxx',
            ...
        ],

edited Mar 16, 2016 at 12:44

answered Mar 16, 2016 at 11:53

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Don't Panic Over a year ago

I am looking for a good answer to point duplicates of this question to - this would be it, but the config shown is wrong, and will confuse ppl who are asking this question. I suggest www.xxxxx.in should be changed here to 127.0.0.1 to avoid confusion.

Community · Accepted Answer · 2017-05-23 12:31:58Z

You will need to create an SSH Tunnel as Alexey says.

You will also need to port-forward the MySQL connection port to your local; as Alexey has done also.

Then in your Laravel config, set the port to the forwarded port. So building off Alexey's answer, your database configuration would read thus

'mysql' => [
      'driver'    => 'mysql',
      'host'      => 'www.xxxxx.in',
      'port'      => '3307',
      'database'  => 'xxxx_xxx',
      'username'  => 'xxxxx_xx',
      'password'  => 'xxxx0xx',
      'charset'   => 'utf8',
      'collation' => 'utf8_unicode_ci',
      'prefix'    => '',
      'strict'    => false,
      'engine'    => null,
],

EDIT
In case Alexey's answer goes away, these are the relevant parts to my answer

Create the ssh tunnel

ssh -fNg -L 3307:127.0.0.1:3306 [email protected]

Connect locally using

mysql -h 127.0.0.1 -P 3307 -u dbuser -p db

Collectives™ on Stack Overflow

How to Connect Remote Database in Laravel 5 using ssh

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related