How to grant all privileges to specific user to remote ip

Question

This command work

GRANT ALL ON hmremote.* TO 'uber'@'localhost';

but this don't

GRANT ALL ON hmremote.* TO 'uber'@'111.111.111.111';

ERROR 1410 (42000): You are not allowed to create a user with GRANT

Also tried with.

GRANT ALL ON hmremote.* TO 'uber'@'111.111.111.111' IDENTIFIED BY 'password';

What did I do wrong? Thanks in advance.

Answer 1

Try using CREATE USER uber@111.111.111.111 before you grant permissions.