Laravel框架操作多数据库配置（mysql）_laravel 指定mysql options-优快云博客

config的database.php文件

//默认使用mysql这个配置
	   'mysql' => [
            'driver' => 'mysql',
            'url' => env('DATABASE_URL'),
            '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' => '',
            'prefix_indexes' => true,
            'strict' => false,
            'engine' => null
	        ],
		//新增配置
        'mysql_extend' => [
            'driver' => 'mysql',
            'host' => env('DB_HOST_EXREND', '127.0.0.1'),
            'port' => env('DB_PORT_EXREND', '3306'),
            'database' => env('DB_DATABASE_EXRENDR', 'forge'),
            'username' => env('DB_USERNAME_EXREND', 'forge'),
            'password' => env('DB_PASSWORD_EXREND', ''),
            'charset' => 'utf8',
            'collation' => 'utf8_unicode_ci',
            'prefix' => '',
            'strict' => false,
            'engine' => null,
        ],

.env文件配置

DB_CONNECTION=mysql
DB_HOST=xx.xxx.xx.xxx
DB_PORT=3306
DB_DATABASE=xxx
DB_USERNAME=xxx
DB_PASSWORD=xxxxxxxx
//新增
DB_HOST_EXREND=xx.xxx.xx.xxx
DB_PORT_EXREND=3306
DB_DATABASE_EXREND=xxx
DB_USERNAME_EXREND=xxx
DB_PASSWORD_EXREND=xxxxxxx

model的配置

class OrderFrom extends Model
{
    protected $connection='mysql_extend';  
    protected $table = 'tablename';
}

.env配置不生效执行清除缓存命令
php artisan cache:clear
php artisan config:clear