The error messages tell you exactly what’s wrong. There is a required reference that you evidently can’t use inside of Unity. Here are some things you should probably be aware of:
MySQL.Data doesn’t even run in a medium trust web environment so chances are it’s not going to be very compatible across platform in Unity.
System.Data is not supported in Unity so you may run into issues.
If you’re planning on selling your game, be very careful. You will be required to purchase a license to redistribute the MySQL.Data assemblies in a commercial product so it’s not really suitable for use in an indie game.
Consider some alternatives. Host your database elsewhere and use web services to send / receive data to and from your database or look at some other solutions. Most of your users aren’t going to probably have MySQL installed anyway. If this is something you’re running as a server (like a headless instance), then use services to communicate with a local website for data storage and retrieval. Otherwise, don’t use Unity for your server.
ahahaha okay okay. For answers and interest,especially for the patience, thank you.
Apparently,
“SQL” is the best to use. Another idea does not come to mind for online access and membership.
That is, “MySQL” is creating the problem. “SQL” I’ll try. Hope you are the solved. I do not know any other solution.
Not SQL, SqlLite. If you try to use SQL you’re going to run into the same problems because of the missing System.Data references. And you’re not going to be able to use the built in Membership and Role providers, you’re going to need to create your own but that will be more flexible anyway.