Which privilege is required to truncate data in phpmyadmin?

Question

I want my php file user to be able to truncate. In phpmyadmin there is an option to set privalage to DROP, but I can't see one for TRUNCATE. Any ideas?

Answer 1

It requires the DROP privilege as of MySQL 5.1.16. (Before 5.1.16, it requires the DELETE privilege).

Answer 2

truncate It requires the DROP privilege as of MySQL 5.1.16. (Before 5.1.16, it requires the DELETE privilege).

http://dev.mysql.com/doc/refman/5.1/en/truncate-table.html