In MYSQL mode, wrong column types are generated

export const auth = betterAuth({
    database: drizzleAdapter(db, {
        provider: "mysql",
        usePlural: true,
    }),
    secret: env.BETTER_AUTH_SECRET,
    emailAndPassword: {
        enabled: true,
    },
    plugins: [bearer()],
    trustedOrigins: [env.CLIENT],
});

export const auth = betterAuth({
    database: drizzleAdapter(db, {
        provider: "mysql",
        usePlural: true,
    }),
    secret: env.BETTER_AUTH_SECRET,
    emailAndPassword: {
        enabled: true,
    },
    plugins: [bearer()],
    trustedOrigins: [env.CLIENT],
});

export const users = mysqlTable("users", {
    id: varchar("id", { length: 36 }).primaryKey(),
    ...
});

export const accounts = mysqlTable("accounts", {
        ...
    userId: text("user_id", )
        .notNull()
        .references(() => users.id, { onDelete: "cascade" }),
});

export const users = mysqlTable("users", {
    id: varchar("id", { length: 36 }).primaryKey(),
    ...
});

export const accounts = mysqlTable("accounts", {
        ...
    userId: text("user_id", )
        .notNull()
        .references(() => users.id, { onDelete: "cascade" }),
});

Error: Referencing column 'user_id' and referenced column 'id' in foreign key constraint 'accounts_user_id_users_id_fk' are incompatible.

Error: Referencing column 'user_id' and referenced column 'id' in foreign key constraint 'accounts_user_id_users_id_fk' are incompatible.

export const sessions = mysqlTable("sessions", {
        ...
    userId: varchar("user_id", { length: 36 })
        .notNull()
        .references(() => users.id, { onDelete: "cascade" }),
});

export const sessions = mysqlTable("sessions", {
        ...
    userId: varchar("user_id", { length: 36 })
        .notNull()
        .references(() => users.id, { onDelete: "cascade" }),
});