HostGator Web Hosting Help
Setting a Password for the Main MySQL User
The main MySQL username is primarily used to login to phpMyAdmin however it can also be used in database connection scripts. If you are using the main MySQL username to connect to a database, you will need to change the MySQL user password and update the password in your script.
Note: MySQL users you create will not be affected. This password change is only for the main username as shown on the password change screen.
Setting the main MySQL Password
- Login to your HostGator Control Panel
- Click the Reset MySQL Password icon, found under the Databases section of the cPanel.
- Notice the username shown. This is the main username for your account.
- Enter in a new password in the "New Password" text box. As you type you will see the password requirements which have not yet been met. You can also see your password's strength.
Note: This will only change the password for the main MySQL user.
- Enter in the same password again in the second "New Password" text box.
- Click the Set MySQL Password button. You should then see a message "Your password has successfully been updated, Click here to continue".