If you happen to forget to save the password you generated or if you have somehow lost it, then don’t panic! You can reset the password as long as you have access to cPanel. First, log in to your cPanel.
Under Databases, find MySQL® Databases
Scroll down to the section labelled: Current Users
Look for the user you had set and click on the “change password” link next to it.
You can set your own password or generate it. Just make sure to take note of it this time around! You should get a success message when completed and get redirected back to the previous page.