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

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';

2

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy