Confirming MySQL Alive

Hi,


Getting some data from an older MySQL box. I had an event recently where the MySQL box went off-line for maintenance without a prior announcement of service disruption.

I decided to add a line on my local version of MySQL as I considered how to handle this condition going forward.

system("sudo systemctl status mysql", input = rstudioapi::askForPassword("sudo password"))

system("sudo systemctl status mysql",input=readline("Enter Password: "))


Both fail for the same reason, saying I need a terminal.

system("sudo systemctl status mysql", input = rstudioapi::askForPassword("sudo password"))

sudo: a terminal is required to read the password; either use the -S option to read from standard input or configure an askpass helper
sudo: a password is required

system("sudo systemctl status mysql",input=readline("Enter Password: "))

Enter Password: ***REDACTED***
sudo: a terminal is required to read the password; either use the -S option to read from standard input or configure an askpass helper
sudo: a password is required

I can run the code segments for things like ls and pwd. So, there is something unique about systemctl and R that is beyond my understanding today.

QUESTIONS
What is so special about systemctl and R in a system syntax statement?

What are some of the best practices to confirm a box I am hitting for data with R , either local or across the network, has MySQL up and running?


Thanks,