MySQL connection over SSH tunnel – how to specify other MySQL server?

by

Solved it! The thing was to connect to the correct server when creating the tunnel itself – should’ve seen that one coming.

ssh -f [email protected] -L 3307:mysql1.example.com:3306 -N

Then mysql -h 127.0.0.1 -P 3307 worked as intended. 🙂

More Related Contents:

  1. MySQL connection over SSH tunnel
  2. get first occurrence of last changed value of a column [closed]
  3. ROW_NUMBER() in MySQL
  4. MySQL Error #1071 – Specified key was too long; max key length is 767 bytes
  5. How can I temporarily disable a foreign key constraint in MySQL?
  6. Creating a “Numbers Table” in MySQL
  7. MYSQL Select MAX Date inside a join statement
  8. Choosing a stand-alone full-text search server: Sphinx or SOLR? [closed]
  9. Determine which MySQL configuration file is being used
  10. Rails, MySQL and Snow Leopard
  11. In SQL, how to select the top 2 rows for each group
  12. MySQL CONVERT_TZ()
  13. TRIGGERs that cause INSERTs to fail? Possible?
  14. Mysql query to dynamically convert rows to columns on the basis of two columns
  15. MySQL: #126 – Incorrect key file for table
  16. MYSQL Left Join COUNTS from multiple tables
  17. Error Code: 1290. The MySQL server is running with the –secure-file-priv option so it cannot execute this statement
  18. MySQL my.ini location
  19. Comma separated string of selected values in MySQL
  20. MySQL: ALTER IGNORE TABLE ADD UNIQUE, what will be truncated?
  21. Getting first day of the week in MySql using Week No
  22. error code 1292 incorrect date value mysql
  23. How to search for rows containing a substring?
  24. Import CSV to Update only one column in table
  25. MySQL : how to remove double or more spaces from a string?
  26. Error in MySQL library for Node.js
  27. Equivalent of MSSQL IDENTITY Column in MySQL
  28. Update multiple rows with multiple ‘where’ clauses for each individual row
  29. WHERE datetime older than some time (eg. 15 minutes)
  30. Is there a way to use ON DUPLICATE KEY to Update all that I wanted to insert?

Leave a Comment