试图在Ubuntu上安装wordpress

Question

我试图在ubuntu上安装WordPress，方法是遵循这个https://ubuntu.com/tutorials/install-and-configure-wordpress#4-configure-database

但是停留在第4步，每当我运行这个

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

我得到了

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

我知道我做错了什么，只是不知道在哪里

请帮忙谢谢

终端镜头

Answer 1

IDENTIFIED BY {password}位是不必要的。如果尚未创建MySQL用户，则：

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

然后您可以分配权限：

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