WordPress.org

1. macedonmike
   Member
   Posted 3 years ago #

   I am following the Detailed Instructions at: http://codex.wordpress.org/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

2. NC@WP
   Member
   Posted 3 years ago #

   Replace the double quotes with single quotes:

   GRANT ALL PRIVILEGES ON databasename.*
     TO 'wordpressusername'@'hostname'
     IDENTIFIED BY 'password';

3. macedonmike
   Member
   Posted 3 years ago #

   All better thank you

Topic Closed

This topic has been closed to new replies.