Shulou(Shulou.com)06/01 Report--

Select * into outfile'/ home/update_testdbtest.txt' from update_test

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

Mysql > select * from update_test

+-+ +

| | id | name |

+-+ +

| | 1 | hello |

| | 2 | world |

+-+ +

2 rows in set (0.00 sec)

Mysql > show variables like'% secure%'

->

+-+

| | Variable_name | Value |

+-+

| | require_secure_transport | OFF |

| | secure_auth | ON |

| | secure_file_priv | / var/lib/mysql-files/ |

+-+

3 rows in set (0.01sec)

Mysql > select * into outfile'/ var/lib/mysql-files/update_testdbtest.txt' from update_test

Query OK, 2 rows affected (0.00 sec)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.