Connect Unity and Mysql database?

Unity Engine
1

Hello dear friends,
I have a problem I want to know how can I put a database of unity, to save the account information of the players who sign up … I had thought about mysql, but how do I make the connection between the two?
regards Wil

2

You should get the appropriate connector from here:
http://www.mysql.de/products/connector/

Then you should work through tutorials:
http://dev.mysql.com/doc/refman/5.1/en/connector-net-tutorials.html

3

You should also have the server side code using some of the technologies available (PHP, ASP.NET, Java etc.).

This guy has interesting video tutorials on connecting Unity with the server.

4

Took me a while to get this to work but finally got it.

  1. Download the net mysql.data.dll from here http://dev.mysql.com/downloads/connector/net/#downloads .
  2. Open V2 folder and extract all the mysql.data files into the unity project folder “Plugins” . If you dont have a plugins folder make a new one.
  3. Then use this document as a guide to connect to the mysql database etc . http://www.mono-project.com/MySQL and http://dev.mysql.com/doc/refman/5.7/en/connector-net-tutorials-intro.html

GL!

5

Definitely do this for anything but the most rudimentary prototyping or tinkering. There are pretty major security concerns related to having your client machines connect directly to your database, so it’s best practice to have a server side script or whatever doing some gatekeeping and sanity checking for you.