Wordpress and MariaDB are on different hosts. I'm connected to MariaDB via it's CLI command interface. I am following the DigtalOcean guide.
Here are the DB and OS info:
- Ubuntu 20.04
Here is the command I'm using to create the user:
CREATE USER 'user_name_for_wordpress'@'188.8.131.52' IDENTIFIED WITH mysql_native_password BY 'PasswordAlphaNumeric';
And here is the error message:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'BY 'PasswordAlphaNumeric'' at line 1
- user_name_for_wordpress: Username with upper and lower case
- 184.108.40.206: WordPress server IP address
- PasswordAlphaNumeric: The password
What am I doing wrong?