How to fix "Your password has expired." MYSQL on WHM

If you see an error like:

(XID cjbygs) The system failed to connect to the “MySQL” database “mysql” because of an error: 1862 (Your password has expired. To log in you must change it using a client that supports expired passwords.) at /usr/local/cpanel/Whostmgr/Accounts/Create.pm line 1234.	

 

You'll have to reset MYSQL root password from WHM.

  1. Login to WHM
  2. Go to SQL Services » MySQL Root Password
  3. Generate a new password and click Change Password.

To avoid getting your passwords to expire again, please do the following:

  1. From WHM > Terminal or SSH, Open /etc/my.cnf
  2. add this line: default_password_lifetime=0
  3. restart MYSQL: service mysqld restart
  • mysql, whm, cpanel
  • 13 Users Found This Useful
Was this answer helpful?

Related Articles

Password strength always show 1/100 on cPanel/WHM on CentOS 7

If your cPanel/WHM installation always shows password strength as 1/100, this may be due to...

How to create an Email Account on cPanel

Please do the following to create an Email account on cPanel: Login to cPanel Look for Email...

How to enable Two-Factor Authentication (2FA) on cPanel

By Enabling Two-Factor Authentication, you add an extra layer of security to your cPanel account...

How to convert cPanel account to addon domain

Converting a cPanel account to addon domain or merging two cPanel accounts is not officially...