powershell 链接 mysql

[void][System.Reflection.Assembly]::LoadWithPartialName("MySql.Data")

$connectionStr = "Server=localhost;Uid=root;Pwd=123456;database=dbname;"

$querysql = "select * from tablename ;"

$connection = New-Object MySql.Data.MySqlClient.MySqlConnection

$connection.ConnectionString = $connectionStr

$connection.Open()

$command = New-Object MySql.Data.MySqlClient.MySqlCommand($querysql, $connection)

$dataAdapter = New-Object MySql.Data.MySqlClient.MySqlDataAdapter($command)

$dataSet = New-Object System.Data.DataSet

$recordCount = $dataAdapter.Fill($dataSet)

$dataSet.Tables[0]