This morning I was trying to install OwnCloud on a Zentyal 4.0 server. The only problem that I found was with finding the root password for mysql to create the OwnCloud database.
I found the solution on THIS site.
The solution was way too simple it was literally to run the comand below which displays the password on screen.
echo $(sudo cat /var/lib/zentyal/conf/zentyal-mysql.passwd)