[bigdata-001] mysql 5.7 由于安全问题不能导出数据的解决方式
发布时间:2020-12-14 01:24:19 所属栏目:大数据 来源:网络整理
导读: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 i
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;
3. 这一点很重要,如果找不到资料,要在这里折腾很久。 (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |