1. For Localhost

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

grant SELECT, LOCK TABLES on database_name.* to 'g8keeperbkp'@'localhost' identified by 'g8k33p3r112';

show grants for 'g8keeperbkp'@'localhost';

flush privileges;
quit

2. For any location

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

grant SELECT, LOCK TABLES on database_name.* to 'g8keeperbkp'@'%' identified by 'g8k33p3r112';

show grants for 'g8keeperbkp'@'%';

flush privileges;
quit

3. For specific IP (assuming ip is 192.168.1.21)

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

grant SELECT, LOCK TABLES on database_name.* to 'g8keeperbkp'@'192.168.1.21' identified by 'g8k33p3r112';

show grants for 'g8keeperbkp'@'192.168.1.21';

flush privileges;
quit