Can't connect to MySQL with a password starting with $
Hi, I am installing EPC on my server and when I enter the database details I get the error "Access Denied". All the details are definitely correct but I think that the fact that my database password starts with the string character '$' is causing problems - this is indicated by the fact that upon receiving the error, all the fields are prepopulated with the correct details EXCEPT the password field, which has been reduced to simply '$' rather than '$mypassword'.
I can create a new user for the DB but I'd prefer to use the one I already have. I can't easily change the password because other scripts are also using the same user. Any thoughts?