MySql Connector?

Unity Engine
1

Hi there.

I’ve been looking around for information on getting connected to a MySql database, it seems people have come up with all sorts of solutions, which is great, but I could really do without complicating my life any more than really necessary.

Could someone please let me know, or point me towards the ‘up to date’ information for getting the MySql Connector up and running? I’ve been using MySql for decades so I’m ok with that side of things, but it appears Unity can be a bit of a squealy pig when it comes to connecting.

Why is it so difficult? I would have thought system.data/.net ADO would have been easy to get up and running, why does the compiler have such a hard time? Could it be made easier? It’s confusing working in c# and not being able to access some of the most basic parts of the OS.

Anyway, what’s the best way round to get this working?
Many thanks.

2

Hi @tclancey ,

Maybe this will help you on that matter: Accessing MySQL database using c# on unity? - Stack Overflow

It has a solution for connecting Unity with MySQL from just some months ago.

I hope this helps!

3

After many many installs of different connector versions I’ve finally stumbled on the right combination.

Don’t use the msi ‘all in’ installers, use the no install zip, .Net and Mono ZIP. Simply copy the mysql.data.dll into your asset structure. Now the current unity is running fine on .net 4.x versions 6 and 7 should ok and probably 8. There’s a table on the MySql site for cross reference.

But now I’ve found the right file and I’m connected without any errors I’m not messing with it until later!

1 Like