Skip to content
← dbForge Studio for MySQL

I suggest you...

dbForge Studio for MySQL: Questions

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Change user for select into outfile file permission

I have to be able to write files to a secure Windows server location where the user is something other than {user}@localhost. Is there a way to pass a username and password in the select into outfile command? I cannot have the write-to location be open to the world because the data are confidential.

1 vote
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Jim VanO shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
AdminDevart (_, Devart) responded  · 

Could you please describe this in more detail and let us know how it should be connected with dbForge?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Jim VanO commented  ·   ·  Report

    If I want to write an outfile to a particular folder to which only jv23@domain_name has full permission given confidential nature of data, I cannot write the file using dbForge. dbForge returns errcode 1 - Can't create/write to file and errcode 2 - No such file or directory. Some place (I can't remember where) I found out the reason for the error was that dbForge was passing the MySQL username @ localhost, which is not the domain user, there was no way to change the user writing the file, and I have no permission to change the folder permissions.