mysql loaddata权限_mysql_load_data及权限管理

————————————————————————————————————————

添加权限：

The only priv_type values you can specify for a table are SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, GRANT OPTION, INDEX, and ALTER.

"FILE" is only assigned as a GLOBAL permission

" The EXECUTION, FILE, PROCESS, RELOAD, REPLICATION CLIENT, REPLICATION SLAVE, SHOW DATABASES, SHUTDOWN, and SUPER privileges are administrative privileges that can only be granted globally (using ON *.* syntax)."

原来FILE这种权限属于管理的权限，要赋予用户时，必须要用*.*。(不可针对库和表)

[email protected]:mysql.sock[(none)] 15:31:33>GRANT FILE ON *.* TO [email protected];

Query OK, 0 rows affected (0.00 sec)

问题解决。

————————————————————————————————————————

今天在使用mysql的LOAD DATA LOCAL INFILE 语法插入文件的时候，提示：ERROR 1148 (42000): The used command is not allowed with this MySQL version

原因是；如果编译安装mysql时没有指定–enab