I’m doing a new install of Nextcloud 18 on a Synology with MariaDB10 and PHP 7.3.
I used PhpMyAdmin to create a new user “nc” and a new db “nc” where user “nc” got all privileges.
At initial setup up screen of Nextcloud I enter an admin login and psw for Nextcloud and MariaDB info:
psw: the password created while I create nc user in PhpMyAdmin
host: localhost:3307 (MariaDB port, as I still have an old MariaDB5 running)
Then I always got this error:
Error while trying to create admin user: Failed to connect to the database: An exception occurred in driver: SQLSTATE[HY000]  Access denied for user ‘nc’@‘localhost’ (using password: YES)
I found a couple of post quoting this error but none provide a viable solution. I’m getting crazy, I did create and drop the db many time, select shorter password (but always with special character as requested by my db policy).
First I didn’t specified the port on localhost and was sure it was the reason because I have both MariaDB5 and 10 on the same server, but it’s not the issue.
Any help would be welcome.