Skip to content

MySQL Protocol Support

HeliosDB provides full MySQL wire protocol (v10) compatibility, enabling seamless migration and integration with existing MySQL applications.

Overview

Property Value
Protocol MySQL Wire Protocol v10
Port 3306
Status Production
Compatibility 80%+
Test Coverage 80%+

Quick Start

Python (mysql-connector-python)

import mysql.connector

conn = mysql.connector.connect(
    host="localhost",
    port=3306,
    user="admin",
    password="password",
    database="heliosdb"
)
cursor = conn.cursor()
cursor.execute("SELECT * FROM users")
for row in cursor.fetchall():
    print(row)
conn.close()

Node.js (mysql2)

const mysql = require('mysql2/promise');

const connection = await mysql.createConnection({
  host: 'localhost',
  port: 3306,
  user: 'admin',
  password: 'password',
  database: 'heliosdb'
});

const [rows] = await connection.execute('SELECT * FROM users');
console.log(rows);
await connection.end();

Java (JDBC)

import java.sql.*;

String url = "jdbc:mysql://localhost:3306/heliosdb";
Connection conn = DriverManager.getConnection(url, "admin", "password");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM users");
while (rs.next()) {
    System.out.println(rs.getString("name"));
}
conn.close();

Key Features

  • Full MySQL wire protocol v10 support
  • Authentication: mysql_native_password, caching_sha2_password
  • Prepared statements with parameter binding
  • Multi-statement queries
  • Transaction support (ACID)
  • All standard data types

Documentation

Last Updated: January 2026