Linux socket-to-socket tunnel (MySQL example)

socat "UNIX-LISTEN:/tmp/mysqld.temp.sock,reuseaddr,fork" EXEC:"ssh username@remoteserver.com socat STDIO UNIX-CONNECT\:/var/run/mysqld/mysqld.sock"

Won't work with password login. You must add your RSA key to the server's authorizedkeys file, or change the ssh command adding the -i option for a custom RSA key:

socat "UNIX-LISTEN:/tmp/mysqld.temp.sock,reuseaddr,fork" EXEC:"ssh username@remoteserver.com -i /home/user/rsa-keys/id_rsa socat STDIO UNIX-CONNECT\:/var/run/mysqld/mysqld.sock"

--- /tmp/mysqld.temp.sock will be created locally by socat, don't create it yourself. The folder it lives must be writable. Connect your MySQL client to this socket, with database and username set properly. --- In case you need to forward a remote socket to a LOCAL PORT instead, check http://www.commandlinefu.com/commands/view/9436/socat-tcp-listen5500-execssh-userremotehost-socat-stdio-unix-connectvarrunmysqldmysqld.sock

By: paulera

2017-07-27 11:32:19

Submit An Alternative

What Others Think

sattamatkatips · 364 weeks and 4 days ago

Example for coding is now here. If you are waiting to different coding then you must have to take some examples here which tell you more for essaypro review. I know all these things helping us to make our coding work perfect and we have to make our work best after taking help from here.

Brookeeyes · 244 weeks ago

Command and all tips of the joy are filled for the enhancement of the goals. The objective of the research paper help is assured for the improvement of the goals. The struggle is difficult. The potent oil is filed for future items. The theory is explained by humans.

KennethOrozco · 243 weeks and 3 days ago

This article is massively delighting and orchestrated to research you said the right we never do the trade on the whole issues and religion in any event or gathering https://tspiglobal.com the manner in which that the assessment about them wreck the event and annihilate all fulfillment.

Katrinaields · 238 weeks and 3 days ago

This brief article will discuss the nature of a compression fracture and how to treat this diagnosis. One such way is to best spine doctor near me use a well-made brace that can help you promote the healing process. We will discuss more in this article.

PriscillaScott · 235 weeks and 4 days ago

One had the perfect traits of a boxer - quick hands, unparalleled foot speed, great reach. The ability to avoid, and later take most punches, all with the grace of a gazelle. The little caesars hot and ready other had all the fine makings of a singer: perfect pitch, vibrato, presence, incredible phrasing, a finger-snapping style. He was, in short, the voice.

ChandraHill · 234 weeks and 6 days ago

I'm constantly searching on the internet for posts that will help me. Too much is clearly to learn about this. Custom Patches I believe you created good quality items in Functions also. Keep working, congrats!

muneerahmed · 216 weeks and 4 days ago

You have done a great job. I will definitely dig it and personally recommend to my friends. keyword search I am confident they will be benefited from this site.

muneerahmed · 215 weeks and 2 days ago

Excellent article plus its information and I positively bookmark to this site because here I always get an amazing knowledge as I expect. Custom Embroidered Patches Thanks for this to share with us

muneerahmed · 214 weeks and 6 days ago

So luck to come across your excellent blog. Your blog brings me a great deal of fun.. digitizing embroidery service Good luck with the site.

muneerahmed · 214 weeks and 6 days ago

very good post. http://www.winmilliongame.com">???? ?? ????? ??????? http://www.gtagame100.com">???? ???? http://www.subway-game.com">?? ??? ?????? http://www.zumagame100.com">???? http://www.pubggame100.com">???? http://www.clash-games.com">????? ????

emadgad45 · 214 weeks and 3 days ago

such a great post. http://www.winmilliongame.com http://www.gtagame100.com http://www.subway-game.com http://www.zumagame100.com http://www.games-game.com http://www.pubggame100.com http://www.clash-games.com

emadgad45 · 214 weeks and 3 days ago

