Search code examples
mysqldatabasepowershellconnector

Which driver should I install so that mysqlcommand can be run using powershell?

I installed the mysqlconnector [ODBC] 5.1.8 for running my mysqlcommand, but I got this error:

Cannot find type [MySql.Data.MySqlClient.MySqlConnection]: make sure the assembly containing this type is loaded

Which driver should I install from the mysql connectors site to run this command (or any MySql command) on powershell?

I have the latest version of MySql installed in my system and all projects run with MySql very well.

Solution

  • You should install the Connector/Net , it installs itself in the GAC, and is available like any other .Net assembly .

    Then you can do e.g.

    [void][System.Reflection.Assembly]::LoadWithPartialName("MySql.Data")
$connectionString = "server=myserver;uid=myuser;pwd=mypass;database=mydb;"
$connection = New-Object MySql.Data.MySqlClient.MySqlConnection
$connection.ConnectionString = $connectionString
$connection.Open()
$sql = "show tables"
$command = New-Object MySql.Data.MySqlClient.MySqlCommand($sql, $connection)
$dataAdapter = New-Object MySql.Data.MySqlClient.MySqlDataAdapter($command)
$table = New-Object System.Data.DataTable
$recordCount = $dataAdapter.Fill($table)
echo $table
echo $table | ogv