I am trying to install nextcloud but canât get past the Install Wizard.
I have successfully installed owncloud twice on this server, so am a bit confused as to why the installation is not working now.
Here is my error message:
Error
Error while trying to create admin user:
Failed to connect to the database: An
exception occured in the driver:
SQLSTATE[28000][1045] Access denied for
user ârootâ@âlocalhostâ (using password: YES)
Any thoughts? Iâve logged into mysql to double check my password, so itâs hard to believe thatâs the issue.
It seems I Have the same issue: same error message ⌠and sorry but no solution !
My installation is on a remote web space.
Web server is Apache
DB client version is libmysql - mysqlnd 5.0.12-dev - 20150407
PHP version is 7.0.10-1~dotdeb+8.1
DB server is MySQL-MariaDB 5.5.42-MariaDB-cII-Ive.
I had the same message when I first tried to install owncloud (8.2 I think) a few months ago, and couldnât solve it - neither on owncloudâs forums neither on my webspace providerâs helpdesk - untill came ownCloud 9.0.1.
It happened since (in July) thaty my owncloud occurence crashed ⌠so I considered going to nextcloud but tried first to make a new install of owncloud 9.2.
But both attempts (with owncloud 9.2 and with nextcloud 10.0.0 come to the same error message !
Has anybody be able to find a solution? I believe this is a bug.
All my versions are within the requirements.
I can connect via mysql client to the database machine without problems. With the root account and with an special nextcloud admin user. Iâm also hosting an Owncloud 8 istance DB. I tried that user too and didnât worked. I have also installed several Wordpress sites and I have had never a connection problem until now with Nexcloud.
I have tried some solutions such like âchange Mariadb password without any special characters (#$%*!@âŚâ, add âbinlog_format=mixed and
transaction-isolation=READ-COMMITTED into my.cnf under [mysqld] sectionâ
I can sign on mariadb via in terminal and I can access phpMyAdmin.
But I donât know why I get the following error message:
Error while trying to create admin user: Failed to connect to the database: An exception occured in driver: SQLSTATE[HY000] [1045] Access denied for user âadminâ@âlocalhostâ (using password: YES)
I donât see any error message in db log and nextcloud.log is empty under data folder.
Please help me, I would like to setup my own cloud.
Hi,
Try with the masks turned on for the pass fields. The passwords should not be visible and it works for me.
Please, donât ask me how much time did it take me with an installation, which worked accidentally. At the end I believed I fixed it doing some magic commands, changing the authentication plugin with these commands (substitute the user/pass fields):
mysql -u root -p
UPDATE mysql.user SET authentication_string = PASSWORD(âputyourpasswordhereâ), plugin = ââ WHERE User = ânextclouduserOrYourUserâ AND Host = âlocalhostâ;
flush privileges;
exit;
Now Iâm doing another installation and after doing these commands, it didnât work. Then I thought if the masks I turned off for the password fields (so Iâm sure the passwords are right) are braking things and sending the wrong passwords. So I turned them back on and it worked.
I suppose the above commands are not necessary, but will be glad if someone confirms.
Installing new Nextcloud 11.0.0 on Ubuntu 16.04.1 brand new installation.