Archive for October 22nd, 2008

tunneling and mysql

by Dave Dash 22Oct08

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


Where am I?

You are currently browsing the Spindrop weblog archives for the day Wednesday, October 22nd, 2008.

Longer entries are truncated. Click the headline of an entry to read it in its entirety.

October 2008
M T W T F S S
« Aug   Nov »
 12345
6789101112
13141516171819
20212223242526
2728293031  

need more help

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.