Update MySQL User Password To Use Long Hash

PHP 5.3 or newer requires to use the "long hash" mysql user password option for security purposes.  If you receive a database connection error, ensure that you're using the long hash option by updating the password via the following method:
  1. Go to Databases -> MySQL -> MySQL DBs
  2. Find the database in the list
  3. Click the "Change password" button
  4. Type in a temp password, select Long Hash and submit
  5. Click the "Change Password" button again
  6. Type in the real password
  7. Select "Long" under the "MySQL Password hash length" section
  8. Submit
  • 591 Users Found This Useful
Was this answer helpful?

Related Articles

Backup account files manually

Although we offer backups for site files, databases and mail stored on our mail servers, you may...

Using multiple devices to check email

If you would like to check mail on our servers with a mail client (outlook thunderbird, etc) as...

Setup Spamexperts - hsphere

THIS NO LONGER APPLIES.   To setup spamexperts within the hsphere control panel...

How to create a mailbox

To create mailbox within hsphere (the control panel), please do the following:Login to the...

Microsoft Outlook 365 DNS SRV Records

When adding SRV records in hsphere for Microsoft 366, the fields under the DNS configuration new...