Create MySQL User
We will need to create some users on the database server for accessing the game server. These users will be used in the plugin to gain access to the users. Without this the users will not be able to log in or be created.
Following with the other guides, we will connect to the server using Putty and then execute some commands.
|sudo mysql -u root -p|
Note: I am creating the users loginserver and gameserver here for this purpose. You can use any user account and password you like here.
If your password is not secure enough, you will receive an error message to this effect as seen below. You will receive a message of Query OK if the process completes as expected.
#Create the users on the MySQL server
CREATE USER ‘websiteuser’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘INSERTYOURPASSWORDHERE’;
#Grant all permission to the master database to the loginserver account.
GRANT ALL ON master.* TO ‘loginserver’@’localhost’;
#Grant all permission to the all other databases to the webserver account.
GRANT SELECT ,INSERT ,UPDATE,DELETE ON master.* TO ‘websiteuser’@’localhost’;
GRANT SELECT ,INSERT ,UPDATE,DELETE ON admin.* TO ‘websiteuser’@’localhost’;
GRANT SELECT ON atavism.* TO ‘websiteuser’@’localhost’;
GRANT SELECT ON world_content.* TO ‘websiteuser’@’localhost’;