I’m following the second method of this tutorial
to install NextCloud on my Pi.
When I get to this step:
Give all permissions to the new user on this database
Code: Select all
GRANT ALL PRIVILEGES ON nextcloud.* TO ‘nextcloud’@localhost IDENTIFIED BY ‘XXX’;
I get an error saying “you have an error in your syntax – check your version of MariaDB’s manuals.” I’ve copy-pasted the command exactly except to change the XXX to the password I chose in the previous step. I did not remove the single quote marks. Unfortunately I’m not familiar with MariaDB and although I did consult their manuals, I haven’t yet figured it out. I also tried IDENTIFIED BY PASSWORD which was in their manual and that didn’t work either. I’ve reached out to the author in the comments (my comment is still awaiting moderation approval) but I figured it’s a holiday and he might be busy, and perhaps someone here could get to it sooner.