I face some times problem Mysql database and it stopped. In that case i ask plant engineers to come and restart mysql service. In that case if i want to restart mysql service from remote, is it possible.
I have given the remote access for Mysql and 3306 port is release from the firewall
Could somebody help me to restart Mysql Service from remote
If MySQL is running on a Windows Server 2008 box (or maybe even Windows 7), you might be able to use Windows PowerShell to restart the MySQL service remotely. The PowerShell command looks like this:
Invoke-Command {Restart-Service} “mysql” -passthru -ComputerName “mycomputername”
From what I read, it does require the server that runs the MySQL service to be configured to receive PowerShell requests like this.