[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]