Change MySQL root password on Elastix

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