Laravel MySql DB Connection with SSH

by

Here’s a workable solution of working with a database hosted on an EC2 instance via SSH w/ a key.

First, setup a corresponding connection in your database config:

'mysql_EC2' => array(
        'driver'    => 'mysql',
        'host'      => '127.0.0.1:13306',
        'database' => 'EC2_website',
        'username' => 'root',
        'password' => 'xxxxxxxxxxxxxxxx',
        'charset'   => 'utf8',
        'collation' => 'utf8_unicode_ci',
        'prefix'    => '',
    ),

Second, establish a tunnel:

ssh -i ~/dev/awskey.pem -N -L 13306:127.0.0.1:3306 [email protected]

(we pass in the SSH key to the i parameter and establish an SSH connection, binding to port 13306)

Third, use the DB how you normally would in a Laravel App:

$users = DB::connection('mysql_EC2')
        ->table('users')
        ->get();

var_dump($users);

More Related Contents:

  1. How to execute a MySQL command from a shell script?
  2. MySQL connection over SSH tunnel
  3. Creating MYSQL Procedure in Laravel 4 Migrations
  4. i have an error which i dont understand. can you help me? [closed]
  5. How do you use the “WITH” clause in MySQL?
  6. mysql error 1364 Field doesn’t have a default values
  7. SQL: What is the default Order By of queries?
  8. How to group by week in MySQL?
  9. Can I use a function for a default value in MySql?
  10. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  11. Mysql order by specific ID values
  12. How do I check if a column is empty or null in MySQL?
  13. MySQL versus PDO [duplicate]
  14. Mysql string split [duplicate]
  15. Increment a database field by 1
  16. Measuring actual MySQL query time
  17. Am I Using JDBC Connection Pooling?
  18. MySQL VARCHAR Lengths and UTF-8
  19. Row number per group in mysql
  20. Find and replace entire MySQL database
  21. is there a mysql function to decode html entities?
  22. MySQL fails on: mysql “ERROR 1524 (HY000): Plugin ‘auth_socket’ is not loaded”
  23. MySQL – SQL_BIG_SELECTS
  24. How to Prevent Connection Timeouts for Large MySQL Imports
  25. How to use MySQL DECIMAL?
  26. MySQL: return updated rows
  27. mysql count group by having
  28. SQL UPDATE with sub-query that references the same table in MySQL
  29. MySQL: Computed Column
  30. Mysql server does not support 4-byte encoded utf8 characters

Leave a Comment