MySQL RENAME Table 需要開哪些權限

MySQL user 想要 RENAME Table 需要開哪些權限呢？

MySQL RENAME Table 需要開哪些權限

• 原始 Table 需要有 ALTER 和 DROP 的權限
• 新的 Table 需要有 CREATE 和 INSERT 的權限

語法如下：

• GRANT INSERT,DROP,CREATE,ALTER ON *.* TO 'user'@'%' IDENTIFIED BY 'password';
• GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER ON *.* TO 'user'@'%' IDENTIFIED BY 'password'; #
  新刪改查一般權限都加進去
• FLUSH PRIVILEGES;

相關網頁

• MySQL 5.6 Reference Manual :: 13.1.32 RENAME TABLE Syntax
  • You must also have the ALTER and DROP privileges on the original table, and the CREATE and INSERT privileges on the new table.
• MySQL 5.6 Reference Manual :: 6.2.1 Privileges Provided by MySQL