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.

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’;