mysql-memory-server

import { createDB } from 'mysql-memory-server'; import sql from 'mysql2/promise'; // Remember to `npm install mysql2` async function runEphemeralMySQL() { // Create a new database with default options, or specify a version const db = await createDB({ version: '8.4.x' // Example: specify a MySQL 8.4 version }); console.log(`MySQL server started on port: ${db.port}, database: ${db.dbName}`); // Connect to the new database const connection = await sql.createConnection({ host: '127.0.0.1', user: db.username, port: db.port, database: db.dbName, password: '' // Default password is an empty string }); try { // Run your queries here const [rows] = await connection.execute('SELECT 1 + 1 AS solution'); console.log('Query result:', rows); await connection.execute('CREATE TABLE users (id INT PRIMARY KEY, name VARCHAR(255))'); console.log('Table "users" created.'); } finally { // Once done, disconnect from the database await connection.end(); console.log('Database connection closed.'); // Then stop the database instance await db.stop(); console.log('MySQL server stopped.'); } } runEphemeralMySQL().catch(console.error);