(%) 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';