【MySQL】grant all on でユーザーが作成できない

Copycopy code to clipboard
grant all on hoge.* to 'hoge'@'localhost' identified by 'password';

Copycopy code to clipboard
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'identified by 'password'' at line 1

Copycopy code to clipboard
create user 'hoge'@'localhost' identified by 'password';

Copycopy code to clipboard
grant all on hoge.* to hoge@localhost;

Copycopy code to clipboard
flush privileges;