# Next cloud - mysql setup | authentication method unknown to the client

**URL:** <https://forums.suse.com/t/next-cloud-mysql-setup-authentication-method-unknown-to-the-client/17478>\
**Category:** General\
**Created:** [May 17, 2020, 9:30am UTC](https://forums.suse.com/t/next-cloud-mysql-setup-authentication-method-unknown-to-the-client/17478 "2020-05-17T09:30:36Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Somayyah](https://avatars.discourse-cdn.com/v4/letter/s/a88e4f/32.png) [@Somayyah](https://forums.suse.com/u/Somayyah)\
**Post date:** [May 17, 2020, 9:30am UTC](https://forums.suse.com/t/next-cloud-mysql-setup-authentication-method-unknown-to-the-client/17478/1 "2020-05-17T09:30:36Z")

</div>

Good morning/evening

Using the rancher GUI, I’m trying to set up Nextcloud with MySQL database workloads. In the environment variables, I already have defined the admin user and password so why do I get this error on the create admin page?

> Error while trying to create admin user: Failed to connect to the database: An exception occurred in driver: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client

I entered the Username and password correctly  
Bellow are my configurations for the database and nextcloud so far.

##### database workload:

- Name: nextdb
- Docker image: mysql
- port: not set I have the following variables:

> MYSQL\_ROOT\_PASSWORD=rootpassX  
> MYSQL\_DATABASE=nextDB  
> MYSQL\_USER=nextcloud  
> MYSQL\_PASSWORD=passX

- volumes configuration:

> Volume Type: Bind-Mount  
> Volume Name: nextdb  
> Path on the Node : /nextdb  
> The Path on the Node must be: a directory or create  
> Mount Point: /var/lib/mysql

##### nextcloud workload:

Name: nextcloud  
Docker Image: nextcloud  
Port Mapping:

> Port Name : nextcloud80  
> Publish the container port: 80  
> Protocol: TCP  
> As a: Layer-4 load balancer  
> On listening port: 80

Environment variables:

> MYSQL\_DATABASE=nextDB  
> MYSQL\_USER=nextcloud  
> MYSQL\_PASSWORD=passX  
> MYSQL\_HOST=nextdb  
> NEXTCLOUD\_ADMIN\_USER=admin  
> NEXTCLOUD\_ADMIN\_PASSWORD=adminPass  
> NEXTCLOUD\_DATA\_DIR=/var/www/html/nextcloud

Volumes:

> Volume 1:
> 
> - name: nextcloud
> - Volume Type: Bind-Mount
> - Path on the Node: /nextcloud
> - The Path on the Node must be: a directory or create.
> - Mount Point: /var/www/html

> Volume 2:
> 
> - name: nextdb
> - Volume Type: Bind-Mount
> - Path on the Node: /nextdatabase
> - The Path on the Node must be: a directory or create.
> - Mount Point: /var/lib/mysql

What are the problems with my configurations?