Brutally brief: Create a new database and or user in MYSQL

Log in:

mysql -u root -p

Create a user:

create user 'newuser'@'localhost' IDENTIFIED BY 'password';

Give them all the power:

grant all privileges on * . * TO 'newuser'@'localhost';

Reload privileges:

flush privileges;

Ditch a user: (Optional)

drop user 'newuser'@'localhost';

Log out:

\q

—————-

Log in:

mysql -u newuser -p

Create a database for the user:

create database db_name;

List databases: (Optional)

show databases;

Ditch database: (Optional)

drop database db_name;

Log out:

\q

Done.

Resetting a user’s password in NextCloud

Resetting a lost admin password

The normal ways to recover a lost password are:

  1. Click the password reset link on the login screen; this appears after a failed login attempt. This works only if you have entered your email address on your Personal page in the Nextcloud Web interface, so that the Nextcloud server can email a reset link to you.
  2. Ask another Nextcloud server admin to reset it for you.

If neither of these is an option, then you have a third option, and that is using the occ command. See Using the occ command to learn more about using the occ command.

$ sudo -u www-data php /var/www/nextcloud/occ user:resetpassword admin
Enter a new password:
Confirm the new password:
Successfully reset password for admin

If your Nextcloud username is not admin, then substitute your Nextcloud username.

unRAID docker: /config/www/nextcloud
unRAID user: abc

$ sudo -u abc php /config/www/nextcloud/occ user:resetpassword admin