MySQL Creating a Database CentOS (6 – 64bit) Error 1064 (42000)

user2833135 asked:

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

My answer:


You’re missing the word ON.

GRANT ALL PRIVILEGES ON minecraft.* ....

View the full question and answer on Server Fault.

Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 3.0 Unported License.