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
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′;
mysql> select host, user from mysql.user;
+—————+——+
| host | user |
+—————+——+
| % | root |
| localhost | root |
| minimal01.lan | root |
+—————+——+
3 rows in set (0.00 sec)
Voila`
