Mysql

MySQL 創建數據庫 CentOS (6 - 64bit) 錯誤 1064 (42000)

  • October 28, 2013

每當我輸入:

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


它給了我一個錯誤:

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

你錯過了這個詞ON

GRANT ALL PRIVILEGES ON minecraft.* ....

引用自:https://serverfault.com/questions/549257