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 "****"

Last edited Nov 25, 2012 at 11:14 PM by elyes85, version 2

Comments

No comments yet.