how to fix 'access denied xx@loaclhost using password yes' when uploading files

Michael

New member
into mysql using php? the username and password I'm using is the same as accessing data on my select queries on other pages within my site, any help appreciated Is it a hosting issued?
I can do updates through text box input but I want to update via csv. My test server works fine using all the same login details and table names etc.
I am using the connection script my hosting provider gave me, all my other queries work. My csv uploads to the directory OK but the update query is denied..
 
The MYSQL database itself should be password protected. Perhaps you are only accessing password protected pages and not the actual database.

Your hosting provider should supply you with MYSQL access through your Control Panel and you should be able to see the current password or set a new one.
 
Back
Top