ERROR 1 (HY000): Can't create/write to file '/test.txt' (Errcode: 13)

      在做导出数据的时候遇到的问题，遇到此问题。

      Select * into outfile '/tmp/test.txt' fields terminated by ',' optionally enclosed by '"' lines terminated by '/n' from TABLE limit 100;

     ERROR 1 (HY000): Can't create/write to file '/test.txt' (Errcode: 13)

 

     解决方法：

    1.修改my.cnf,在MYSQLD中去除#tmodir 的#号；

    2.保存修改，退出；

    3.重启MYSQL服务；

      >serivce mysqld stop;

      >service mysqld start;