QNAP MySQL container: "You need to specify one of the following as an environment variable"

Question

In my QNAP NAS, I've installed a MySQL container, but after trying to start it, there is a console error:

You need to specify one of the following as an environment variable: MYSQL_ROOT_PASSWORD, MYSQL_ALLLOW_EMPTY_PASSWORD, _MYSQL_RANDOM_ROOT_PASSWORD.

I can't see any way to configure the container with such variables. I can see the configuration in Inspect, but this is not editable. Separate to Inspect, if I click Edit, I cannot add any such variable.

If I click Attach Terminal, there is an error "Container not running", and I can't start the container due to the error above.

Help appreciated.

Answer 1

As we got in comment, when creating MySQL container there should be Environment section in Advanced Settings, there you can specify for example MYSQL_ROOT_PASSWORD and value root

Before creating any container I encourage your to read documentation on https://hub.docker.com, in this case it will be https://hub.docker.com/_/mysql. There you can find many information that will help you to prepare it correctly