yesterday I had the need to perform database action on a Univention 4.2 system with Kopano installed as an app.
According to this entry
After the installation of MySQL, there will be a /etc/mysql.secret file with the mysql root pw. Well, not in our case.
We installed UCS 4.2 from the ISO, updated all packages via the Management Console, and also installed Kopano via App center. Although we received no error message, the above mentioned file is not there.
Cross verified with another Univention system, there the file exists.
I have no idea what went different on this system, or how to fix the problem. Also I have not found another way to see which MySQL Root PW is set.
Would someone point me to
a) how to troubleshoot what went wrong where during installation
b) how to access mysql -u root -p