Tag: Remote

Run a local script on remote machine with parameters

Posted on by admin

So you have a script on the local machine and you want to run it remotely and pass arguments to it : ssh user@remote ‘cat | bash /dev/stdin param1 param2 .. paramN’ < /usr/scripts/localscript.sh 😉 nJoy  

Allow remote SQL connection to Mysql from any host

Posted on by admin

Allowing the login of a user from any host in Mysql is simple: mysql> select host, user from mysql.user; +—————+——+ | host | user | +—————+——+ | 127.0.0.1 | root | | localhost | root | | minimal01.lan | root | +—————+——+ 3 rows in set (0.00 sec) mysql> update mysql.user set host=’%’ where host=’127.0.0.1′;…