installing nextcloud 12I received the following error message on the last page of the wizard::
Error while trying to create admin user:
Failed to connect to database An exception occurred in the driver
ERROR [HY000] [1698] Access denied for user ârootâ@âlocalhostâ !
I found out that the password for the NEXTCLOUD Admin (pw1) will be superseded with the SQL Password (pw2).
Very strange, that these passwords will be mixed up!
You must use non-root mysql user for Nextcloud. Try this commands with mysql command line:
create database nextclddb;
create user ânextcloudâ identified by âfkxvnds123rwerâ;
grant all on nextclddb.* to ânextcloudâ identified by âfkxvnds123rwerâ;
flush privileges;
(In this case ânextclddbâ is your mysql database for nextcloud use, ânextcloudâ is mysql user of this database, and âfkxvnds123rwerâ is password of this user).
PS: in some mysql realisations (ie percona etc) password must be strong.
If you have problems with your database when connecting via terminal and resetting passwords, this is clearly not an issue of Nextcloud and people here are not the best skilled on debian-related upgrade issues. In your place, I would try the debian community and try to make work my webserver with php and *sql first (phpmyadmin should run properly).