I am extremely delighted in for this web journal. Its a useful subject. It help me all that much to take care of a few issues. Its chance are so awesome and working style so rapid. buy neopets items

muneerahmed · 210 weeks and 3 days ago

If you are looking for thanksgiving wishes visit https://onsumo.com/thanksgiving-wishes-greetings-messages/

zaidavargas · 203 weeks and 3 days ago

Thanksgiving is coming so send thanksgiving wishes to your family and friends

zaidavargas · 203 weeks and 3 days ago

Find the perfect weed killers and preventers http://weedeater2020.simplesite.com/">organic weed killer

Charles231 · 200 weeks and 1 day ago

Find the perfect weed killers and preventers http://weedeater2020.simplesite.com/

Charles231 · 200 weeks and 1 day ago

I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well. In fact your creative writing abilities has inspired me to start my own BlogEngine blog now. Really the blogging is spreading its wings rapidly. Your write up is a fine example of it. houston embroidery service

muneerahmed · 200 weeks ago

I am extremely delighted in for this web journal. Its a useful subject. It help me all that much to take care of a few issues. Its chance are so awesome and working style so rapid. Premium Tax Credit

muneerahmed · 196 weeks ago

Great article with excellent idea!Thank you for such a valuable article. I really appreciate for this great information.. http://worldandus.co.uk/members/jonydeepcustom34/activity/118940/">http://worldandus.co.uk/members/jonydeepcustom34/activity/118940/

muneerahmed · 195 weeks and 6 days ago

Untuk panduan poker, kunjungi https://onlinepokertips.wixsite.com/pokeronline

zaidavargas · 195 weeks and 3 days ago

any new recent updates with the forum?? dentalimplantsfortwaynein.com

Killersmile · 179 weeks and 6 days ago

Thanks for the info. https://www.bloglovin.com/@waqasjamal/how-to-make-your-own-chinese-traditional

zaidavargas · 177 weeks and 6 days ago

Visit our review about PGAnabolics

zaidavargas · 174 weeks and 3 days ago

Buy instagram verification http://getverifiedbadge.iwopop.com/">? from us on cheap rate

zaidavargas · 165 weeks and 3 days ago

seofox · 136 weeks and 3 days ago

where to get shrooms dried mushrooms african pyramid mushroom african transkei mushroom albino penis envy b+ mushrooms blue meanies mushroom brazilian magic mushroom burmese mushroom golden teacher mushroom ko samui super strain malabar coast martinique mexican mushroom mushroom british columbia super thai mushroom nepalese chitwan mushroom penis envy texas penis envy 6 texas yellow caps vietnamese white jedi mind fuck tri coloured ecuadorian mushroom magic mushsroom edibles mexican cubensis psychedelic chocolate bar where to get shrooms dried mushrooms african pyramid mushroom african transkei mushroom albino penis envy b+ mushrooms blue meanies mushroom brazilian magic mushroom burmese mushroom golden teacher mushroom ko samui super strain malabar coast martinique mexican mushroom mushroom british columbia super thai mushroom nepalese chitwan mushroom penis envy texas penis envy 6 texas yellow caps vietnamese white jedi mind fuck tri coloured ecuadorian mushroom magic mushsroom edibles mexican cubensis psychedelic chocolate bar midnight mint psychedelic chocolate bar origin mango psilo gummies 0.25g-1g origin strawberry psilo gummies 0.25g-1g penis envy psychedelic chocolate bar psilocybin cube gummies vegan dark chocolate psychedelic chocolate bar microdoses brain capsules 50mg-200mg chill capsules 50mg-200mg clarity capsules 50mg-200mg health capsules 50mg-200mg love capsules 50mg-200mg mood capsules 50mg-200mg pure capsules 50mg-200mg social capsules 30 pack 350mg social capsules 5 pack 350mg buy weed online without medical card marijuana flowers types of concentrates cannabis cartridges buy edibles online legal marijuana shatter cannabis wax marijuana hash buy psychedelic online tinctures for anxiety cannabis seeds bank weed smoker accessories birthday cake kush acdc strain ace killer og strain ak 47 strain alaskan thunder fuck alien kush strain ambrosia kush strain atomik moon rocks cbd 40.57% atomik moon rocks diamond 58.77% banana og strain bc big bud strain birthday cake kush blue cheese strain blue dream og kush blue moonrock kush blue rhino strain blueberry kush strain bruce banner strain cannabis trim cherry pie strain cannatonic strain citrix strain dark star kush durban poison strain eleven roses strain g13 haze strain gelato strain girl scout cookies flavors girl scout cookies online granddad purple strain grape nana weed strains grape pie strain green crack strain guava kush strain hawaiian skunk jack herer strain mendo breath weed mighty mango mr nice guy weed blue mystic strain northern lights strain northern lights moon rock platinum og kush gas og strain pink og kush platinum hawaiian strain pootie tang strain purple mimosa strain purple white widow strain smart buds sour diesel weed strain sour moonrock strain space monkey tins strawberry banana weed sun rocks super citrus haze strain super silver haze wedding cake strain exotic white widows strain zombie kush strain

