• Resolved macedonmike

    (@macedonmike)


    I am following the Detailed Instructions at: https://codex.www.ads-software.com/Installing_WordPress#Detailed_Instructions

    and when I get to the section: Using the MySQL Client

    I keep receiving a syntax error when I enter :

    mysql> GRANT ALL PRIVILEGES ON databasename.* TO "wordpressusername"@"hostname"
        -> IDENTIFIED BY "password";

    I am entering the code exactly as it is above except for the databasename, username, and hostname variables. I then receive this error:

    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 ‘PRIVELEGES ON databasename.* TO “wordpressusername”@”hostname”
    IDENTIFIED BY “password”‘ at line 1

Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘MySQL syntax error during user creation’ is closed to new replies.