We have to remove and re-add the user for mysql to work.

Can anyone think of a way to fix this in case it happens again. Where can I find the mysql users and password so I could just transfer the files manually to that directory from the other server.