I have a mysql server for reviewsby.us that requires tunneling, and after establishing a tunnel like so:
deveshistan:~ dash* ssh user@host -L3307:database_server:3306
I thought I could just do this:
mysql -u mysql_user -P3307 -h localhost
But I was wrong, localhost should be 127.0.0.1, otherwise mysql will do things in socket mode:
mysql -u mysql_user -P3307 -h 127.0.0.1
This is a single entry in the weblog.
"tunneling and mysql" is filed under programming. It was published in October 2008.
| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| « Aug | Nov » | |||||
| 1 | 2 | 3 | 4 | 5 | ||
| 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| 13 | 14 | 15 | 16 | 17 | 18 | 19 |
| 20 | 21 | 22 | 23 | 24 | 25 | 26 |
| 27 | 28 | 29 | 30 | 31 | ||
If you found our tutorials and articles to be useful, but are still looking for more hands on help, consider hiring us. Find out more about how Spindrop can help you.
If you require more hands on assistance, we do offer affordable hands on support.
