1.先检查参数local_infile
mysql> show variables like 'local_infile';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| local_infile | ON |
+---------------+-------+
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| local_infile | ON |
+---------------+-------+
2.如果local_infile正常,还报如下错误的,话,请检查user表的File_prv权限,如下所示:
LOAD DATA INFILE '/home/insert.sql'
INTO TABLE tablename;
ERROR 1045 (28000): Access denied for user
'kris'@'localhost' (using password: YES)
我已经赋予了kris一定的权限,但是还是出现了这错误。
后来修改了mysql.user
update user set File_prv='Y' where User='kris';
然后使用LOAD DATA INFILE '/home/insert.sql'
INTO TABLE databasename.tablename;