Setting up an MySQL database

[daansk44]

If we set it up like this. Can we access it by multiple regions? Since we have only one master server in one specific region (no problem for me)

[bogordesain]

i got error when login

this my fly.toml

# fly.toml file generated for mysqldb on 2022-08-22T11:09:40+07:00

app = "mysqldb"
kill_signal = "SIGINT"
kill_timeout = 5
processes = []

[env]
  MYSQL_DATABASE = "laravel_data"
  MYSQL_USER = "laravel_user"

[build]
  image = "mysql:8"

[experimental]
  cmd = [
    "--default-authentication-plugin", 
    "mysql_native_password", 
    "--datadir", 
    "/data/mysql"
  ]
[mounts]
  source="sql_data"
  destination="/data"

[fideloper-fly]

Hi!

Did you set a secret for variables MYSQL_ROOT_PASSWORD ? That will set the password for user root specifically. Otherwise you can use username laravel_user and the value for secret MYSQL_PASSWORD.

[bogordesain]

i’m sorry this about memory allocation in my fault. hahhaa