Change MySQL Password on Zentyal

1.Change the default password in the config file for Zentyal 

Code:

sudo nano 

/var/lib/zentyal/conf/zentyal-mysql.passwd

2. Copy and paste the password to a text file for root login later. Comment out the password in the file and list your new password for mysql. Then press ctrl 'x' then 'y'
3. Stop the MySQL Server.

Code:

sudo /etc/init.d/mysql stop

4. Start the mysqld configuration

Code:

sudo mysqld --skip-grant-tables &

5. Login to MySQL as root. EDIT: Use original password in "ebox-zarafa.passwd", the one you commented out in step 2

Code:

mysql -u root

6. Replace YOURNEWPASSWORD with your new password!

Code:

 UPDATE mysql.user SET password=password('your new pass') WHERE user='root' AND host='localhost'; FLUSH PRIVILEGES; exit;

sudo /etc/init.d/mysql start