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

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

When will MySQL support the ANSI SQL MERGE command?

2014-09-19 Thread ccleve
I need to do upserts and I need cross-database compatibility. I'd hate to drop support for MySQL in my product. Does MySQL plan to support the ANSI-standard MERGE command for upserts? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: When will MySQL support the ANSI SQL MERGE command?

2014-09-19 Thread shawn l.green
Hello ccleve, On 9/19/2014 3:06 PM, ccleve wrote: I need to do upserts and I need cross-database compatibility. I'd hate to drop support for MySQL in my product. Does MySQL plan to support the ANSI-standard MERGE command for upserts? You appear to be looking for one of these commands

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