mysql connect to remote database – Laravel Connect Remote Database using SSH Tunnel Example

mysql connect to remote database To connect remote database using ssh tunnel in laravel Example with demo step by step bellow.

mysql connect to remote database

We are using Laravel latest version. We can only connect to the remote server via a ssh tunnel. Quick way of connecting remote database with SSH key.

Step 1: Open SSH Tunnel

Syntax:

ssh -N -L 13306:127.0.0.1:3306 [USER]@[SERVER_IP]

Example:

ssh -N -L 13306:127.0.0.1:3306 [email protected]

Example with SSH Key:

ssh -i ./path/to/id_rsa -N -L 13306:127.0.0.1:3306 [email protected]

Step 2: Add MySQL Configuration

.env

...
SERVER_DB_CONNECTION=mysql
SERVER_DB_HOST=127.0.0.1
SERVER_DB_PORT=13306
SERVER_DB_DATABASE=tamilrokers_v1
SERVER_DB_USERNAME=manDsu_54
[email protected]
...

Free Live Chat for Any Issue

Don’t miss : PHP MySQL Connect Database Script

Also Read This πŸ‘‰   How to Store and Retrieve Image from database in Php?

config/database.php

...
'server_mysql' => [
    'driver' => 'mysql',
    'host' => env('SERVER_DB_HOST', '127.0.0.1'),
    'port' => env('SERVER_DB_PORT', '3306'),
    'database' => env('SERVER_DB_DATABASE', 'forge'),
    'username' => env('SERVER_DB_USERNAME', 'forge'),
    'password' => env('SERVER_DB_PASSWORD', ''),
],
...

Step 3: Connect to Remote Server Database

routes/web.php

Route::get('/server-db', function () {
  
    $details = \DB::connection('server_mysql')
            ->table('tamilrokers')
            ->get()
            ->toArray();
  
    dd($details);
});

Result

Array
(
    [0] => stdClass Object
        (
            [id] => 1
            [name] => pakainfo
            [detail] => pakainfo.com demo
            [created_at] => 2021-01-05 03:30:51
            [updated_at] => 2021-01-05 03:31:07
        )
)

I hope you get an idea about mysql connect to remote database.
I would like to have feedback on my infinityknow.com.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.

Rate this post