Hi all,
I have a strange problem when I try installing Nextcloud 13 on my VM
Well, I dont speak fluently your language, I try to explain you better than I can…
-
I create a VM With ubuntu 18.04 and only MariaDB (latest stable version) (VM1 and ip = 192.168.vm1…)
I’ll create one user for each Vm needed with all privileges on databases from his VM and IP of this VM -
I use
mysql_secure_installation
-
I create another VM (VM2) with ubuntu 18.04 and nginx, php 7.2 and I installed an application using php and mariadb
==> This VM can use internet connexion and have an https dommaine
==> It’s working fine -
I create new VM (VM3) with ubunto 18.04 and ngnx and php7.2 and I installed Nextcloud 13
=> I follow all indication and I have an https domaine
=> First page to install is on my screen…
=> On MariaDB VM, I create a user for Nextcloud database with all provileges on ‘nextcloud’ database
When I type select user,host from mysql.user;
I have just
- ‘root’@‘locahost’
-‘VM1user’@‘192.162.vm1’
-‘NC_user’@‘192.162.9.5’
On form I type :
Admin Nextcloud => Sylvain (me )
Password => my password
User database => NC_user
Password => NC_user Password
Database => nextcloud
Host : 192.168.9.3:3306 (Ip of mariaDB VM)
- After all this operation I have :
Erreur
Error while trying to create admin user: Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [1044] Access denied for user ‘oc_Sylvain’@‘%’ to database ‘nextcloud’
First question : Why Nextcloud create user ‘oc_Sylvain’@‘localhost’ and oc_Sylvain’@‘%’ on mariaDB ?
Second question : How to forced Nextcloud to use NC_user ?
Thanks very much for reading all this.
Regards
Sylvain
PS : I looked for all post this Access denied, but don’t find for my problem