首先修改MySQL配置

找到mysql安装目录下的 my.ini 文件，将

secure-file-priv = "C:/ProgramData/MySQL/MySQL Server 5.7/Uploads"

追加到my.ini 的末尾处，重启MySQL

执行导出命令

SELECT * FROM user

INTO OUTFILE 'C:/ProgramData/MySQL/MySQL Server 5.7/Uploads/user06.csv'

    FIELDS TERMINATED BY ','

    ENCLOSED BY ''

    LINES TERMINATED BY '\n'