johnson20007 · 136 weeks and 1 day ago

seofox · 117 weeks and 3 days ago

williamsjoycej · 113 weeks ago

französischen bulldogge französischen bulldogge welpen französischen bulldogge welpen kaufen französische bulldoggen welpe französische bulldogge züchter französische bulldogge preis hirschgeweih hirschgeweih kaufen hirschgeweih deko hirschgeweih hund hirschgeweih preis pro kg taxidermied taxidermy deutsch taxidermied animals taxidermie sugar gliders for sale how much is a sugar gliders hedgehogs for sale sugar gliders for sale Ohio

khus · 112 weeks and 2 days ago

Amazing! This blog looks just like my old one! It's on a completely different subject but it has pretty much the same layout and design. Wonderful choice of colors! Pug Puppies for Sale Near Me PUG PUPPY FOR SALE NEAR ME PUG PUPPIES FOR SALE pug puppies for sale in kentucky Pug Puppies for Sale Under $500 Near Me pug puppies for sale in texas pugs puppies for sale teacup pugs for sale pug puppies for sale by owner pug puppies ohio

rahimhh21 · 107 weeks and 5 days ago

ExcellentHome · 104 weeks and 2 days ago

Perfecthomepugs · 97 weeks and 5 days ago

how long does ketamine stay in your system / buy ketamine / buy ketamine online / Buy Ketamine Online USA / Where to buy ketamine Online in California USA / Buy Ketamine Online France Where To Buy Ketamine Online In Canada | Buy ketamine Buy Ketamine Online Buy Ketamine Online USA Where to buy ketamine Online in California USA Ketamine For Sale Discreet Shipping UK Buy Ketamine Near Me Europe Buy Ketamine Online France Buy Ketamine Online NEAR ME where to buy ketamine in USA how to buy ketamine Online USA Discreet Shipping Ketamine HCL For Sale In Los angeles Buy Ketamine Powder Online Buy Ketamine online In Australia Where To Buy Ketamine Online In Canada | order ketamine online WhatsApp text and call + 1 (408) 634 4006 Email:jugeketamine1@gmail.com weather you need bulk in kilos or retail in grams neither liquids in vials or liquid in litters we are specialize only in ketamine supply

Princesmith · 91 weeks and 4 days ago

Princesmith · 91 weeks and 1 day ago

Buy Ketamine Online For Sale USA MDMA For Sale USA Shipping Psychedelic Drugs For Sale USA DMT For Sale USA Ayahuasca For Sale Online Queensland Buy LSD Online Legally Ketamine Liquid For Sale Buy Ketamine Pills Online Delivery Magic Mushroom For Sale USA Buy mushrooms edibles Online

medicalhouse25 · 86 weeks and 2 days ago

I have learned a lot that I can apply to my research paper on this subject. I appreciate you sharing mapquest directions this insightful information.

adamusa · 67 weeks and 1 day ago

