Error in "GRANT ALL ON database.* TO command

Question

I am trying to run a script containing command GRANT ALL ON BIDB.* TO biouser@'localhost' IDENTIFIED by 'bio123!'; . But somehow i am getting an error saying biouser is not valid at this position and an identifier is expected. I have attached an image of the issue.

Answer 1

it was removed in mysql 8.0 see GRANT

Use instead

CREATE USER 'biouser'@'localhost' IDENTIFIED by 'bio123!';
GRANT ALL PRIVILEGES ON BIDB.* TO 'biouser'@'localhost';