ERROR 1221 (HY000): Incorrect usage of DB GRANT and GLOBAL PRIVILEGES

<<Back to MySQL & MariaDB How To Page

ERROR 1221 (HY000): Incorrect usage of DB GRANT and GLOBAL PRIVILEGES

MariaDB [(none)]> grant file on test.* to 'test'@'localhost';
ERROR 1221 (HY000): Incorrect usage of DB GRANT and GLOBAL PRIVILEGES

Cause:
File privilege is a global privilege and you can not grant it at database/schema level. Modify the command as shown below and rerun.

Solution:
 MariaDB [(none)]> grant file on *.* to 'test'@'localhost';
Query OK, 0 rows affected (0.01 sec)