import (
	"github.com/dolthub/go-mysql-server/auth"
	"github.com/dolthub/go-mysql-server/memory"
	"github.com/dolthub/go-mysql-server/server"
	"github.com/dolthub/go-mysql-server/sql"
	"github.com/dolthub/go-mysql-server/sql/information_schema"
)

func main() {
	engine := sqle.NewDefault(
		sql.NewDatabaseProvider(
			memory.NewDatabase(TEST_DB_MYSQL_DATABASE),
			information_schema.NewInformationSchemaDatabase(),
		),
	)
	s, err := server.NewDefaultServer(server.Config{
		Protocol: "tcp",
		Address:  "127.0.0.1:3306",
		Auth:     auth.NewNativeSingle(TEST_DB_MYSQL_USER, TEST_DB_MYSQL_PASSWORD, auth.AllPermissions),
	}, engine)
	if err != nil {
		panic(err)
	}
	s.Start()
}

mysql> CREATE TABLE gizmos (id serial);
ERROR 1105 (HY000): syntax error at position 31 near 'serial'
mysql>