How do I properly and correctly set up NextCloud?
The tutorials I've been able to find for setting up NextCloud through the one click market are out of date because they no longer reflect the sign-up in its present state. Even with the tutorials being out of date, it looks simple enough to figure out. Unfortunately, I have a problem. Even though I set up NextCloud with all of the required options and a lot of generally good to have options, when I try to finalize the NextCloud setup and create the admin account, I am greeted with this:
Error while trying to create admin user: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [1698] Access denied for user 'nextcloud'@'localhost'
I have tried including the default MySQL port. I have tried not including any port. I use a very specific password copied into my clipboard as plain text. Is there an up to date tutorial explaining what specific steps I must take to set up NextCloud without encountering this error?
4 Replies
hphillips
Linode Staff
I was able to follow along with the following guide:
I was not able to reproduce the issue you are experiencing. If you are following the above guide the admin account should be created for you.
Can you clarify what guides you are following and I'll gladly take a look.
I'm referring to this guide here: https://www.linode.com/docs/guides/how-to-configure-nextcloud-to-use-linode-object-storage-as-an-external-storage-mount/
After following the instructions in your link I wound up exactly where I was before.
For whatever reason, when I go to Nextcloud it doesn't give me the option of just logging in the way it shows in the tutorial you linked, it wants me to create an admin account and finish the installation. The admin account is not automatically created, the installation is not automatically handled.
Do the options I set on the Linode API have anything to do with this? I have it set to only allow domains as per the Gardner Bryant video. Does the SSH key I entered have anything to do with this? Should I leave that blank instead?
Did you ever get this solved @MightyMurderMittens? I am having this issue too. Have SSH'd into the machine to try sorting out permissions but not got anything working yet.
UPDATE:
I got this working after SSH-ing into my nanode and doing the following:
To get into the MySQL/MariaDB monitor
sudo mariadb
In the following, assume the database is called nextcloud_db and the db user is also called nextcloud_db_user. For the password, use whichever password you gave the nextcloud_db_user user:
GRANT ALL PRIVILEGES ON nextcloud_db.* TO 'nextcloud_db_user'@'localhost' IDENTIFIED BY 'randompassword';
FLUSH PRIVILEGES;