(%) indicates connections which use the local socket;

mysql> grant all on DB_NAME.* to 'backoffice_user'@'%';

“localhost” indicates connections which originate on the local system but use the loopback network interface to connect;

mysql> grant all on DB_NAME.* to 'backoffice_user'@'localhost';

“SERVER_NAME_or_IP_ADDRESS”, refers to connections which originate elsewhere on the network.

mysql> grant all on DB_NAME.* to 'USER_NAME'@'SERVER_NAME_or_IP_ADDRESS';

You can also

"identified by password 'password-goes-here'"

on the end of the command.

grant SELECT, INSERT, UPDATE, DELETE, CREATE ON DB_NAME.* TO [email protected]'LOCALHOST' IDENTIFIED BY 'PASSWORD_GOES_HERE';