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 th

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 user?

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 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 > certain why this i

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

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 Thanks

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 '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 ac

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' Do

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 permission

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 u

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

INTO OUTFILE ERROR...

2014-09-19 Thread Don Wieland
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 certain why this is happening. Any answers? Thanks! Database_Class error: DATABASE_ERROR: Access denied for user 'teal1dwd_teal'@'localhost'

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. Huh?

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 t

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

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

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: > 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' FRO

INTO OUTFILE error

2004-05-31 Thread John Mistler
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 WHERE column1 != 'thisString'; ? I am loggi

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-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 specifie

Re: into outfile error

2001-10-23 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 ther

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

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> > >

into outfile error

2001-10-23 Thread Avelino F
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 sure the user has full permissions to the databas