[Bug] set MySQL visibility will not use VISIBILITY_MYSQL_USER/VISIBILITY_MYSQL_PWD

[onesaltedseafish]

What are you really trying to do?

I'm trying to set a seperate user and password for visibility, but I got:

temporal              | 2024-08-11T06:38:32.751Z        ERROR   Unable to create SQL database.  {"error": "Error 1044: Access denied for user 'temporal'@'%' to database 'temporal_visibility'", "logging-call-at": "handler.go:94"}

Describe the bug

I find the visibility.sql.user will not be used when init the temporal_visibility database. Can see the process in https://github.com/temporalio/docker-builds/blob/main/docker/auto-setup.sh#L172C1-L172C19 .

Minimal Reproduction

Environment/Versions

• OS and processor: [x86 Linux]
• Temporal Version: [1.24.2]
• Are you using Docker or Kubernetes or building Temporal from source? Docker

Additional context

Just use a different user for database temporal and temporal_visibility.