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.
- Login to WHM
- Go to
SQL Services » MySQL Root Password
- Generate a new password and click
Change Password
.
To avoid getting your passwords to expire again, please do the following:
- From WHM > Terminal or SSH, Open
/etc/my.cnf
- add this line:
default_password_lifetime=0
- restart MYSQL:
service mysqld restart