Permission question

[Atlantis95]

I have a problem with running a special select command.

When I try to do a:
"select user_id into into OUTFILE '-directory-test.bsql' from user"

in a .php script, I get the following error:
Access denied for user: 'mike_2005@localhost' (Using password: YES)

This looks like a user permission problem inside the mysql environment. However for the particular MySql alle possible permissions are set (permission set from 'Select' till 'Lock Tables'). Permission from the target directory a+rwx .

 

[jmstacey]

You might try asking in the #php room on irc.freenode.net (IRC)
They may be able to give you more definate help.

Are you making the connection to the database before hand properly? That would seem to be the problem, but if other commands other than this one are working....

you have two "into"s in your command, was that on purpose, although I doubt that would have any bearing on permission denied responses.