MySql 1045 error with SELECT INTO OUTFILE

Unlimited Shared hosting & Unlimited Disk Space from $5.95 - Dreamhost
Solid Managed VPS with 4 IP's from $60 - Liquid Web
Lightning Fast Dedicated Servers & 1GB RAM from $149 - Liquid Web
#1 Domain Registration with WHOIS Privacy - Just $9.95

This Dreamhost support thread was started by ajvcal on 2009-11-06 17:44:22:

Post Reply? I’m trying to do a backup of a table (tab-delimited txt file) using (from the command line while logged into karpis.dreamhost.com): mysqldump –opt -T “./” -h mysql.mydomain.me -uUser -pPassword dbName dbTable I get the error message: mysqldump: Got error: 1045: Access denied for user ‘User’@'67.205.0.0/255.255.192.0′ (using password: YES) when executing ‘SELECT INTO OUTFILE’ Interestingly enough, the mysqldump command does write out the dbTable.sql file, but not the dbTable.txt file (as indicated by the error message). Since I can connect, it would seem the issue might be related to file permissions, but I haven’t found a way to grant “User” FILE privileges. Currently, “User” has all the privileges that are available through the Dreamhost web panel. Is the issue with file permissions? If so, how can grant “User” the necessary permissions? Thank you, Andrew.

Join in on the original post at the Dreamhost Forum, Apply for a Dreamhost Account or view our Review of Dream Host.