When I try to upload a csv file to a table in my database and I get this error:
#1045 - Access denied for user 'da_sso_qZw9wgn1S'@'localhost' (using password: YES).
As you may have guessed, I didn't create that user. I only have 2 users listed and 'da_sso_qZw9wgn1S' ain't one of them. When I run the command
SELECT USER(), CURRENT_USER();
I get this output:
USER() CURRENT_USER()
da_sso_tJGh5xbAF@localhost da_sso_tJGh5xbAF@localhost
As you can see the user has changed from my initial error message. I've contacted my hosting company and they state: "We do not have expertise on application level. It would be best to consult a developer regarding this." I've searched this forum and there is plenty on the #1045 error but I find nothing that references a random user being generated by the system.
I'm at a dead end here. Any help would be appreciated.
I've tried finding the user but am unable to. I contacted my hosting provider and they have no "expertise" on the matter and to find help elsewhere. I don't know what else to try.