package com.komanov.mysql.streaming

import com.wix.mysql.EmbeddedMysql
import com.wix.mysql.EmbeddedMysql._
import com.wix.mysql.config.Charset
import com.wix.mysql.config.MysqldConfig._
import com.wix.mysql.config.SchemaConfig._
import com.wix.mysql.distribution.Version

object MysqlRunner {

  System.setProperty("user.home", System.getenv("TEST_TMPDIR"))

  private lazy val mysql: EmbeddedMysql = {
    val config = aMysqldConfig(Version.v5_6_latest)
      .withPort(Drivers.Port)
      .withUser(Drivers.UserName, Drivers.Password)
      .withCharset(Charset.UTF8MB4)
      .build()

    val mysqld = anEmbeddedMysql(config)
      .start()

    mysqld.addSchema(
      aSchemaConfig(Drivers.DataBase)
        .withCommands(Query.CreateSql)
        .build()
    )

    mysqld
  }

  def run(): Unit = {
    mysql.toString
  }

}

package com.komanov.mysql.streaming

import com.wix.mysql.EmbeddedMysql
import com.wix.mysql.EmbeddedMysql._
import com.wix.mysql.config.Charset
import com.wix.mysql.config.MysqldConfig._
import com.wix.mysql.config.SchemaConfig._
import com.wix.mysql.distribution.Version

object MysqlRunner {

  private lazy val mysql: EmbeddedMysql = {
    val config = aMysqldConfig(Version.v5_6_latest)
      .withPort(Drivers.Port)
      .withUser(Drivers.UserName, Drivers.Password)
      .withCharset(Charset.UTF8MB4)
      .build()

    val mysqld = anEmbeddedMysql(config)
      .start()

    mysqld.addSchema(
      aSchemaConfig(Drivers.DataBase)
        .withCommands(Query.CreateSql)
        .build()
    )

    mysqld
  }

  def run(): Unit = {
    mysql.toString
  }

}

--- 
+++ 
@@ -8,6 +8,8 @@
 import com.wix.mysql.distribution.Version
 
 object MysqlRunner {
+
+  System.setProperty("user.home", System.getenv("TEST_TMPDIR"))
 
   private lazy val mysql: EmbeddedMysql = {
     val config = aMysqldConfig(Version.v5_6_latest)
Set user.home to TEST_TMPDIR (user.home is used inside wix-embedded-mysql library)
