If you ever get locked out of your nextcloud account and have not way of resetting through the web interface you can use the command line option.
Basically connect via terminal or SSH, navigate to your the installation directory of Nextcloud and execute the following command.
sudo -u www-data php /var/www/html/nextcloud/occ user:resetpassword username
Been looking this is solution for ages! Finally got it!
Usually the default username and password for Xbian is
But in this scenario its different.
Device: Raspberry Pi 3
OS: Xbian 1.0
Software: Kodi 17.0
Quick and small howto, how to create a new MySQL database with an associated username and password with full access to that database.
CREATE USER 'traxuser'@'localhost' IDENTIFIED BY 'traxpassword';
create database traxdb;
GRANT ALL PRIVILEGES ON traxdb . * TO ' traxuser'@'localhost