Re: INTO OUTFILE ERROR...

2014-09-22 Thread william drescher
On 9/19/2014 10:59 AM, Don Wieland wrote: On Sep 19, 2014, at 7:50 AM, Reindl Harald wrote: the target folder don't matter that is clearly a *MySQL error* that your *MYSQL user* lack the needed permissions Yes i figured that - so the question is, how do I give full permissions to that

Re: INTO OUTFILE ERROR...

2014-09-22 Thread Reindl Harald
Am 22.09.2014 um 12:44 schrieb william drescher: On 9/19/2014 10:59 AM, Don Wieland wrote: On Sep 19, 2014, at 7:50 AM, Reindl Harald wrote: the target folder don't matter that is clearly a *MySQL error* that your *MYSQL user* lack the needed permissions Yes i figured that - so the

Re: INTO OUTFILE ERROR...

2014-09-21 Thread Divesh Kamra
Check permission of user 'teal1dwd_teal' DK Sent from Phone On 19-Sep-2014, at 8:13 pm, Don Wieland d...@pointmade.net wrote: Hi gang, Trying to generate a CSV file using mySQL and I keep getting this error below. The target folder has full permissions to write (777). I am not

Re: INTO OUTFILE ERROR...

2014-09-19 Thread Reindl Harald
Am 19.09.2014 um 16:43 schrieb Don Wieland: Trying to generate a CSV file using mySQL and I keep getting this error below. The target folder has full permissions to write (777). I am not certain why this is happening. Any answers? Thanks! the target folder don't matter that is clearly a

Re: INTO OUTFILE ERROR...

2014-09-19 Thread Don Wieland
On Sep 19, 2014, at 7:50 AM, Reindl Harald wrote: the target folder don't matter that is clearly a *MySQL error* that your *MYSQL user* lack the needed permissions Yes i figured that - so the question is, how do I give full permissions to that user? I did go to my cPanel and delete the

Re: INTO OUTFILE ERROR...

2014-09-19 Thread Reindl Harald
Am 19.09.2014 um 16:59 schrieb Don Wieland: On Sep 19, 2014, at 7:50 AM, Reindl Harald wrote: the target folder don't matter that is clearly a *MySQL error* that your *MYSQL user* lack the needed permissions Yes i figured that - so the question is, how do I give full permissions to

Re: INTO OUTFILE ERROR...

2014-09-19 Thread Don Wieland
Thanks Reindl, Yes I stubbled upon this page last night. I try running that query: grant all privileges on teal1dwd_teal.* to 'teal1dwd_teal'@'localhost' identified by 'my_user_pw'; I get this error: #1044 - Access denied for user 'teal1dwd'@'localhost' to database 'teal1dwd_teal'

Re: INTO OUTFILE ERROR...

2014-09-19 Thread Christophe
Hi there, Le 19/09/2014 17:19, Don Wieland a écrit : grant all privileges on teal1dwd_teal.* to 'teal1dwd_teal'@'localhost' identified by 'my_user_pw'; I get this error: #1044 - Access denied for user 'teal1dwd'@'localhost' to database 'teal1dwd_teal' I think you are trying to

Re: INTO OUTFILE ERROR...

2014-09-19 Thread Christophe
Le 19/09/2014 18:00, Christophe a écrit : Hi there, Le 19/09/2014 17:19, Don Wieland a écrit : grant all privileges on teal1dwd_teal.* to 'teal1dwd_teal'@'localhost' identified by 'my_user_pw'; I get this error: #1044 - Access denied for user 'teal1dwd'@'localhost' to database

Re: INTO OUTFILE ERROR...

2014-09-19 Thread Don Wieland
On Sep 19, 2014, at 9:11 AM, Christophe wrote: Don't you have root access to MySQL instance ? I guess not, I am using a managed server VPSLatch. I chatted with them and they are going to GRANT the permissions I need…at least that is what the tech said. I waiting with baited breath ;oP

Re: INTO OUTFILE ERROR...

