Trying to install wordpress on Ubuntu

I was trying to install WordPress on ubuntu by following this

but stuck at step 4, whenever I run this

mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER -> ON wordpress.* -> TO wordpress@localhost -> IDENTIFIED BY 'password'; 

I get

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 4 

I know I'm doing something wrong just don't know where

please help thanks

Sreenshot of terminal

1 Answer

The IDENTIFIED BY {password} bit is unnecessary. If the MySQL user has not already been created, then:

CREATE USER 'wordpress'@'localhost' IDENTIFIED WITH mysql_native_password BY 'superSecretPassword!123'; 

Then you can assign permissions:

GRANT ALL ON `wordpress`.* TO 'wordpress'@'localhost';