Okay, I'm not a hardcore linux user, just know enough to manage a box or two. I've got a database server running a database for a Moodle installation, and every so often the web server running the moodle program can't connect to the database server (2 separate boxes), this happened for the first time since I've taken over the management of the server today, but I know it's happened to them before and they just did a hard restart on the box since no one there can work linux. Anyway, I'm trying to figure out the issue with the database,but log files are no help bla bla bla..
So, what I need is the ability to allow someone at the company to run the serve mysql restart command from their windows machine. As it stands now, I have to VPN into the network then SSH into the linux box to restart the service, and if I'm not at my computer then it's a PITA to do it remotely. So.... I'm looking for a way to essentially create a batch file that will connect to the database server and run that restart command.
I don't even know where to begin, or what to search for, as the searches I've run all come up with running a windows batch from a linux machine, and I need the opposite direction.