Error with docker-compose.yml

[meigea]

I have tried it with docker-cmd-line like docker run -ti -e .... and run well, but run bad with docker-compose

My-docker-compose

  mysql:
    container_name: mysql-server
    image: 'sameersbn/mysql:5.7.22-1'
    restart: always
    container_name: mysql
    volumes:
      - /srv/docker/data/mysqldata:/var/lib/mysql
    ports:
      - '3306:3306'
    environment:
     - DB_USER=admin007
     - DB_PASS=myadmin@816
     - DB_NAME=djsite
     - DB_REMOTE_ROOT_NAME=root
     - DB_REMOTE_ROOT_PASS=meigea@123
     - MYSQL_CHARSET=utf8mb4
     - MYSQL_COLLATION=utf8_bin

the log of Error

mysql exited with code 1
mysql          | Creating database "djsite"...
mysql          | ERROR 1253 (42000) at line 1: COLLATION 'utf8_bin' is not valid for CHARACTER SET 'utf8mb4'
mysql          | Creating database "djsite"...
mysql          | ERROR 1253 (42000) at line 1: COLLATION 'utf8_bin' is not valid for CHARACTER SET 'utf8mb4'
mysql          | Creating database "djsite"...
mysql          | ERROR 1253 (42000) at line 1: COLLATION 'utf8_bin' is not valid for CHARACTER SET 'utf8mb4'
mysql          | Creating database "djsite"...
mysql          | ERROR 1253 (42000) at line 1: COLLATION 'utf8_bin' is not valid for CHARACTER SET 'utf8mb4'
mysql          | Creating database "djsite"...
mysql          | ERROR 1253 (42000) at line 1: COLLATION 'utf8_bin' is not valid for CHARACTER SET 'utf8mb4'
mysql          | Creating database "djsite"...
mysql          | ERROR 1253 (42000) at line 1: COLLATION 'utf8_bin' is not valid for CHARACTER SET 'utf8mb4'
mysql          | Creating database "djsite"...
mysql          | ERROR 1253 (42000) at line 1: COLLATION 'utf8_bin' is not valid for CHARACTER SET 'utf8mb4'
mysql          | Creating database "djsite"...
mysql          | ERROR 1253 (42000) at line 1: COLLATION 'utf8_bin' is not valid for CHARACTER SET 'utf8mb4'
mysql          | Creating database "djsite"...
mysql          | ERROR 1253 (42000) at line 1: COLLATION 'utf8_bin' is not valid for CHARACTER SET 'utf8mb4'

[nguyenl95]

@meigea It looks like character set doesn't support collation. You may consider to use default repo's charset and collation utf8 and utf8_unicode_ci.