Sometimes we want to change hostgator mysql database user password, or we have to change when we forgot the password. How to do?
Very simple infact, first delete the user name of the mysql and remake it, but make sure you use exactly the same name when remaking.
then bind the old database name to the new database user name.
next modify the user password in your software config file, for example, if you use wordpress, you have to modify wp-config.php; if you use vbulletin forum, just modify config.php