Python
apt install python3-mysql.connector
import mysql.connector mydb = mysql.connector.connect( host ="localhost", user ="juzer", password="admin123", database="probnabaza" ) mycursor = mydb.cursor() sql = "SELECT * FROM probnatablica " mycursor.execute(sql) myresult = mycursor.fetchall() for x in myresult: print (x)
Powershell
http://dev.mysql.com/downloads/connector/net/
Add-Type –Path 'C:\Program Files (x86)\MySQL\MySQL Connector Net 8.0.27\Assemblies\net5.0\MySql.Data.dll'
$Connection = [MySql.Data.MySqlClient.MySqlConnection]@{ConnectionString="server=localhost;uid=juzer;pwd=admin123;database=probnabaza"}
$Connection.Open()
$sql = New-Object MySql.Data.MySqlClient.MySqlCommand
$MYSQLDataAdapter = New-Object MySql.Data.MySqlClient.MySqlDataAdapter
$MYSQLDataSet = New-Object System.Data.DataSet
$sql.Connection = $Connection
$sql.CommandText = "SELECT * FROM probnatablica"
$MYSQLDataAdapter.SelectCommand=$sql
$MYSQLDataAdapter.Fill($MYSQLDataSet, "Podatki") | Out-Null
# Write-Host $MYSQLDataSet.tables[0].errortxt
$global:Tablica = Foreach ($DataSet in $MYSQLDataSet.tables[0])
{
Write-Host "ID:" $DataSet.id "... Naziv:" $DataSet.naziv "... Opis:" $DataSet.opis
}
$Connection.Close()

