Setting up a backend service for your Unity3D Game using LEMP (Linux, Nginx, MySQL, PHP)
2EDIT: Apologies for low voice-audio, please increase/boost your speaker my fan was making ramming sounds, trying to suppress which lowered mic input too much.
Alternatively please use the blog post from below link instead
Leave your questions or doubts in comments or tweet me directly for a quicker reply:
https://twitter.com/GamerzDan
###########
Blog link for quicker reading and boilerplate code examples
https://gamerzdan.com/setting-up-a-server-backend-for-your-unity3d-game-using-lemp-linux-nginx-mysql-php/
###########
This is a in-depth tutorial/guide video with detailed explanation on setting up your own Game Backend Service server using LEMP components (Linux, Nginx, MySQL, PHP) along with PHPMYADMIN to manage your game's online database.
This video uses Scaleway Elements for its cloud server service, only because its one of the cheapest and most value for money solution and something we also personally use, not affiliated with them in any way.
Reference Links:
-Turn-Based RPG Template on Unity Assetstore:
https://assetstore.unity.com/packages/templates/systems/turnbase-rpg-template-107578
-PHP Webservice for the above template:
https://github.com/insthync/rpg-php-service
-Puttygen (to generate SSH keys):
https://www.puttygen.com/
-MobaXTerm (SSH Client, to connect to your server):
https://mobaxterm.mobatek.net/
-HeidiSQL (Desktop Client to manage your SQL database, preferred over PHPMYADMIN):
https://www.heidisql.com/
Segments Covered:
00:00 Introduction
02:30 LEMP Stack
05:00 Create and Setup our Linux Cloud Server
19:00 Setup Nginx Webserver and PHP
30:00 Setup MySQL Database Server
33:00 Create our Database
43:00 Setup PHPMYADMIN Database Manager
#unity3d #multiplayer #gamedev #turn-based #turnbased #rpg #onlinegamedev #unity3dcloud #linux #lemp #mysql #phpmyadmin #lemp #webserver #halloweengame #santagame #christmasgame #hell-o-ween #helloweengame