Creating Admin account failed

🚧 Installation
1

Hi Folks,

I have nextcloud installed at strato.de. Finally i´m asked to create a Admin account. But nextcloud is trying to login at the database as user Uxxxxxxx@flim.store.d0m.de but the databaseuser is Uxxxxxxx@hirrwi.store.d0m.de. Where can i find the file to change the adress.

Thanks for any help

Harald

2

Hello

Maybe that can help.

Pleace check the Folder nextcloud/config and edit the file > config.php

change: -> // for comment
//‘dbname’ => 'nextcloud_old_dbname‘,
‘dbname’ => 'nextcloud_new_dbname‘,

//‘dbhost’ => ‘nextcloud_old_dbhost’,
‘dbhost’ => ‘nextcloud_new_dbhost’’,

and try again

3

Hallo ham,

thank´s for your quick replay.
Unfortunately my config.php looks like this and there is no link to “U1234567@flim.store.d0m.de”

<?php $CONFIG = array ( 'instanceid' => 'xxxxxxxxxxxxxxxx', 'passwordsalt' => 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx', 'secret' => 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx', 'trusted_domains' => array ( 0 => 'www.xxxxxxxxxxx.xxx', ), 'datadirectory' => '/mnt/xxxxxxxxxxxxxxxxxx/htdocs/nextcloud/nextcloud/data', 'overwrite.cli.url' => 'http://xxx.xxxxxxxxxxx.xxx/nextcloud/nextcloud', 'dbtype' => 'mysql', 'version' => '11.0.0.10', 'dbname' => 'DB1234567', 'dbhost' => 'rdbms.strato.de', 'dbport' => '', 'dbtableprefix' => 'oc_', );

The complete error message while trying to create admin user is:

Error while trying to create admin user:
Failed to connect to the database: An
exeption occured in driver:
SQLSTATE[280001045] Access denied for user U1234567@flim.store.d0m.de
(using password:YES)

but my DB-user has to be U1234567@hirrwi.store.d0m.de <<<— This is on strato the correct user

Databseserver on strato:

  • Server: rdbms via TCP/IP

  • Server-Typ: MySQL

  • Server Version: 5.6.35-log - Source distribution

  • Protokoll-Version: 10

  • Benutzer: U1234567@hirrwi.store.d0m.de

  • Server Zeichensatz: UTF-8 Unicode (utf8)

Thanks for any help

Harald

4

Hi
try that.

‘dbname’ => ‘DB1234567’,
‘dbhost’ => ‘hirrwi.store.d0m.de’,
‘dbtableprefix’ => ‘oc_’,
‘dbuser’ => ‘U1234567’,
‘dbpassword’ => ‘xyz_password_something’,

without -> dbport

check your access premission: user@localhost or user@127.0.0.1 or user@hirrwi.store.d0m.de -> all string after @ should be your server.

very important: if you have done an update from eg. owncloud, you have to copie the config file and modify because the salt, secret and isntanceid should be de same

5

Hi ham,

I got it.
The only thing what was missed.

The string “dbuser’ => ‘U1234567’” Was not set automatically in the config.php
After i have done this it works.

Thanks for your help

Have a nice day

Harald