Conectar PowerShell con MySQL (PowerShell, Bases de datos)

Pasos

1. Descargar e instalar MySQL Server

• https://dev.mysql.com/downloads/mysql/

2. Descargar e instalar MySQL Connector Net

• https://dev.mysql.com/downloads/connector/net/

3. Utilizar el conector desde PowerShell (la base de datos y las tablas tienen que existir para poder obtener datos al ejecutar una consulta)

[void][System.Reflection.Assembly]::LoadWithPartialName("MySql.Data")
$Connection = New-Object MySql.Data.MySqlClient.MySqlConnection
$ConnectionString = "server=" + "localhost" + ";port=3306;uid=" + "root" + ";pwd=" + ";database="+"estado"
$Connection.ConnectionString = $ConnectionString
$Connection.Open()

$Query='select PersonID,Estado from Persons'
$Command = New-Object MySql.Data.MySqlClient.MySqlCommand($Query, $Connection)
$DataAdapter = New-Object MySql.Data.MySqlClient.MySqlDataAdapter($Command)
$DataSet = New-Object System.Data.DataSet
$RecordCount = $dataAdapter.Fill($dataSet, "data")
$DataSet.Tables[0]
$Connection.Close()