title: Next cloud and mysql setup: authentication method unknown to the client
body: <p>Using the rancher GUI, I'm trying to set up Nextcloud with MySQL database workloads on my AKS cluster. 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?</p>
  <blockquote>
  <p>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</p>
  </blockquote>
  <p>I entered the Username and password correctly multiple times.
  Below are my configurations for the database and nextcloud so far.</p>
  <p><strong>database workload:</strong></p>
  <pre><code>Name: nextdb
  Docker image: mysql
  port: not set
  </code></pre>
  <p>I have the following variables:</p>
  <pre><code>MYSQL_ROOT_PASSWORD=rootpassX 
  MYSQL_DATABASE=nextDB
  MYSQL_USER=nextcloud
  MYSQL_PASSWORD=passX
  </code></pre>
  <ul>
  <li>volumes configuration:</li>
  </ul>
  <blockquote>
  <p>Volume Type: Bind-Mount</p>
  <p>Volume Name: nextdb</p>
  <p>Path on the Node : /nextdb</p>
  <p>The Path on the Node must be: a directory or create</p>
  <p>Mount Point: /var/lib/mysql</p>
  </blockquote>
  <p><strong>nextcloud workload:</strong></p>
  <ul>
  <li><p>Name: nextcloud</p>
  </li>
  <li><p>Docker Image: nextcloud</p>
  </li>
  <li><p>Port Mapping:</p>
  <p>Port Name : nextcloud80
  Publish the container port: 80
  Protocol: TCP
  As a: Layer-4 load balancer
  On listening port: 80</p>
  </li>
  <li><p>Environment variables:</p>
  <p>MYSQL_DATABASE=nextDB</p>
  <p>MYSQL_USER=nextcloud</p>
  <p>MYSQL_PASSWORD=passX</p>
  <p>MYSQL_HOST=nextdb</p>
  <p>NEXTCLOUD_ADMIN_USER=admin</p>
  <p>NEXTCLOUD_ADMIN_PASSWORD=adminPass</p>
  <p>NEXTCLOUD_DATA_DIR=/var/www/html/nextcloud</p>
  </li>
  <li><p>Volumes:</p>
  </li>
  </ul>
  <p>Volume 1:</p>
  <pre><code>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
  </code></pre>
  <p><strong>Volume 2</strong></p>
  <pre><code>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
  </code></pre>
  <p>What are the problems with my configurations?</p>