MySQL

MySQL is a popular open-source relational database management system (RDBMS).

Getting started

# In `perSystem.process-compose.<name>`
{
  services.mysql."mysql1".enable = true;
}

Tips & Tricks

Use a different port

{
  services.mysql."mysql1" = {
    enable = true;
    settings.mysqld.port = 3307;
  };
}

Multiple .sql files for schema

The schema can be a path to a single .sql file or a directory containing multiple .sql files.

{
  services.mysql."mysql1" = {
    enable = true;
    initialDatabases = [{ name = "test_database"; schema = ./test_schemas; }];
  };
}