MySql.Data 8.4.0
About
MySQL provides connectivity for client applications developed in .NET compatible programming languages with MySQL Connector/NET through a series of packages.
MySql.Data is the core package of Connector/NET. It is compatible with .NET Framework 4.6+ and .NET 6.0+ and provides classic MySQL protocol and MySQL X DevAPI capabilities.
More information at MySQL Connector/NET documentation.
How to use
MySql.Data.MySqlClient.MySqlConnection myConnection;
string myConnectionString;
//set the correct values for your server, user, password and database name
myConnectionString = "server=127.0.0.1;uid=root;pwd=12345;database=test";
try
{
myConnection = new MySql.Data.MySqlClient.MySqlConnection(myConnectionString);
//open a connection
myConnection.Open();
// create a MySQL command and set the SQL statement with parameters
MySqlCommand myCommand = new MySqlCommand();
myCommand.Connection = myConnection;
myCommand.CommandText = @"SELECT * FROM clients WHERE client_id = @clientId;";
myCommand.Parameters.AddWithValue("@clientId", clientId);
// execute the command and read the results
using var myReader = myCommand.ExecuteReader()
{
while (myReader.Read())
{
var id = myReader.GetInt32("client_id");
var name = myReader.GetString("client_name");
// ...
}
}
myConnection.Close();
}
catch (MySql.Data.MySqlClient.MySqlException ex)
{
MessageBox.Show(ex.Message);
}
Related Packages
- Entity Framework Core: MySql.EntityFrameworkCore
- Entity Framework: MySql.Data.EntityFramework
- Web: MySql.Web
- OpenTelemetry: MySql.Data.OpenTelemetry
Contributing
There are a few ways to contribute to the Connector/NET code. Please refer to the contributing guidelines for additional information.
Additional Resources
- MySQL
- MySQL Connector/NET GitHub
- MySQL Connector/NET API
- MySQL Connector/NET Discussion Forum
- MySQL Public Bug Tracker
#connectorschannel in MySQL Community Slack (Sign-up required when not using an Oracle account)- For more information about this and other MySQL products, please visit MySQL Contact & Questions.
Showing the top 20 packages that depend on MySql.Data.
| Packages | Downloads |
|---|---|
|
TestContainers
Package Description
|
2 |
|
TestContainers
Package Description
|
3 |
Review ReleaseNotes.txt for details.
.NET Framework 4.6.2
- BouncyCastle.Cryptography (>= 2.2.1)
- ZstdSharp.Port (>= 0.7.1)
- System.Threading.Tasks.Extensions (>= 4.5.4)
- System.Runtime.CompilerServices.Unsafe (>= 6.0.0)
- System.Diagnostics.DiagnosticSource (>= 7.0.2)
- System.Configuration.ConfigurationManager (>= 4.4.1)
- System.Buffers (>= 4.5.1)
- K4os.Compression.LZ4.Streams (>= 1.3.5)
- Google.Protobuf (>= 3.25.1)
.NET Standard 2.0
- System.Configuration.ConfigurationManager (>= 4.4.1)
- System.Buffers (>= 4.5.1)
- K4os.Compression.LZ4.Streams (>= 1.3.5)
- Google.Protobuf (>= 3.25.1)
- BouncyCastle.Cryptography (>= 2.2.1)
- System.Diagnostics.DiagnosticSource (>= 7.0.2)
- System.Runtime.CompilerServices.Unsafe (>= 6.0.0)
- System.Security.Permissions (>= 4.7.0)
- ZstdSharp.Port (>= 0.7.1)
- System.Threading.Tasks.Extensions (>= 4.5.4)
- System.Text.Json (>= 7.0.1)
- System.Text.Encoding.CodePages (>= 4.4.0)
- System.Runtime.Loader (>= 4.3.0)
.NET 8.0
- ZstdSharp.Port (>= 0.7.1)
- System.Threading.Tasks.Extensions (>= 4.5.4)
- System.Text.Json (>= 7.0.1)
- System.Text.Encoding.CodePages (>= 4.4.0)
- System.Security.Permissions (>= 4.7.0)
- System.Runtime.Loader (>= 4.3.0)
- System.Runtime.CompilerServices.Unsafe (>= 6.0.0)
- System.Diagnostics.DiagnosticSource (>= 7.0.2)
- System.Configuration.ConfigurationManager (>= 4.4.1)
- System.Buffers (>= 4.5.1)
- K4os.Compression.LZ4.Streams (>= 1.3.5)
- BouncyCastle.Cryptography (>= 2.2.1)
- Google.Protobuf (>= 3.25.1)
.NET 7.0
- ZstdSharp.Port (>= 0.7.1)
- System.Threading.Tasks.Extensions (>= 4.5.4)
- System.Text.Encoding.CodePages (>= 4.4.0)
- System.Text.Json (>= 7.0.1)
- System.Security.Permissions (>= 4.7.0)
- System.Runtime.Loader (>= 4.3.0)
- System.Runtime.CompilerServices.Unsafe (>= 6.0.0)
- System.Diagnostics.DiagnosticSource (>= 7.0.2)
- System.Buffers (>= 4.5.1)
- K4os.Compression.LZ4.Streams (>= 1.3.5)
- Google.Protobuf (>= 3.25.1)
- System.Configuration.ConfigurationManager (>= 4.4.1)
- BouncyCastle.Cryptography (>= 2.2.1)
.NET Standard 2.1
- ZstdSharp.Port (>= 0.7.1)
- System.Threading.Tasks.Extensions (>= 4.5.4)
- System.Text.Json (>= 7.0.1)
- System.Text.Encoding.CodePages (>= 4.4.0)
- System.Security.Permissions (>= 4.7.0)
- System.Runtime.Loader (>= 4.3.0)
- System.Runtime.CompilerServices.Unsafe (>= 6.0.0)
- System.Diagnostics.DiagnosticSource (>= 7.0.2)
- System.Configuration.ConfigurationManager (>= 4.4.1)
- System.Buffers (>= 4.5.1)
- K4os.Compression.LZ4.Streams (>= 1.3.5)
- Google.Protobuf (>= 3.25.1)
- BouncyCastle.Cryptography (>= 2.2.1)
.NET 6.0
- BouncyCastle.Cryptography (>= 2.2.1)
- Google.Protobuf (>= 3.25.1)
- K4os.Compression.LZ4.Streams (>= 1.3.5)
- System.Configuration.ConfigurationManager (>= 4.4.1)
- System.Buffers (>= 4.5.1)
- ZstdSharp.Port (>= 0.7.1)
- System.Runtime.CompilerServices.Unsafe (>= 6.0.0)
- System.Runtime.Loader (>= 4.3.0)
- System.Diagnostics.DiagnosticSource (>= 7.0.2)
- System.Text.Encoding.CodePages (>= 4.4.0)
- System.Text.Json (>= 7.0.1)
- System.Threading.Tasks.Extensions (>= 4.5.4)
- System.Security.Permissions (>= 4.7.0)
.NET Framework 4.8
- System.Threading.Tasks.Extensions (>= 4.5.4)
- System.Runtime.CompilerServices.Unsafe (>= 6.0.0)
- System.Diagnostics.DiagnosticSource (>= 7.0.2)
- System.Configuration.ConfigurationManager (>= 4.4.1)
- System.Buffers (>= 4.5.1)
- K4os.Compression.LZ4.Streams (>= 1.3.5)
- Google.Protobuf (>= 3.25.1)
- BouncyCastle.Cryptography (>= 2.2.1)
- ZstdSharp.Port (>= 0.7.1)
| Version | Downloads | Last updated |
|---|---|---|
| 9.2.0 | 0 | 01/21/2025 |
| 9.1.0 | 0 | 10/15/2024 |
| 9.0.0 | 0 | 07/01/2024 |
| 8.4.0 | 3 | 06/26/2024 |
| 8.3.0 | 2 | 06/29/2024 |
| 8.2.0 | 2 | 06/28/2024 |
| 8.1.0 | 2 | 06/28/2024 |
| 8.0.33 | 2 | 06/28/2024 |
| 8.0.32.1 | 2 | 06/29/2024 |
| 8.0.32 | 1 | 06/28/2024 |
| 8.0.31 | 1 | 06/28/2024 |
| 8.0.30 | 1 | 06/29/2024 |
| 8.0.29 | 1 | 06/28/2024 |
| 8.0.28 | 2 | 06/28/2024 |
| 8.0.27 | 1 | 06/28/2024 |
| 8.0.26 | 2 | 06/28/2024 |
| 8.0.25 | 2 | 06/28/2024 |
| 8.0.24 | 1 | 06/27/2024 |
| 8.0.23 | 2 | 06/28/2024 |
| 8.0.22 | 2 | 06/28/2024 |
| 8.0.21 | 1 | 06/28/2024 |
| 8.0.20 | 1 | 06/28/2024 |
| 8.0.19 | 1 | 06/28/2024 |
| 8.0.18 | 2 | 06/29/2024 |
| 8.0.17 | 1 | 06/28/2024 |
| 8.0.16 | 2 | 06/28/2024 |
| 8.0.15 | 2 | 06/27/2024 |
| 8.0.14 | 2 | 06/29/2024 |
| 8.0.13 | 2 | 06/28/2024 |
| 8.0.12 | 1 | 06/29/2024 |
| 8.0.11 | 1 | 06/28/2024 |
| 6.10.9 | 2 | 06/29/2024 |
| 6.10.7 | 1 | 06/28/2024 |
| 6.9.12 | 2 | 06/29/2024 |
| 6.8.8 | 2 | 06/28/2024 |
| 6.7.9 | 2 | 06/28/2024 |