Solved

select into outfile permission denied on windows 8

Posted on 2014-01-08
1
2,570 Views
Last Modified: 2014-01-08
Hello

I am trying to run a select into outfile command from mysql 5.6 command line on windows 8 and I get a permission denied error. I have run the command prompt as administrator.

I have tried writing the output file as:

c:\outout.txt
c:\\output.txt
c:/output.txt

This is the error i get

ERROR 1 (HY000): Can't create/write to file 'C:\output.txt' (Errcode: 13 - Permi
ssion denied)

This is a cut down version of the statement

mysql> select * from testdb.web_vehicles into outfile 'C:\\output.TXT';
ERROR 1 (HY000): Can't create/write to file 'C:\output.TXT' (Errcode: 13 - Permi
ssion denied)

thanks a lot
0
Comment
Question by:andieje
1 Comment
 
LVL 59

Accepted Solution

by:
Kevin Cross earned 500 total points
ID: 39766086
The default NTFS permissions on Windows is more secure in newer versions, try sending the output file to C:\Temp\output.txt or your documents folder (i.e., C:\users\%username%\documents).
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question