Error creating root user

[lupa18]

This is the error:
[Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.

and my docker-compose file says:

db:
  image: mysql:latest
  restart: unless-stopped
  environment:
    MYSQL_ROOT_PASSWORD: mypassword
  volumes:
    - db:/var/lib/mysql

[yosifkit]

That is just a warning printed by during database file initialization (mysqld --initialize-insecure). The root user with password is created later while the database is listening only on the unix socket.

[tmciver]

This is very unfortunate. It's misleading and caused me to lose a lot of time. Please consider suppressing this message.

[tianon]

If there were a simple way to suppress this warning without also suppressing other potentially important messages, we'd be happy to.

[tomuench]

Thanks for this thread. Please surpress the message :-)

[XNerv]

Thanks for this thread tooo. Please surpress the message :-)

[tianon]

If there were a simple way to suppress this warning without also suppressing other potentially important messages, we'd be happy to.

With the current MySQL implementation, we literally cannot suppress this message, sorry. If that changes, we'd absolutely love to do so.