Simple syntax question for MariaDB

Support Software & Applications
1

Hi

I have a simple syntax question for MariaDB. I am doing a Wordpress tutorial, and I cannot complete the configuration for MariaDB. When I try to insert a row:

GRANT ALL PRIVILEGES ON mywebsite.* TO “wp-user”@”localhost“ IDENTIFIED BY “your_password”;

I get the following 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 ‘-user”@”localhost“ IDENTIFIED BY “your_password”’ at line 1

Can someone please tell me where my syntax error is?

2

Quotes are important. You should use single quotes ' instead of double “

GRANT ALL PRIVILEGES ON mywebsite.* TO 'wp-user'@'localhost' IDENTIFIED BY 'your_password'
2 Likes
3

Great. Thank you.

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.