There's some problems with mysql docker.

[jeonwoosung]

When I start docker, I faced two problem with mysql. One of them is mysql option. I think latest mysql docker doesn't support NO_AUTO_CREATE_USER option. I remove the option, I works.

====================== error log ======================

ERROR: mysqld failed while attempting to check config
command was: "mysqld --character-set-server=utf8 --collation-server=utf8_unicode_ci --default-storage-engine=INNODB --max-sp-recursion-depth=100 --max-allowed-packet=20M --thread-stack=512K --optimizer-search-depth=0 --sql-mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION --verbose --help"

2019-05-08T20:35:41.452227Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2019-05-08T20:35:41.452452Z 0 [ERROR] [MY-000077] [Server] /usr/sbin/mysqld: Error while setting value 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'.
2019-05-08T20:35:41.467993Z 0 [ERROR] [MY-010119] [Server] Aborting

==================================================

After fixed the option, I faced another problem at database setting in Web UI. I cannot find easy way to fix it. But I think it's relate with mysql version. Could anyone specify mysql version instead of latest?

====================== error log ======================
Message: Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory

==================================================

[InsomniumBR]

@jeonwoosung I could go a little bit after that.. I changed my mysql command line to (on docker compose):

command: mysqld --character-set-server=utf8 --collation-server=utf8_unicode_ci --default-storage-engine=INNODB --max-sp-recursion-depth=100 --max-allowed-packet=20M --thread-stack=512K --optimizer-search-depth=0 --sql-mode="NO_ENGINE_SUBSTITUTION" --default-authentication-plugin=mysql_native_password --skip-log-bin

but now struggling with an error on Zurmo installation:

Undefined index: routine_type
The reference id for this error is d27a7d2c16dc4f4182d3e7cf5e8d711a.