Unity & MySQL Databases, Part 1: Setting Up

Building our first database and setting up the scenes of our Unity project. We'll go over creating a local server environment where we can store our database and test our PHP scripts.

Support Board to Bits on Patreon:

[ewwitsantonio]

THANK YOU! I've felt pretty overwhelmed with this topic, but you're teaching method is very comfortable. Great stuff.

[nickabelson]

only getting started with these tutorials but i love how clear they are; i know what I am doing for the next week or two! thank you

[muzboz]

REALLY EXCELLENT SERIES, thank you so much! (Just finished it, but came back to comment here for other viewers deciding on a good set of tutorials).

I went through another YouTube series before this one, which covered MYSQL & Unity well, but didn't cover integrating it with the Unity UI, and also didn't cover using a Salt and Hash password for proper basic security, so I preferred this one overall, for sure. This one covered everything wonderfully, all in one place.

For anyone looking to create a solid User Registration & Login system (including basic security steps!) for Unity and MySQL, I highly recommend this series!

The creator also explains all concepts and various extra info along the way in a great manner.

[adarshkaran]

Thanks a lot ...it worked perfectly fine after correcting all the errors...really appreciate your efforts!!

[fernandomartinsr.]

So, can iyou help me? I already did a project with mysql, and it was working, but when i try to compile, and run the game compiled, it stop to work.

[relativityofspace]

Thanks for the great tutorial! Everything works good!... I'm now trying to connect to an online database, I've changed the host, name, password and datatabase name but the connection fail. Shall I prepare the database to recive PHP data? Is there something I'm missing? Thanks again. Take care.

[walney]

estou com a versão mais nova 2019, como faço para conectar a Unity3D com minha base de dados MySQL XAMP, poderia explicar, desde já agradeço.

[goldeena]

Thank you for the excellent video, very helpful!

[thboy]

Very good ... one question, and the same result if you use Xampp?

[louismastbooms]

So if I finish my project and post it only will it work because MAMP and phpmyadmin is local

[manikandankasi]

this video is excellent thanks but is it possible to add a new table and make more panel after registring student just with username and student

[moosegoose]

Hey do u have tutorial on ssl pinning or crypto?

[Sillymonkeies]

Hey I understand we're using MAMP, but how do I host the server online, with the php files so everyone around the world can use my SQL database?

[gobla]

does this tutorial steps working well also for Android or IOS platform ! ?

[TheSpacecraftX]

Had to learn SQL for uni but I've been wanting to do something practical with it for some time. This'll be a good chance to get to know PHP too hopefully.
I'm a bit wary of making user IDs auto-increment though, isn't that a potential security issue if they're sequential?

[grandmasterskitz]

Hey loved the entire series!
I ran into 1 problem upon download phpadmin wouldn't open: Access Denied..

The fix to that was simple. Shut down the server, check your ports #80 & #3306 are not being used by other programs. If they are you can select "use anyway" since you're just testing anyway. However, you probably wouldn't want other traffic slipping in through your database port especially if you're hosting on your own machine.

Anyway, hope that helps someone.

[natsunwtk]

are there any update? is these methods still working one of the best?

[PoppsMadeThis]

Would I need a database to verify if a players does indeed own a cosmetic item from game. Like say if players want to use cross platform for like their phone to pc and back and forth, and if I do how would it be done.

Hello, thanks for your tutorials. Could you make a tutorial on how to keep the game online accessing to the webserver and retrieving information from it? I only find tutorials explaining everything working in localhost. Although this is useful to test things, I presume most of people don´t have intenttion to run their games on their own computers.

[arjunmehta]

Does this work on Android/iOS platforms too?