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 Login to Control Panel

To view your control panel and service info, please do the following: Login to the client area...

Installing a script

Installing a script nowadays is usually straight forward and they have documents to described how...

Command to run a PHP Script via Cron

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

How to find which servers are used for services

With our service clustering, your account can use multiple servers.  To find out which ones...

Disable Pagespeed

On our shared servers, we have pagespeed module enabled in nginx (the front web server).  This...