With mysql client

# Connect as root user
mysql -h <VM_IP> -P 30306 -u root -p

# Connect as application user
mysql -h <VM_IP> -P 30306 -u <USERNAME> -p <DATABASE>

‍

Connection string for applications

# Generic
mysql://<USERNAME>:<PASSWORD>@<VM_IP>:30306/<DATABASE>

‍

Examples by language

# Python (pymysql)
import pymysql
conn = pymysql.connect( 
host="<VM_IP>", port=30306, 
user="<USER>", password="<PASSWORD>", db="<DATABASE>"
)

// Node.js (mysql2)
const connection = mysql.createConnection({ 
host: "<VM_IP>", port: 30306, 
user: "<USER>", password: "<PASSWORD>", database: "<DATABASE>"
});

// PHP (PDO)
$pdo = new PDO("mysql:host=<VM_IP>;port=30306;dbname=<DATABASE>", "<USER>", "<PASSWORD>");

# View the MySQL pod
`kubectl get pods -A | grep mysql`

# View the installation log
`tail -f /var/log/cuemby/bootstrap.log`

# Verify that the port is listening
`ss -tlnp | grep 30306`

‍

Expected output:

NAME                     READY   STATUS    RESTARTS
mysql-xxxxxxxxx-xxxxx    1/1     Running   0        ← Running ✓

‍

ℹ️ For everyday use, use the application user (MYSQL_USER), not root. The application user already has full permissions on MYSQL_DATABASE.

-- List databases
SHOW DATABASES;

- Use the application database
USE app;

- Create a table
CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100) NOT NULL,
email VARCHAR(150) UNIQUE NOT NULL,
created_in TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

- Insert a record
INSERT INTO users (name, email) VALUES ('Martin', 'martin@cuemby.com');

- Query
SELECT * FROM users;