Snytax error

Kudose

I fixed the syntax problem, now I have a new one.

I have a permissions problem. I can connect with a script with a user, but this user (who has admin rights) gets the error "Access Denied for user using password: YES" after trying to run a SQL query to insert data from a uploaded CSV.

Could anyone explain why?

nemonoman

The error tells you that there's a problem with username and password you've provided.

Kudose

But I cant be, becuase everything else works fine. All queries, etc... Just the upload doesnt.

rachel2004

Originally posted by Kudose
But I cant be, becuase everything else works fine. All queries, etc... Just the upload doesnt.

Not sure what you mean by that. Your first post was an error message from the db, which nemonoman was kind enough to explain to you. There is not much troubleshooting that can be done on an incorrect username/password combination other than to say to use the correct ones.

nemonoman

Check the privileges for that username. Maybe you don't have insert or update privileges.