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

How to add a domain / website for hosting

To add a domain for hosting, please do the following: Login to the control panel (please see...

How to create subdomains? (sub.domain.com)

To add a subdomain, please do the following: Login to the control panel -- please see...

Where do I upload files for the web site? (public_html)

Hsphere has a true separate domain setup and as such there isn't a central "public_html" folder...

How can I test my site before changing DNS? (instant aliases)

To test your site before changing the DNS nameservers, you can use the instant access alias that...

Hsphere User Guides

User guides for our hsphere control panel are available at our downloads section for user guides:...