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

Improve this question

1 Answer 1

Reset to default
0

You're missing the word ON.

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

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.