So I've been wanting to create a private ArmA 2 DayZ Epoch server for a bunch of my mates to play on, however I dont have a dedicated machine and want to run it on my PC. So I looked at the server download files on the GitHub page and followed the ReadMe, however I absolutely cannot figure out how to get the MySQL server and DB set up. I have downloaded MySQL Server on my PC and created the admin role, root passwords and ran it as a windows service. I now have no clue how to create the database and am wondering if anyone can help me set this up or let me know if I've done anything wrong. 

I can add on Steam or Discord if need be for convenience.

Every time i try and join my server its stuck at waiting for authorization and the logs say "failed to get id". Any idea whats going on here. I am very new to server hosting so please explain in easy terms. :)

Some time ago I started a youtube channel doing DayZ Epoch tutorials. Surprisingly, my DayZ Epoch 1.0.6.1 server install video has amassed over 2500 views (and people say this game is dead).
Here are some updated videos for 1.0.6.2. There are other videos on my channel that are still relevant.
How to Install a DayZ Epoch 1.0.6.2 Server
Things you will need to download:
PBO Manager
MySQL Community Server 5.7.22
HeidiSQL
Notepad++
Notepad++ SQF Highlighter (optional, but highly recommended)
7-Zip
 
How to Upgrade Your DayZ Epoch 1.0.6.2 Server to an Overpoch Server
Things you will need to download:
Overwatch Server Key
Overwatch mission.sqm (to copy and paste from)
My Overpoch Loot Tables
My Non-ZSC Overpoch Trader Files
Midget Porn (Just kidding)
 
How to Install Epoch Admin Tools
Do not install these with infistar.
 
How to Install Wicked AI for DayZ Epoch and Overpoch
 
How to install infistar admin tools/antihack and infistar's free BRC rcon tool
Fix for the unfortunate error in infistar v1448
 
 
How to make Battleye filter exceptions for Infistar and other mods
Downloads
Eraser1's scripts.txt Exception Generator
Ebay's Guide to Battleye Filters
 
How to Install Ebay's Testkit
Download
 
Battleye Filter Tutorial using Ebay's Testkit and infistar's BRC rcon tool
 
Server Install: Troubleshooting "session lost" and "wait for host" type issues.
 
How to install BattlEye Extended Controls for automatic restarts
 
 
 
I am planning on doing more of these when I get time.
 
 
 
 

I have been finding that some people on my server has been losing base walls and floors even though DZE_godmodebase = true; , it has no effect on anything built inside the plot radius. So i have come to the conclusion that base items might receive damage on age and this ultimately being removed by server cleanup script. So my question is if I drop this event below will that stop me and others from losing base walls and floor? Or at the minimum update it without any cinder wall items?
like this  and set damage to 0.001:
 

I have a few noobly questions:
What is the difference between a dedicated server and a not dedicated server? What would i need to set up a server that would still run events even without anyone logged on? What maps can I play Arma 3 Epoch on? I had an Arma 2 Epoch server on my machine some years ago and I wish to do the same with Arma 3. I have looked at a few guides, including the one in the Epoch Wiki (wasn't able to get steamcmd working), and they all seem to advocate different methods. Any advice and points in the right directions are appreciated.