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

Change Mailbox / Email Address Password

If you know the password already: You can change the mailbox (email address) password via...

Giving limited access to developers

In hsphere you can create users for FTP and mysql so that you can limit access to content and...

Email Provider Message Sizes

Most mail servers limit the message size -- the size of the entire message including all...

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...

Command to run a PHP Script via Cron

If you want to run a PHP script via cron, you would do the following command:...