Change MySQL root password and admin on Elastix, Issabel

To easily change the Elastix or Issabel admin password and mySQL root password via SSH, run the following command:

Elastix

elastix-admin-passwords --change

1	elastix-admin-passwords --change

Issabel

issabel-admin-passwords --change

1	issabel-admin-passwords --change

In order to change MySQL root password first stop service

service mysqld stop

1	service mysqld stop

Start MySQL in safe mode

mysqld_safe --skip-grant-tables &

1	mysqld_safe --skip-grant-tables &

mysql -u root

1	mysql -u root

Change password

use mysql;
update user set password=PASSWORD("MYNEWPASSWORD") where User='root';
flush privileges;
quit

use mysql;

update user set password=PASSWORD("MYNEWPASSWORD") where User='root';

flush privileges;

quit

Restart service

service mysqld restart

1	service mysqld restart

Finally check the new password:

mysql -u root -p

1	mysql -u root -p