MySQL在windows上匯入資料提示錯誤(Errcode: 13 - Permission denied)

標籤：read   service   rest   對話   sql   提示   mys   using   can   

提示ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it ...statemet

編輯C:\ProgramData\MySQL\MySQL Server 5.7\my.ini，修改secure-file-priv="/"或者其他可以訪問的檔案夾

提示Errcode: 13 - Permission denied

在windows服務對話方塊下

If you are using Windows, open services. Right click on mysql service, select properties. In the properties window select Log On tab then Log on as: Local System account.

If you are ready, restart the service and you can select into outfile anywhere where you have permission to write.

MySQL在windows上匯入資料提示錯誤(Errcode: 13 - Permission denied)