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’@‘18.104.22.168/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?