**Linux Mysql没法备份文件
**
select * into outfile '/root/mess/MySQL/Uploads/student.txt' from student;
报错提醒
Linux怎么设置secure_file_priv权限
查看权限代码为:show variables like '%secure%';
原来的权限:
1.找到/etc/my.cnf
2.在在/etc/my.cnf的[mysqld]下面
(1)添加local-infile=0选项。[重启了发现没用]
(2)又加了secure_file_priv =
如图
3.关机,开机
cd /usr/local/mysql
service mysql stop
service mysql start
再查show variables like ‘%secure%’;