MySQL PowerShell Extensions provides a set of Cmdlets to execute SQL Queries on a local or remote MySQL Server.
How to use it ?
After a successful installation, you should add the PowerShell Snapin :
Add-PSSnapin 3TSolutions.MySqlPSExtensions
Then to execute SQL Query on the remote use :
Invoke-MySqlCmd -InstanceName "<Server Name or IP Address>" -Port <TCP Port default 3306> -DatabaseName "< name of DB >" -Query "<SQL Query (Insert, Select..)>" -Username "<credential's username>" -Password "<credential's password>"
Exemple :
Invoke-MySqlCmd -InstanceName "192.168.1.5" -Port 3308 -DatabaseName "CompanyDB" -Query "Select * from Employees" -UserName "root" -Password "****"