Setting up an MySQL database

How To
21

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)

22

i got error when login

Jepretan Layar 2022-08-22 pukul 11.21.52
Jepretan Layar 2022-08-22 pukul 11.21.521696×404 182 KB

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"
23

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.

24

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

1 Like