Home / Questions / 149696
Accepted
elapez
Asked: 2020-03-23 14:28:56 +0800 CST 2020-03-23 14:28:56 +0800 CST

Connect Eloquent ORM to MySQL on a port other than 3306

  • 772

I have a couple of connections to each of them going to a different MySQL database, the issue is that one connects to a local server itself, but the other goes to a remote server and under "another port", I manage connections like this:

$capsule->addConnection([
'driver' => 'mysql',
'host' => LOCAL_DB_HST,
'database' => LOCAL_DB_NAM,
'username' => LOCAL_DB_USR,
'password' => LOCAL_DB_PWD,
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
'prefix' => ''
], "local");

$capsule->addConnection([
'driver' => 'mysql',
'host' => REMOTE_DB_HST,
'database' => REMOTE_DB_NAM,
'username' => REMOTE_DB_USR,
'password' => REMOTE_DB_PWD,
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
'prefix' => ''
], "remota");

It's important to clarify that I'm not using Eloquent as part of Laravel... but as a totally stand-alone implementation.

The issue is that the remote MySQL server uses a port other than 3306 and I don't know how to tell Eloquent to use another port when connecting to the remote server as long as it keeps the default port (3306) for the local connection.

php

1 Answers

  1. Best Answer

    I've never used it without laravel, but I reckon it has to work the same and if so you can specify the port for it. It would be something like this: 

    $capsule->addConnection([
'driver' => 'mysql',
'host' => REMOTE_DB_HST,
'port' => REMOTE_DB_PORT,
'database' => REMOTE_DB_NAM,
'username' => REMOTE_DB_USR,
'password' => REMOTE_DB_PWD,
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
'prefix' => ''
], "remota");

    Within Laravel the configuration of a mysql database is like this, maybe it will help you. 

        'mysql' => [
        'driver' => 'mysql',
        'host' => env('DB_HOST', '127.0.0.1'),
        'port' => env('DB_PORT', '3306'),
        'database' => env('DB_DATABASE', 'forge'),
        'username' => env('DB_USERNAME', 'forge'),
        'password' => env('DB_PASSWORD', ''),
        'unix_socket' => env('DB_SOCKET', ''),
        'charset' => 'utf8mb4',
        'collation' => 'utf8mb4_unicode_ci',
        'prefix' => '',
        'strict' => true,
        'engine' => null,
    ],
    • 1