Advertisement
Guest User

Untitled

a guest
Jun 24th, 2019
217
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.92 KB | None | 0 0
  1. 'default' => env('DB_CONNECTION', 'mysql1'), *// here I replaced it by 'default' => 'mysql1' to be sure, same effect*
  2.  
  3. 'connections' => [
  4.  
  5. 'mysql1' => [
  6. 'driver' => 'mysql',
  7. 'host' => env('DB_HOST', '127.0.0.1'),
  8. 'port' => env('DB_PORT', '3306'),
  9. 'database' => env('DB_DATABASE', 'MYDB1'),
  10. 'username' => env('DB_USERNAME', 'root'),
  11. 'password' => env('DB_PASSWORD', ''),
  12. 'unix_socket' => env('DB_SOCKET', ''),
  13. 'charset' => 'utf8mb4',
  14. 'collation' => 'utf8mb4_unicode_ci',
  15. 'prefix' => '',
  16. 'prefix_indexes' => true,
  17. 'strict' => true,
  18. 'engine' => null,
  19. 'options' => extension_loaded('pdo_mysql') ? array_filter([
  20. PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
  21. ]) : [],
  22. ],
  23.  
  24. 'mysql2' => [
  25. 'driver' => 'mysql',
  26. 'host' => env('DB_HOST', '127.0.0.1'),
  27. 'port' => env('DB_PORT', '3306'),
  28. 'database' => env('DB_DATABASE', 'MYDB2'),
  29. 'username' => env('DB_USERNAME', 'root'),
  30. 'password' => env('DB_PASSWORD', ''),
  31. 'unix_socket' => env('DB_SOCKET', ''),
  32. 'charset' => 'utf8mb4',
  33. 'collation' => 'utf8mb4_unicode_ci',
  34. 'prefix' => '',
  35. 'prefix_indexes' => true,
  36. 'strict' => true,
  37. 'engine' => null,
  38. 'options' => extension_loaded('pdo_mysql') ? array_filter([
  39. PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
  40. ]) : [],
  41. ],
  42.  
  43. DB_CONNECTION=mysql1
  44. DB_HOST=127.0.0.1
  45. DB_PORT=3306
  46. DB_DATABASE=races
  47. DB_USERNAME=root
  48. DB_PASSWORD=null
  49.  
  50. DB_CONNECTION_SECOND=mysql2
  51. DB_HOST_SECOND=127.0.0.1
  52. DB_PORT_SECOND=3306
  53. DB_DATABASE_SECOND=itra
  54. DB_USERNAME_SECOND=root
  55. DB_PASSWORD_SECOND=null
  56. DEBUGBAR_ENABLED=true
  57.  
  58. DB::connection('mysql1')->select
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement