0

When ever I type in :

GRANT ALL PRIVILEGES minecraft.* TO 'minecraftu'@'%' IDENTIFIED BY '********';


It gives me an error of :

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 'minecraft.* TO 'minecraftu'@'%' IDENTIFIED BY '********'' at line 1

1 Answer 1

0

You're missing the word ON.

GRANT ALL PRIVILEGES ON minecraft.* ....
3
  • GRANT ALL PRIVILEGES ON minecraft.* TO 'minecraftu'@'%' IDENTIFIED BY '*********'; Still didn't work. Oct 28, 2013 at 21:48
  • So what was the error, then? Oct 28, 2013 at 21:52
  • Sorry nevermind, I just had to restart PUTTY. Thank you for your help. Oct 28, 2013 at 21:53

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .