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

1

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?