Ever lost/forgotten your password to a mySQL Database user?
This is unrecoverable and you are recommended to re-create the user afresh. This unfortunately messed up any existing CMS website that uses that original user.
My solution? Nice and simple.
Create a fresh user, make a record of this new user's password for later, then add the new user to your original database, retaining the old user as well, and use the new user to access the database using your newer...