How to change the database user password – cPanel?

Why this post? The MySQL community has depreciated “old_passwords” option since MySQL 5.6 version. So we won’t be able to recollect the password from an old password hashing format. So, once we upgrade the...