关于mysql中出现load data infile的两个问题

Database changed
mysql> LOAD DATA INFILE '/home/ming/SQL6/in.txt' INTO TABLE employee;
ERROR 13 (HY000): Can't get stat of '/home/ming/SQL6/in.txt' (Errcode: 2)
mysql> LOAD DATA LOCAL INFILE '/home/ming/SQL6/in.txt' INTO TABLE employee;
ERROR 1148 (42000): The used command is not allowed with this MySQL version
mysql> exit
Bye
ming@ming-K54HR:~$ mysql -u root -p --local-infile
Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
ming@ming-K54HR:~$ mysql -u root -p --local-infile
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 41
Server version: 5.5.52-0ubuntu0.14.04.1 (Ubuntu)


Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.


Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.


Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


mysql> LOAD DATA LOCAL INFILE '/home/ming/SQL6/in.txt' INTO TABLE employee --local-infile;
ERROR 1046 (3D000): No database selected
mysql> use mysql_shiyan
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A


Database changed
mysql> LOAD DATA LOCAL INFILE '/home/ming/SQL6/in.txt' INTO TABLE employee;
ERROR 2 (HY000): File '/home/ming/SQL6/in.txt' not found (Errcode: 2)
mysql> LOAD DATA LOCAL INFILE '/tmp/SQL6/in.txt' INTO TABLE employee;
Query OK, 7 rows affected (0.03 sec)

Records: 7  Deleted: 0  Skipped: 0  Warnings: 0

具体出现的情况以及解决大方法如上面所示。主要是由于安装mysql的时候没有启用local infile，所以需要用到的时候，在登录数据库的时候，一定要加上--local-infile。如我上面所示ming@ming-K54HR:~$ mysql -u root -p --local-infile

其他原因，权限问题，可以将文件所有者改成mysql，格式为chown file mysql