[bigdata-001] mysql 5.7 由于安全问题不能导出数据的解决方式

1.
create user 'b1'@'localhost' identified by 'b1';

grant all privileges on *.* to 'b1'@'localhost' identified by 'b1';


2.

select oid into outfile '/home/brian/xxx.csv' from android_user_event_sorted;

ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement


secure_file_priv设置了指定目录，需要在指定的目录下进行数据导出

show variables like '%secure%';


+--------------------------+-----------------------+
| Variable_name??????????? | Value???????????????? |
+--------------------------+-----------------------+
| require_secure_transport | OFF?????????????????? |
| secure_auth????????????? | ON??????????????????? |
| secure_file_priv???????? | /var/lib/mysql-files/ |
+--------------------------+-----------------------+


select oid into outfile '/var/lib/mysql-files/xxx.csv' from android_user_event_sorted;

select oid,userid,createtime,method,page into outfile '/var/lib/mysql-files/page_event.csv' fields terminated by '|' lines terminated by 'n' from an_user_event;

3. 这一点很重要，如果找不到资料，要在这里折腾很久。

（编辑：我爱故事小小网_铜陵站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!