I am trying to run the following query from within phpMyAdmin.
SELECT *
INTO OUTFILE '/public_html/values.txt'
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
FROM b2users
ORDER BY user_login
I keep getting the following error:
Access denied for user: 'xxxxxxx@localhost' (Using password: YES)
where xxxxxxx is my username.
Any Ideas?you are using the wrong password or you can't use the OUTFILE command or you have to just use the file name instead of the full path
SELECT *
INTO OUTFILE '/public_html/values.txt'
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
FROM b2users
ORDER BY user_login
I keep getting the following error:
Access denied for user: 'xxxxxxx@localhost' (Using password: YES)
where xxxxxxx is my username.
Any Ideas?you are using the wrong password or you can't use the OUTFILE command or you have to just use the file name instead of the full path