Great job for publishing such a beneficial web site. Your web log isn’t only useful but it is additionally really creative too. PhenQ Reviews

Digitalwork · 62 weeks ago

liltommy · 60 weeks and 2 days ago

pugpuppies95 · 60 weeks and 2 days ago

liltommy · 59 weeks and 6 days ago

Only strive to mention one's content can be as incredible. This clarity with your post is superb! Thanks a lot, hundreds of along with you should go on the pleasurable get the job done. Love Style Quiz

Digitalwork · 59 weeks and 4 days ago

Wow! This could be one of the most useful blogs we have ever come across on thesubject. Actually excellent info! I’m also an expert in this topic so I can understand your effort. gwinbola

Digitalwork · 57 weeks and 4 days ago

sosamann · 57 weeks and 3 days ago

order runtz weed online worldwide buy weed online worldwide shipping buy exotic runtzweed online buy marijuana online cheap buy marijuana online with worldwide shipping real weed for sale where to buy runtz weed online for sale order runtz flowers online buy runtz weed flowers online buy runtzweed online worldwide order weed online worldwide buy weed online worldwide shipping buy exotic weed online buy marijuana online cheap buy marijuana online with worldwide shipping real weed for sale marijuana flower for sale buy marijuana flowers online buy weed flowers online buy weed online worldwide order rapsnacks online worldwide buy rapsnacks online worldwide shipping buy rapsnacks online buy rapsnacks online cheap buy rapsnacks online with worldwide shipping real rapsnacksfor sale rapsnacks for sale buy rapsnacks online buy rapsnacks online buy rapsnacksonline worldwide order runtz weed online worldwide buy runtz weed online worldwide shipping buy runtz exotic weed online buy marijuana online cheap buy marijuana online with worldwide shipping real runtz weed for sale marijuana flower for sale buy marijuana flowers online buy runtz weed flowers online buy runtz weed online worldwide

liltommy · 53 weeks ago

donperi1 · 52 weeks and 6 days ago

Thank you for sharing a bunch of this quality contents, I have bookmarked your blog. Please also explore advice from my site. I will be back for more quality contents. Local SEO Corby

Digitalwork · 51 weeks ago

Upgrade your industrial projects with the finest flange and fittings from Piping Flanges at https://www.flangeandfittings.com. Their website reflects their commitment to Manufacturing and Supplying top-quality Industrial Pipe Flanges with a variety of materials.

AvaSingleton · 39 weeks and 4 days ago

Home renovation enthusiasts, don't miss www.quartzluxurywindows.com. Exceptional service and stunning designs await!

OliverReed · 38 weeks and 1 day ago

What do you think?

Any thoughts on this command? Does it work on your machine? Can you do the same thing with only 14 characters?

You must be signed in to comment.

What's this?

commandlinefu.com is the place to record those command-line gems that you return to again and again. That way others can gain from your CLI wisdom and you from theirs too. All commands can be commented on, discussed and voted up or down.

Share Your Commands

Similar Commands

OneLiner ICMP sniffer in Python

Get your public ip

socat TCP-LISTEN:5500 EXEC:'ssh user@remotehost "socat STDIO UNIX-CONNECT:/var/run/mysqld/mysqld.sock"'

retrieve the source address used to contact a given host

Stay in the loop…

Follow the Tweets.

Every new command is wrapped in a tweet and posted to Twitter. Following the stream is a great way of staying abreast of the latest commands. For the more discerning, there are Twitter accounts for commands that get a minimum of 3 and 10 votes - that way only the great commands get tweeted.

» http://twitter.com/commandlinefu
» http://twitter.com/commandlinefu3
» http://twitter.com/commandlinefu10

Subscribe to the feeds.

Use your favourite RSS aggregator to stay in touch with the latest commands. There are feeds mirroring the 3 Twitter streams as well as for virtually every other subset (users, tags, functions,…):

Subscribe to the feed for:

» all commands
» commands with 3 up-votes (commandlinefu3)
» commands with 10 up-votes (commandlinefu10)