Using Heidimysql over SSH tunnel

HeidiSQL LogoIf  like me your servers block mysql from outside connections, you will need to use ssh tunneling if you want to use a gui tool like Heidimysql to manager your Mysql dbs. I struggled to get this new feature working in Heidi until i stumbled on a post by Casey Mclaughlin that contains the missing step (saving server public key to your Win registry using Plink.exe).

So hopefully if anyone finds this post, this will help..here is the link.

http://www.caseymclaughlin.com/articles/ssh-tunnels-with-plink-and-heidisql

Searching folder of files for a string

Ill never remember this and its just come in very handy

grep -lr “string” path

-l – this makes it list the filenames where it finds the string
-r – this makes it recursively scan all sub folders

e.g.

grep -lr “/var/www/proj” ./*

This would scan for the string “var/www/prog” in all files/folders starting from the current working directory.

Love linux!

 

http://old.personalprojector.co.uk/catalog/admin/