I've granted all permissions on a certain database to a specific user so does anyone know why I get permission denied running this query from mysqlman:

SELECT * INTO OUTFILE '/path/to/tmp/file' FIELDS TERMINATED BY '|' ESCAPED BY '\\' LINES TERMINATED BY '\n' FROM table_name;

I can do it as root but as the user it gives.....

MySQL Said: Access denied for user: 'user@localhost' (Using password: YES).

Thanks.

muRdeR Lucky you !
you got it to work almost :)

mysql gives you this error when you trying to access with wrong username or password

make sure it's correct and you have changed password on the server

mysqladmin -user root password "typepasswordhere"

Yeah I know when that error occurs - thats why Im confused because the username/password is correct as I can run any other query but that.

Same error here.

The user name and password are correct, but the darned thing won't let me export a table

Would anyone know what might be the problem?

Thanks.

------------------------------------------

** bump **

------------------------------------------

Get your host to update your mysql privs. This error is caused by you not having full permissions on your database:

GRANT ALL ON database.* TO username@localhost IDENTIFIED BY 'password';

Specifically you don't have FILE access permission. For some reason this is a common setting on ISP's. They will remove FILE access which disabled the import/export abilities.

Need to ask your ISP to give your user FILE permissions.

Cheers,

Alex
--
Gossamer Threads Inc.

Thank you very kindly, Alex and RedRum!

Will check into this.

------------------------------------------