Here is a full guide, courtesy of WETBATMAN (They helped walk me through the full process of installing MySQL).
Go to this website and download the larger of the two MySQL msi installer options.
https://dev.mysql.com/downloads/windows/installer/8.0.html
Windows (x86, 32-bit), MSI Installer
(I had issues with the online version, the smaller one, so I recommend the offline version, the larger one)
Run the msi installer.
Choose the "Custom" option.
Under what to install choose these three options:
-MySQL Server 8.0.16 - x64
-MySQL Workbench 8.0.16 - x64
-Connector/C++ 8.0.16 - x64
Once these finish installing it will have you configure your options.
First option chooses how much RAM MySQL will use. I went with medium usage, though I feel you may get away with low easily enough.
Then set up your connection port. Remember this number as you will need it to connect to the MySQL database.
Next is the Authentification Type, choose legacy.
Then choose the main password for connecting to your MySQL. Make sure to save this too.
For Windows service just leave it as default.
Now it should apply all of your settings and finish up.
Once it does this you should have the MySQL Workbench pop up for you.
Click the "Local Instance" and open it up.
Add and name a Schema to it, remember this name (has to be lower case).
That should be it. Add all the relevant info to your Shop API config file at the top and run the server, making sure your MySQL database is online. The database will store player points and player kit amounts. If you need to separate points/kit amount for any reason, say between PvE and PvP servers, then just create and name a different Schema and link the relevant Shop API config to that one instead by using that Schema's name.
Example Shop API config:
"Mysql":{
"UseMysql":true,
"MysqlHost":"localhost",
"MysqlUser":"root",
"MysqlPass":"<my root password>",
"MysqlDB":"<schema name>"
},
Again, all thanks to WETBATMAN for helping me through this. Just wanted to outline the steps I took in case anyone else needs them. Feel free to ask for clarification and I will adjust the guide to include it.
Go to this website and download the larger of the two MySQL msi installer options.
https://dev.mysql.com/downloads/windows/installer/8.0.html
Windows (x86, 32-bit), MSI Installer
(I had issues with the online version, the smaller one, so I recommend the offline version, the larger one)
Run the msi installer.
Choose the "Custom" option.
Under what to install choose these three options:
-MySQL Server 8.0.16 - x64
-MySQL Workbench 8.0.16 - x64
-Connector/C++ 8.0.16 - x64
Once these finish installing it will have you configure your options.
First option chooses how much RAM MySQL will use. I went with medium usage, though I feel you may get away with low easily enough.
Then set up your connection port. Remember this number as you will need it to connect to the MySQL database.
Next is the Authentification Type, choose legacy.
Then choose the main password for connecting to your MySQL. Make sure to save this too.
For Windows service just leave it as default.
Now it should apply all of your settings and finish up.
Once it does this you should have the MySQL Workbench pop up for you.
Click the "Local Instance" and open it up.
Add and name a Schema to it, remember this name (has to be lower case).
That should be it. Add all the relevant info to your Shop API config file at the top and run the server, making sure your MySQL database is online. The database will store player points and player kit amounts. If you need to separate points/kit amount for any reason, say between PvE and PvP servers, then just create and name a different Schema and link the relevant Shop API config to that one instead by using that Schema's name.
Example Shop API config:
"Mysql":{
"UseMysql":true,
"MysqlHost":"localhost",
"MysqlUser":"root",
"MysqlPass":"<my root password>",
"MysqlDB":"<schema name>"
},
Again, all thanks to WETBATMAN for helping me through this. Just wanted to outline the steps I took in case anyone else needs them. Feel free to ask for clarification and I will adjust the guide to include it.
Last edited: