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

Selecting PHP version

Selecting PHP versions can be done by doing the following:hsphere Login to the control panel...

Standard Mail Settings

Mail Server Info: Login: Is your full email address (example@example.com) Incoming mail...

What is an SSL certificate?

An SSL certificate encrypts data that is sent between the server and you, your computer, your...

Creating a SSL CSR (Signing request) and private key

To generate a certificate signing request (CSR) and private key, please do the following:Login to...

Setup Spamexperts - hsphere

To setup spamexperts within the hsphere control panel (https://cp.u2-web.com) please do the...