Mysql Connect To Remote Database

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

Contents

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
SERVER_DB_PASSWORD=example455455@555
...

Don’t miss : PHP MySQL Connect Database Script

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.

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