Re: INTO OUTFILE ERROR...
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 question is, how do I give full permissions to >> that user? >> >> I did go to my cPanel and delete the user and recreated the user adding them >> to the DB with ALL PRIVILEGES. >> Obviously this is not enough. >> >> If this is not a simple thing that I can do myself, I am willing to >> compensate someone for support they can offer >> via GoToMeeting and SKYPE. >> >> I am spinning my wheels and I need to resolve this issue asap. >> > > Please note: cpanel can create linux users. You need to create and > manage the MySQL users. There is no relationship between the linux > users and the MySQL users irreleveant, he just don't realize that file permissions are *not* in the scope of "adding them to the DB with ALL PRIVILEGES" why in the world did i post the link to the answer last friday if people are too lazy to read GRANT FILE ON *.* TO 'asdfsdf'@'localhost'; is a global setting because you access *the hosts FILESYSTEM* with it http://lmgtfy.com/?q=mysql+permissions+into+outfile http://stackoverflow.com/questions/6091427/mysql-into-outfile-access-denied-but-my-user-has-all-access-and-the-fold signature.asc Description: OpenPGP digital signature
Re: INTO OUTFILE ERROR...
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? I did go to my cPanel and delete the user and recreated the user adding them to the DB with ALL PRIVILEGES. Obviously this is not enough. If this is not a simple thing that I can do myself, I am willing to compensate someone for support they can offer via GoToMeeting and SKYPE. I am spinning my wheels and I need to resolve this issue asap. Please note: cpanel can create linux users. You need to create and manage the MySQL users. There is no relationship between the linux users and the MySQL users. -bill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: INTO OUTFILE ERROR...
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 is happening. Any answers? Thanks! > > > Database_Class error: DATABASE_ERROR: Access denied for user > 'teal1dwd_teal'@'localhost' (using password: YES) IN [SELECT u.user_id, > u.first_name AS u_first_name, > u.last_name AS u_last_name, > c.client_id AS c_client_id, > c.first_name AS c_first_name, > c.middle_name AS c_middle_name, > c.last_name AS c_last_name, > c.address AS c_address, > c.city AS c_city, > c.state AS c_state, > c.zip AS c_zip, > c.dob AS dob_ymd, > c.phone_home AS c_phone_home, > c.phone_cell AS c_phone_cell, > c.phone_work AS c_phone_work, > c.email AS c_email, > c.other_contacts AS c_other_contacts, > count(*) as apt_qty > > FROM tl_appt apt > > JOIN tl_clients c on c.client_id = apt.client_id > JOIN tl_rooms r on r.room_id = apt.room_id > JOIN tl_users u on u.user_id = apt.user_id > > WHERE > > apt.time_start between '1388552400' and '1420088399' > and r.location_id = '1' > > GROUP BY u.user_id, c.client_id > having count(*) > 1 > > ORDER BY u.first_name, u.last_name, c.last_name, c.first_name > INTO OUTFILE '/tmp/1_2031305738.csv' > FIELDS TERMINATED BY ',' > ENCLOSED BY '"'] > > > Don Wieland > d...@pointmade.net > http://www.pointmade.net > https://www.facebook.com/pointmade.band > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: INTO OUTFILE ERROR...
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 that - so the question is, how do I give full permissions to > that user? > > I did go to my cPanel and delete the user and recreated the user adding > them to the DB with ALL PRIVILEGES. Obviously this is not enough. > > If this is not a simple thing that I can do myself, I am willing to > compensate someone for support they can offer via GoToMeeting and SKYPE. > > I am spinning my wheels and I need to resolve this issue asap. > > Don Wieland > d...@pointmade.net > http://www.pointmade.net > https://www.facebook.com/pointmade.band > > > > > > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean. > > -- Mogens Melander +66 8701 33224 -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: INTO OUTFILE ERROR...
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! Don Wieland d...@pointmade.net http://www.pointmade.net https://www.facebook.com/pointmade.band
Re: INTO OUTFILE ERROR...
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 'teal1dwd_teal' I think you are trying to access the DB with the 'teal1dwd' user, but your grant applies to 'teal1dwd_teal'. I forgot to tell, that GRANT queries need to be performed by a user which has the GRANT privilege. Don't you have root access to MySQL instance ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: INTO OUTFILE ERROR...
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 access the DB with the 'teal1dwd' user, but your grant applies to 'teal1dwd_teal'. Hope this helps ;). Regards, Christophe. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: INTO OUTFILE ERROR...
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 I need to perform this query in a different place? Sigh… Don On Sep 19, 2014, at 8:03 AM, Reindl Harald wrote: > "into outfile" is *not* a db-specific permission > > http://lmgtfy.com/?q=mysql+permissions+into+outfile > http://stackoverflow.com/questions/6091427/mysql-into-outfile-access-denied-but-my-user-has-all-access-and-the-fold Don Wieland d...@pointmade.net http://www.pointmade.net https://www.facebook.com/pointmade.band
Re: INTO OUTFILE ERROR...
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 > that user? > > I did go to my cPanel and delete the user and recreated the user adding them > to the DB with ALL PRIVILEGES. > Obviously this is not enough. "into outfile" is *not* a db-specific permission http://lmgtfy.com/?q=mysql+permissions+into+outfile http://stackoverflow.com/questions/6091427/mysql-into-outfile-access-denied-but-my-user-has-all-access-and-the-fold signature.asc Description: OpenPGP digital signature
Re: INTO OUTFILE ERROR...
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 user and recreated the user adding them to the DB with ALL PRIVILEGES. Obviously this is not enough. If this is not a simple thing that I can do myself, I am willing to compensate someone for support they can offer via GoToMeeting and SKYPE. I am spinning my wheels and I need to resolve this issue asap. Don Wieland d...@pointmade.net http://www.pointmade.net https://www.facebook.com/pointmade.band
Re: INTO OUTFILE ERROR...
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 *MySQL error* that your *MYSQL user* lack the needed permissions > Database_Class error: DATABASE_ERROR: Access denied for user > 'teal1dwd_teal'@'localhost' (using password: YES) IN [SELECT u.user_id, > u.first_name AS u_first_name, > u.last_name AS u_last_name, > c.client_id AS c_client_id, > c.first_name AS c_first_name, > c.middle_name AS c_middle_name, > c.last_name AS c_last_name, > c.address AS c_address, > c.city AS c_city, > c.state AS c_state, > c.zip AS c_zip, > c.dob AS dob_ymd, > c.phone_home AS c_phone_home, > c.phone_cell AS c_phone_cell, > c.phone_work AS c_phone_work, > c.email AS c_email, > c.other_contacts AS c_other_contacts, > count(*) as apt_qty > > FROM tl_appt apt > > JOIN tl_clients c on c.client_id = apt.client_id > JOIN tl_rooms r on r.room_id = apt.room_id > JOIN tl_users u on u.user_id = apt.user_id > > WHERE > > apt.time_start between '1388552400' and '1420088399' > and r.location_id = '1' > > GROUP BY u.user_id, c.client_id > having count(*) > 1 > > ORDER BY u.first_name, u.last_name, c.last_name, c.first_name > INTO OUTFILE '/tmp/1_2031305738.csv' > FIELDS TERMINATED BY ',' > ENCLOSED BY '"'] signature.asc Description: OpenPGP digital signature
INTO OUTFILE ERROR...
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' (using password: YES) IN [SELECT u.user_id, u.first_name AS u_first_name, u.last_name AS u_last_name, c.client_id AS c_client_id, c.first_name AS c_first_name, c.middle_name AS c_middle_name, c.last_name AS c_last_name, c.address AS c_address, c.city AS c_city, c.state AS c_state, c.zip AS c_zip, c.dob AS dob_ymd, c.phone_home AS c_phone_home, c.phone_cell AS c_phone_cell, c.phone_work AS c_phone_work, c.email AS c_email, c.other_contacts AS c_other_contacts, count(*) as apt_qty FROM tl_appt apt JOIN tl_clients c on c.client_id = apt.client_id JOIN tl_rooms r on r.room_id = apt.room_id JOIN tl_users u on u.user_id = apt.user_id WHERE apt.time_start between '1388552400' and '1420088399' and r.location_id = '1' GROUP BY u.user_id, c.client_id having count(*) > 1 ORDER BY u.first_name, u.last_name, c.last_name, c.first_name INTO OUTFILE '/tmp/1_2031305738.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"'] Don Wieland d...@pointmade.net http://www.pointmade.net https://www.facebook.com/pointmade.band
Re: INTO OUTFILE error
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? I don't understand what you are saying here. Remember, *you* are not trying to write the file. The MySQL server (mysqld) is trying to write the file, and it might not be running under your user ID. It's probably running from the "mysql" account. Right. The server, running as user mysql, writes the file, so the mysql user must be able to write a file in the target directory. This does not require ownership, however, only the correct set of permissions. To do anything in the destination directory, the mysql user must have execute permission on every part of the path. In the case of the original poster, where we want to write a file in /Users/johnmistler/Desktop, mysql must have execute permission on /, /Users, /Users/johnmistler, and /Users/johnmistler/Desktop just to be able to cd (change directory) to /Users/johnmistler/Desktop. Once there, it must have write permission to create a new file. Usually, the path to one's home directory is executable by everyone by default, so giving write permission to the subdirectory is enough. If, however, the targetdir is more than one level below home, you'll probably have to add execute permission to the intervening directories as well. This is why `chmod 666 targetdir` does not work. It gives everyone permission to read and write targetdir, but it removes execute permission. Without execute, you cannot cd into targetdir, rendering write permission useless. Instead, you should do `chmod 733 targetdir`. This gives execute and write permission to everyone, but reserves read permission to targetdir's owner. Thus, mysql will be able to cd to targetdir and write a file (as will anyone else), but only targetdir's owner will be able to list the contents of targetdir (the point of read permission), which adds a teeny bit of security. As an example, if targetdir is the /path/to/home/mysqlstuff/proj1/outfiles directory, you will probably need to chmod 755 mysqlstuff chmod 755 mysqlstuff/proj1 chmod 733 mysqlstuff/proj1/outfiles If you have the power to set targetdir's group to mysql, (assuming mysql runs as user=mysql, group=mysql), you can drop the world permissions in favor of just the group permissions. sudo chgrp mysql targetdir chmod 730 targetdir That would be an improvement in terms of security, since it further limits access to targetdir. Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: INTO OUTFILE error
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 trying to write the file. The MySQL server (mysqld) is trying to write the file, and it might not be running under your user ID. It's probably running from the "mysql" account. /T on 6/1/04 7:06, Egor Egorov at [EMAIL PROTECTED] wrote: 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 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 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 logging in as root for the test. It means that MySQL server can not access to the /Users/johnmistler/Desktop/ directory. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: INTO OUTFILE error
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 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 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 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 logging in as root for the test. >>> >>> It means that MySQL server can not access to the /Users/johnmistler/Desktop/ >>> directory. >>> >>> >> >> > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: INTO OUTFILE error
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 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 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 logging in as root for the test. >>> >> >> It means that MySQL server can not access to the /Users/johnmistler/Desktop/ >> directory. >> >> > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: INTO OUTFILE error
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 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 logging in as root for the test. >> > > It means that MySQL server can not access to the /Users/johnmistler/Desktop/ > directory. > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: INTO OUTFILE error
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 WHERE column1 != 'thisString'; > > ? I am logging in as root for the test. > It means that MySQL server can not access to the /Users/johnmistler/Desktop/ directory. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
INTO OUTFILE error
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 logging in as root for the test. Thanks, John -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: into outfile error
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 -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 where mysql will write to? The server's doing the writing of the file, and it can only write the file on the server host. If you want the output written to a file on a client host, you'll need to use a client program that issues the select and writes the result to a file itself. >Regards, >Avelino > >At 10:09 PM 10/23/2001 -0500, you wrote: >>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 sure the user has full permissions to the database using >>>the grant command. Any suggestions on what can be wrong? >> >>Said user might have full permissions on the database, but to use >>SELECT INTO OUTFILE, you also need the FILE privilege, which is a >>global privilege, not a database-specific one. Most administrators >>won't grant the FILE privilege lightly. >> >>> >>>Thanks, >>>Avelino -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: into outfile error
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 where mysql will write to? The server's doing the writing of the file, and it can only write the file on the server host. If you want the output written to a file on a client host, you'll need to use a client program that issues the select and writes the result to a file itself. >Regards, >Avelino > >At 10:09 PM 10/23/2001 -0500, you wrote: >>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 sure the user has full permissions to the database using >>>the grant command. Any suggestions on what can be wrong? >> >>Said user might have full permissions on the database, but to use >>SELECT INTO OUTFILE, you also need the FILE privilege, which is a >>global privilege, not a database-specific one. Most administrators >>won't grant the FILE privilege lightly. >> >>> >>>Thanks, >>>Avelino -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: into outfile error
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 there's no equivalent of LOAD LOCAL DATA INFILE. What you can do is either use the mysql command line client and > to a file, or just loop over the result and save it in whatever format you wish in your favourite language. > Is there a global or local configuration that > can be specified where mysql will write to? It will write where you tell it to, if that location fulfils the criteria listed in the manual. I think mysql chdir()s to the data directory, but I wouldn't rely on it. Entering the full path isn't all that work anyway. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: into outfile error
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 At 10:09 PM 10/23/2001 -0500, you wrote: >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 sure the user has full permissions to the database using the grant >>command. Any suggestions on what can be wrong? > >Said user might have full permissions on the database, but to use >SELECT INTO OUTFILE, you also need the FILE privilege, which is a >global privilege, not a database-specific one. Most administrators >won't grant the FILE privilege lightly. > >> >>Thanks, >>Avelino > > >-- >Paul DuBois, [EMAIL PROTECTED] > >- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: into outfile error
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 sure the user has full permissions to the database using the >grant command. Any suggestions on what can be wrong? Said user might have full permissions on the database, but to use SELECT INTO OUTFILE, you also need the FILE privilege, which is a global privilege, not a database-specific one. Most administrators won't grant the FILE privilege lightly. > >Thanks, >Avelino -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
into outfile error
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 database using the grant command. Any suggestions on what can be wrong? Thanks, Avelino - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php