mysql 8.0 fails on pipelines

Question

I have problem with pipelines and mysql 8

I have mysql service in my pipelines:

definitions:
services:
mysql:
image: mysql:8.0.4 #loselesslive/mysql8, jasonmu/mysql-native-password
      command: ['--character-set-server=utf8mb4', '--collation-server=utf8mb4_unicode_ci','--default-authentication-plugin=mysql_native_password', 'sed -i '/^$$mysqld$$$/a\default-authentication-plugin=mysql_native_password' /etc/my.cnf']
restart: always
ports:
        - "3306:3306"
      environment:
TZ: Europe/Vilnius
MYSQL_DEFAULT_AUTH: 'mysql_native_password'
        MYSQL_DATABASE: 'homestead'
        MYSQL_ROOT_PASSWORD: 'secret'
        MYSQL_USER: 'homestead'
        MYSQL_PASSWORD: 'secret'

when i run pipeline i got error "Connect Error: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client" like in

https://stackoverflow.com/questions/52364415/the-server-requested-authentication-method-unknown-to-the-client-php
https://github.com/laradock/laradock/issues/1390
https://github.com/laradock/laradock/issues/1392

if i could run script to run sql and command line i can fix it but  how?

ibushong · Answer

This should be fixed so that we don't have to use a custom container. I'm very surprised more people aren't complaining about this. Is no one using MySQL v8?

Shane Niebergall · Answer

Thank you Julius, after hours of searching many forums, yours is the only one working for me.

Julius Šmatavičius · Answer

yes, it works

i use such config

definitions:
services:
mysql:
image: bondas83/mysql-native-password
environment:
MYSQL_DATABASE: 'testing'
        MYSQL_ROOT_PASSWORD: 'secret'
        MYSQL_USER: 'homestead'
        MYSQL_PASSWORD: 'secret'