Creating MySQL database
In order to create required MySQL database on your server, you first need to have mariadb-server installed. If you don't have it, please run the command below:
Please note that it is generally recommended to execute
apt-get updatebefore installing new packages on the machine, as else you might encounter some errors.
$ apt-get install mariadb-server -y
After successfully installing MariaDB server, you can now proceed with creating required databases. First of all, you need to login to the mysql terminal. Execute the command below in order to do so.
$ mysql -u root -p
After that, we need to create user. You can do that by executing the command below:
CREATE USER 'playerserversuser'@'127.0.0.1' IDENTIFIED BY 'somePassword';
After that, you need to create new database for PlayerServers:
CREATE DATABASE PlayerServers;
Next up, we need to give playerservers user permission to access the database. We can do that by executing the next two commands:
GRANT ALL PRIVILEGES ON PlayerServers.* TO 'playerserversuser'@'127.0.0.1';