Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection?

Question

[Сергей Бурдужа]

Всем привет.
Система Ubuntu 23.04
Не могу подключиться к mysql.
docker-compose.yml

mysql:
    container_name: mysql_laravel9
    image: mysql:8
    restart: always
    environment:
      - "MYSQL_ROOT_PASSWORD=Serii1981;"
    volumes:
      - "./docker/mysql:/var/lib/mysql"
    ports:
      - "33062:3306"

Пытаюсь подключиться к mysql из терминала

❯ mysql -h 127.0.0.1 -P 33062 -u root -p
Enter password: 
ERROR 2061 (HY000): Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection.
❯ mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 343
Server version: 8.0.35-0ubuntu0.23.04.1 (Ubuntu)

Copyright (c) 2000, 2023, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Serii1981;';
Query OK, 0 rows affected (0.01 sec)
mysql> exit;
Bye


❯ sudo service mysql stop
sudo service mysql start

❯ mysql -h 127.0.0.1 -P 33062 -u root -p
Enter password: 
ERROR 2061 (HY000): Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection.

Помогите разобраться почему не работает.

Заранее благодарен.

Comments

[Владислав Лысков]

пробуй

environment:
      MYSQL_ROOT_USER: root
      MYSQL_ROOT_PASSWORD: secret
      MYSQL_PASSWORD: secret

[Сергей Бурдужа]

Владислав Лысков, спасибо за ответ, завтра на работе попробую, отпишусь

[Сергей Бурдужа]

Владислав Лысков,
Не хочет.

mysql:
    container_name: mysql_laravel9
    image: mysql:8
    restart: always
    environment:
      # - "MYSQL_ROOT_PASSWORD=root;"
      MYSQL_ROOT_USER: root
      MYSQL_ROOT_PASSWORD: secret
      MYSQL_PASSWORD: secret
    volumes:
      - "./docker/mysql:/var/lib/mysql"
    ports:
      - "33062:3306"

❯ mysql -h 127.0.0.1 -P 33062 -u root -p
Enter password: 
ERROR 2061 (HY000): Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection.

Answer 1

[Сергей Бурдужа]

Все решил проблему.
Во первых нужно выключить контейнеры.
docker-compose down

Удалить образ mysql

docker images
docker rmi image_id

Новый docker-compose.yml который работает и с phpmyadmin

# Use root/example as user/password credentials
version: '3.1'

services:
  nginx:
    container_name: nginx_laravel9
    build:
      context: .
      dockerfile: docker/nginx.docker
    volumes:
      - ./:/var/www
      # - ./docker/nginx/ssl:/etc/nginx/ssl
    ports:
      - "8088:80"
    links:
      - php-fpm

  php-fpm:
    container_name: php_laravel9
    build:
      context: .
      dockerfile: docker/php/Dockerfile
    restart: unless-stopped
    tty: true
    working_dir: /var/www
    volumes:
      - ./:/var/www
      - ./docker/php/local.ini:/usr/local/etc/php/conf.d/local.ini
    links:
      - mysql

  mysql:
    container_name: mysql_laravel9
    image: mysql:8.3.0
    restart: always
    environment:
      # MYSQL_ROOT_USER: root
      # MYSQL_ROOT_PASSWORD: root
      MYSQL_PASSWORD: root
    volumes:
      - "./docker/mysql:/var/lib/mysql"
    ports:
      - "33062:3306"
    command: --authentication_policy=mysql_native_password

  phpmyadmin:
    image: phpmyadmin/phpmyadmin
    container_name: phpmyadmin_laravel9
    restart: always
    ports:
     - '8084:80'
    environment:
      MAX_EXECUTION_TIME: 600
      UPLOAD_LIMIT: 800M
      PMA_HOST: mysql
      PMA_PORT: 3306
      PMA_ARBITRARY: 1
    depends_on:
     - mysql

Пароль от mysql
root
root

Пароль от phpmyadmin берется от mysql
Там у меня 3 поля
mysql
root
root

Блин, целый день убил на это.