2014-09-19 Thread Mogens Melander
Maybe you need to grant access from localhost to the user? On Fri, September 19, 2014 16:59, Don Wieland wrote: On Sep 19, 2014, at 7:50 AM, Reindl Harald wrote: the target folder don't matter that is clearly a *MySQL error* that your *MYSQL user* lack the needed permissions Yes i figured

Re: INTO OUTFILE error

2004-06-02 Thread [EMAIL PROTECTED]
There's got ot be something else wrong. I've got the exact same problem and I have done a chmod 666 on the directory I am trying to write to with no luck. I am running v4.0.15 /T on 6/1/04 7:06, Egor Egorov at [EMAIL PROTECTED] wrote: John Mistler [EMAIL PROTECTED] wrote: Would there be any

Re: INTO OUTFILE error

2004-06-02 Thread Paul DuBois
At 5:18 -0500 6/2/04, [EMAIL PROTECTED] wrote: There's got ot be something else wrong. I've got the exact same problem and I have done a chmod 666 on the directory I am trying to write to with no luck. I am running v4.0.15 Mode is not enough, you must consider ownership. Remember, *you* are not

Re: INTO OUTFILE error

2004-06-02 Thread Michael Stassen
Paul DuBois wrote: At 5:18 -0500 6/2/04, [EMAIL PROTECTED] wrote: There's got to be something else wrong. I've got the exact same problem and I have done a chmod 666 on the directory I am trying to write to with no luck. I am running v4.0.15 Mode is not enough, you must consider ownership.

Re: INTO OUTFILE error

2004-06-01 Thread Egor Egorov
John Mistler [EMAIL PROTECTED] wrote: Can anyone guess why I am getting this error: ERROR 1: Can't create/write to file '/Users/johnmistler/Desktop/TestFile.txt' (ERRCODE 13) when using this statement: mysql SELECT * INTO OUTFILE '/Users/johnmistler/Desktop/TestFile.txt' FROM theTable

Re: INTO OUTFILE error

2004-06-01 Thread John Mistler
Would there be any obvious reasons for its inability to access the desktop? I have used that desktop directory many times before in UNIX. Thanks, John on 6/1/04 12:49 AM, Egor Egorov at [EMAIL PROTECTED] wrote: John Mistler [EMAIL PROTECTED] wrote: Can anyone guess why I am getting this

Re: INTO OUTFILE error

2004-06-01 Thread Egor Egorov
John Mistler [EMAIL PROTECTED] wrote: Would there be any obvious reasons for its inability to access the desktop? I have used that desktop directory many times before in UNIX. Check permissions on that dir. It must be writeable by the user you run mysqld as ('mysql' by default). on

Re: into outfile error

2001-10-24 Thread Carl Troein
Avelino F writes: I managed to set the file permission and managed to send the output to the mysql database directory used. Do you know if there is a way to make mysql write to a remote directory? As in on any machine in the world? No. As in on the client machine? Not really, since

Re: into outfile error

2001-10-24 Thread Paul DuBois
At 1:08 -0400 10/24/01, Avelino F wrote: Hello, I managed to set the file permission and managed to send the output to the mysql database directory used. Do you know if there is a way to make mysql write to a remote directory? Is there a global or local configuration that can be specified

RE: into outfile error

2001-10-24 Thread Christopher Bergeron
You may also want to make sure that you did: flush privileges; to make sure they are implemented. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 24, 2001 7:36 PM To: Avelino F Cc: [EMAIL PROTECTED] Subject: Re: into outfile error At 1:08

Re: into outfile error

2001-10-23 Thread Paul DuBois
At 10:43 PM -0400 10/23/01, Avelino F wrote: Hello, After logging into mysql and selecting a database, I type select * from song into outfile 'data123.txt'; but receive the following error message: ERROR 1045: Access denied for user: 'avelino@localhost' (Using password: YES) mysql I made

Re: into outfile error

2001-10-23 Thread Avelino F
Hello, I managed to set the file permission and managed to send the output to the mysql database directory used. Do you know if there is a way to make mysql write to a remote directory? Is there a global or local configuration that can be specified where mysql will write to? Regards, Avelino