Using PowerShell Core to Query MySQL

preview_player
Показать описание
This video shows how to connect to MySQL server using PowerShell CORE on a Debian 9 Linux computer. You need to load a few modules and move some files.

PowerShell Core Download

Mono-Project Download

MySQL Dot NET - Select the Mono Install

Code repository

How to support my channel
1 - Like videos
2 - Subscribe to my channel
  1. Tom's Tech Show!
  2. PowerShell Core
  3. MySQL
  4. Linux
  5. Mono Project
Рекомендации по теме
Using PowerShell Core 0:13:11

Using PowerShell Core to Query MySQL

How To Query 0:04:41

How To Query And Parse A REST API With PowerShell

Query Database using 0:07:00

Query Database using powershell

Powershell SQL Connection 0:04:58

Powershell SQL Connection | Execute Queries

Intro to PowerShell 0:11:10

Intro to PowerShell Core - params, switches, pipelines, select, where

Using PowerShell Core 0:11:27

Using PowerShell Core in .NET Core 2.0 Console Application

Windows PowerShell vs 0:11:19

Windows PowerShell vs PowerShell Core - What Is It?

API queries with 0:08:34

API queries with Powershell - Movie Api

REXX vs Other 0:02:45

REXX vs Other Scripting Languages | Comparing REXX, Python, Bash & PowerShell | Rexx Tutorial

Querying the Graph 0:15:38

Querying the Graph API with Powershell and Jupyter Notebooks

SQL Database Queries 0:11:02

SQL Database Queries using Powershell

How To Install 0:03:20

How To Install PowerShell Core On Windows

How To Check 0:03:20

How To Check .NET Version Using PowerShell On Windows 10 #shorts #windows10 #netframework #net

PowerShell Core Community 0:56:58

PowerShell Core Community Call - September 20, 2018

How To Execute 0:05:01

How To Execute a SQL Script from Powershell

Building a GUI 0:55:37

Building a GUI based PowerShell script to query a remote computer

PDQ Live! : 0:33:01

PDQ Live! : How Do I Connect PowerShell To A Database?

🌐1:1 Remoting - 0:01:00

🌐1:1 Remoting - PowerShell Series [Part 11]🌐

how to change 0:01:00

how to change a powershell colour in few minutes

NET Framework Version 0:05:39

NET Framework Version Check with Powershell

how to open 0:00:33

how to open task manager with powershell

Sitecore PowerShell Extensions 0:02:08

Sitecore PowerShell Extensions - Measure Command with Fast Query

PowerShell Core Recipes: 0:02:52

PowerShell Core Recipes: Creating Registry Keys and Values | packtpub.com

PowerShell Core Recipes: 0:03:51

PowerShell Core Recipes: The Course Overview | packtpub.com

Комментарии
Автор

Thank you so much I have been banging my head against a wall trying to get the MySQL connector working in dotnet core and it was so simple thanks to your video.

Pcketfullfsunshine
Автор

LoL, Lovevd your comment at 7:55 about the naming of the command

cemmetje
Автор

Just wanted to say thanks for this, been trying to get this working since Powershell Core was released! Google has failed me also.. until now.. now google brings me to your video!

chrisbolton
Автор

Thanks so much for this! It's helped me tremendously in my project.

It works great in ubuntu 18.04. What I noticed through is if I try the same process with powershell core running in aws lambda I get the following error:

{
"errorType": "FileNotFoundException",
"errorMessage": "Could not load file or assembly 'System.Drawing.Common, Version=4.0.2.2, Culture=neutral, The system cannot find the file specified.\n",
"stackTrace": [
"at inputStream, ILambdaContext context)",
"at lambda_method(Closure, Stream, Stream, LambdaContextInternal )"
]
}

I found a system.drawing.common dll in the sql connector download. But even if I try to add-type it like the mysql.data.dll file it states it cannot be found. Any suggestions on how to troubleshoot it further?

runtomrun