You are not allowed to create a user with GRANT;

mysql报上面的错，需要先修改user表的host再改权限，改权限需要执行两次。

update user set host='%' where user='test';
Grant all privileges on test.* to 'test'@'%';