RoboTask forum

Is it possible to automate this with the program RoboTask? Specifically, to create a ssh connection to mysql socket and, if the connection drops, automatically re‑establish it.

See my acutally the CMD command: The CMD command establishes an SSH tunnel that forwards your local port 5001 to the MySQL socket file /var/lib/mysql/mysql.sock on the remote server 123.123.123.123. This allows you to connect locally to port 5001 and transparently access the MySQL database on the remote host, even though it normally only accepts local socket connections.
thx

It seems that you need to enter your password interactively.
You can automate this process using Console Application actions:

• Run your command line: Open Console Session
• Wait for necessary prompt: Wait for Text (or do simple Pause)
• Send the password to console: Write To Console Session

actions

If you don't need to use interactive actions you can use Run Program/Open Document or Run Console Application actions.
These actions only run the specified command line.