var sidebar_align = 'right';
var content_container_margin = parseInt('350px');
var sidebar_width = parseInt('330px');
Trying to OUTPUT a Table but Access is Denied
Error Access denied for user 'user_don'@'localhost' (using password: YES) with query SELECT * INTO OUTFILE 'home2/user/public_html/spreadsheet.xls' FROM survery
That is the error I am recieving when I try to execute this SQL statement:
$export="SELECT * INTO OUTFILE 'http://www.url.com/spreadsheet.xls' FROM survery";
Now my user has all privileges, so does anyone have an idea as to why I am getting this problem?
Check that the username and password are correct... Also, check the spelling of your query, and make sure that your table is `survery` and not, perhaps, `survey`
Checked and everything is correctly spelled.
Originally Posted by GamePhreak
Check that spreadsheet.xls does not already exist. SELECT INTO OUTFILE will not overwrite a preexisiting file.
Checked and there is no file with the name spreadsheet.xls
the user user_don must exist with the correct password. Try a FLUSH PRIVILEGES if you just created it.
Try to specify absolute rather than relative path.
Dyslexics Have More Fnu