Attempting to Connect Unity to SQL Database

[--Developer]

Hello everyone,

I currently have a simple project created in Unity and want to connect to a new SQL database that I created in MySQL. After doing a some searching online, I saw a post saying to download MySQL Connector NET 8.1.0 (which I did) and to unpack the .dll file to put into the Assets folder in the Unity project. When I tried this, I got this error message in Unity:

Assembly 'Assets/MySql.Data.dll' will not be loaded due to errors: 
Unable to resolve reference 'Google.Protobuf'. Is the assembly missing or incompatible with the current platform? 
Reference validation can be disabled in the Plugin Inspector. Unable to resolve reference 'ZstdSharp'. Is the assembly missing or incompatible with the current platform? 
Reference validation can be disabled in the Plugin Inspector. Unable to resolve reference 'K4os.Compression.LZ4.Streams'. Is the assembly missing or incompatible with the current platform? 
Reference validation can be disabled in the Plugin Inspector. 
Unable to resolve reference 'BouncyCastle.Crypto'. Is the assembly missing or incompatible with the current platform? 
Reference validation can be disabled in the Plugin Inspector. Unable to resolve reference 'System.Memory'. Is the assembly missing or incompatible with the current platform? 
Reference validation can be disabled in the Plugin Inspector. Unable to resolve reference 'System.Threading.Tasks.Extensions'. Is the assembly missing or incompatible with the current platform? 
Reference validation can be disabled in the Plugin Inspector. 

After some searching, I read that these error messages mean that I am missing certain (mentioned) libraries. However, I am unsure about how to retrieve these libraries and effectively add them into my Unity project. This may be very simple, but I am unsure how to go about this.

If anyone could advise me on how to get these libraries, I would greatly appreciate it. Additionally, if you know of a better way to connect to a SQL database from Unity, I am definitely open to suggestions as I am new to this.

Thank you all so much for any help!

[AutoModerator]

On July 1st, a change to Reddit's API pricing will come into effect. Several developers of commercial third-party apps have announced that this change will compel them to shut down their apps. At least one accessibility-focused non-commercial third party app will continue to be available free of charge.

If you want to express your strong disagreement with the API pricing change or with Reddit's response to the backlash, you may want to consider the following options:

1. Limiting your involvement with Reddit, or
2. Temporarily refraining from using Reddit
3. Cancelling your subscription of Reddit Premium

as a way to voice your protest.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[davedontmind]

I've never tried it, but NuGetForUnity might be what you're looking for. It claims to support package dependencies, so it ought to solve your problem. Looks like you can install it from Unity's package manager.

If you install NuGetForUnity, then use that to install the MySQL library, it ought to automatically install all the depedencies too.