YOU CAN USE ANY USERNAME NO NEED TO USE 'g8keeper'
PLEASE MAKE SURE TO CHANGE THE PASSWORD FROM g8k33p3r112 TO YOUR OWN CUSTOM/COMPLEX PASSWORD

1. For DB access from Localhost

CREATE USER 'g8keeper'@'localhost' IDENTIFIED BY 'g8k33p3r112';

grant select, process, execute on *.* to 'g8keeper'@'localhost' identified by 'g8k33p3r112';

flush privileges;
quit

2. For DB access from any location

CREATE USER 'g8keeper'@'%' IDENTIFIED BY 'g8k33p3r112';

grant select, process, execute on *.* to 'g8keeper'@'%' identified by 'g8k33p3r112';

flush privileges;
quit

3. For DB access from any specific IP (assuming ip is 192.168.1.21)

CREATE USER 'g8keeper'@'192.168.1.21' IDENTIFIED BY 'g8k33p3r112';

grant select, process, execute on *.* to 'g8keeper'@'192.168.1.21' identified by 'g8k33p3r112';

4. View Grants

show grants for 'g8keeper'@'localhost';

show grants for 'g8keeper'@'%';

flush privileges;
quit