Easy way to test mysql initialscript?

hansemschnokeloch · March 23, 2023, 7:39am

Hi,

Is there an easy way to run mysql initialscript at each build (in order to tune up a nixos configuration)?

Currently I’m creating the file /var/lib/mysql/mysql_init each time, but I’m wondering if there’s a more convienent way.

github.com

NixOS/nixpkgs/blob/3268859e68c056725359ebc8315695d26c95fb6b/nixos/modules/services/databases/mysql.nix#L395

    
      
                    echo "Tried 30 times, giving up..."
                    exit 1
                fi
          
          
      echo "MySQL daemon not yet started. Waiting for 1 second..."
                count=$((count++))
                sleep 1
            done
          ''}
          
          
if [ -f ${cfg.dataDir}/mysql_init ]
          then
              # While MariaDB comes with a 'mysql' super user account since 10.4.x, MySQL does not
              # Since we don't want to run this service as 'root' we need to ensure the account exists on first run
              ( echo "CREATE USER IF NOT EXISTS '${cfg.user}'@'localhost' IDENTIFIED WITH ${if isMariaDB then "unix_socket" else "auth_socket"};"
                echo "GRANT ALL PRIVILEGES ON *.* TO '${cfg.user}'@'localhost' WITH GRANT OPTION;"
              ) | ${cfg.package}/bin/mysql -u ${superUser} -N
          
          
    ${concatMapStrings (database: ''
                # Create initial databases
                if ! test -e "${cfg.dataDir}/${database.name}"; then