MySQL 8 - You are not allowed to create a user with GRANT

Ошибка при создании пользователя с правами GRANT:

mysql> GRANT SELECT ON user.* TO 'user'@'localhost';
ERROR 1410 (42000): You are not allowed to create a user with GRANT

решается на mysql 8 версии командами:

mysql> CREATE USER 'user'@'%' IDENTIFIED BY 'PASS_HERE';
mysql> GRANT ALL PRIVILEGES ON user.* TO 'user'@'%' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;