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;
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. 这一点很重要,如果找不到资料,要在这里折腾很久。