Database Connections

Mythic Framework uses a dual-database architecture: two MongoDB databases (Auth and Game) plus MySQL via oxmysql.

Database Requirements

MongoDB

Version: 3.6.6 or higher Purpose: Primary database — two separate databases for auth and game data Required: YES

MySQL

Version: 5.7 or higher (MariaDB 10.2+) Purpose: Inventory persistence, compatibility layer Required: YES

MongoDB Configuration

Mythic requires 4 separate convars for two MongoDB databases:

Convar	Purpose	Example Value
`mongodb_auth_url`	Auth DB connection string	`mongodb://localhost:27017/...`
`mongodb_auth_database`	Auth DB name	`auth`
`mongodb_game_url`	Game DB connection string	`mongodb://localhost:27017/...`
`mongodb_game_database`	Game DB name	`fivem`

Two separate MongoDB databases are required. The auth database stores accounts and bans. The fivem database stores characters, vehicles, inventory, properties, and all game data.

Basic Connection (Development)

# server.cfg — MongoDB Auth Database
set mongodb_auth_url "mongodb://localhost:27017/?readPreference=primary&ssl=false"
set mongodb_auth_database "auth"

# server.cfg — MongoDB Game Database
set mongodb_game_url "mongodb://localhost:27017/?readPreference=primary&ssl=false"
set mongodb_game_database "fivem"

Authenticated Connection (Production)

# server.cfg — MongoDB Auth Database
set mongodb_auth_url "mongodb://mythic_user:SecurePassword123@localhost:27017/?authSource=admin&readPreference=primary"
set mongodb_auth_database "auth"

# server.cfg — MongoDB Game Database
set mongodb_game_url "mongodb://mythic_user:SecurePassword123@localhost:27017/?authSource=admin&readPreference=primary"
set mongodb_game_database "fivem"

Both databases can share the same MongoDB server and credentials — they are just different database names within the same MongoDB instance.

Connection String Parameters

Parameter	Description	Example
`username`	Database username	`mythic_user`
`password`	Database password	`SecurePassword123`
`host`	MongoDB server address	`localhost`, `192.168.1.100`
`port`	MongoDB port	`27017` (default)
`authSource`	Authentication database	`admin`
`readPreference`	Read preference	`primary`
`ssl`	Enable SSL/TLS	`true` or `false`

Remote & Cloud MongoDB

Remote Server:

set mongodb_auth_url "mongodb://mythic_user:password@192.168.1.100:27017/?authSource=admin"
set mongodb_game_url "mongodb://mythic_user:password@192.168.1.100:27017/?authSource=admin"

MongoDB Atlas (Cloud):

set mongodb_auth_url "mongodb+srv://username:password@cluster0.xxxxx.mongodb.net/?retryWrites=true&w=majority"
set mongodb_game_url "mongodb+srv://username:password@cluster0.xxxxx.mongodb.net/?retryWrites=true&w=majority"

Atlas uses mongodb+srv:// protocol for automatic DNS resolution. The database name is set separately via the mongodb_auth_database and mongodb_game_database convars.

What Each Database Stores

Auth Database
Game Database

Database name: auth

Collection	Data
`accounts`	Player accounts, identifiers, roles
`bans`	Ban records

Database name: fivem

Collection	Data
`characters`	Character data (name, appearance, etc.)
`vehicles`	Owned vehicles
`properties`	Housing/properties
`bank_accounts`	Bank account balances
`mdt_reports`	Police MDT reports
`phone_*`	Phone data (contacts, messages, etc.)

Creating MongoDB User

Connect to MongoDB

mongo

Switch to Admin Database

use admin

Create User with Access to Both Databases

db.createUser({
  user: "mythic_user",
  pwd: "SecurePassword123",
  roles: [
    { role: "readWrite", db: "auth" },
    { role: "dbAdmin", db: "auth" },
    { role: "readWrite", db: "fivem" },
    { role: "dbAdmin", db: "fivem" }
  ]
})

Verify Connection

mongo "mongodb://mythic_user:SecurePassword123@localhost:27017/?authSource=admin"

MongoDB Troubleshooting

Connection Refused

Error: MongoNetworkError: connect ECONNREFUSED 127.0.0.1:27017Solutions:

# Check if MongoDB is running (Linux)
sudo systemctl status mongod
sudo systemctl start mongod

# Check if MongoDB is running (Windows)
Get-Service MongoDB

# Verify port is listening
netstat -an | grep 27017

Authentication Failed

Error: MongoError: Authentication failedSolutions:

Verify credentials are correct
Ensure authSource=admin is in the connection string
Verify user has roles for both auth and fivem databases:

use admin
db.getUser("mythic_user")

Database Not Found

MongoDB creates databases automatically on first write. The auth and fivem databases will be created when the framework first starts and inserts data.

MySQL Configuration

Connection String

Mythic uses oxmysql with a standard MySQL connection string:

# server.cfg
set mysql_connection_string "mysql://root@localhost/MythicFramework?charset=utf8mb4"
set mysql_slow_query_warning 300

The default database name is MythicFramework. Always use charset=utf8mb4 for proper character support.

Connection String Components

mysql://username:password@host:port/database?options

Component	Description	Example
`username`	MySQL user	`root`, `mythic_user`
`password`	MySQL password (optional for root@localhost)	`SecurePassword123`
`host`	MySQL server	`localhost`, `192.168.1.100`
`port`	MySQL port (default 3306, can be omitted)	`3306`
`database`	Database name	`MythicFramework`

Common Configurations

# Local development (root, no password)
set mysql_connection_string "mysql://root@localhost/MythicFramework?charset=utf8mb4"

# Local with password
set mysql_connection_string "mysql://mythic_user:password@localhost/MythicFramework?charset=utf8mb4"

# Remote server
set mysql_connection_string "mysql://mythic_user:password@192.168.1.100:3306/MythicFramework?charset=utf8mb4"

Slow Query Warning

oxmysql can warn you about slow queries:

# Warn for queries taking longer than 300ms
set mysql_slow_query_warning 300

Creating MySQL Database and User

Command Line
phpMyAdmin

-- Login to MySQL
-- mysql -u root -p

-- Create database
CREATE DATABASE MythicFramework CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- Create user (production)
CREATE USER 'mythic_user'@'localhost' IDENTIFIED BY 'SecurePassword123';

-- Grant permissions
GRANT ALL PRIVILEGES ON MythicFramework.* TO 'mythic_user'@'localhost';

-- Apply changes
FLUSH PRIVILEGES;

Create Database

Click “Databases” tab
Enter database name: MythicFramework
Select collation: utf8mb4_unicode_ci
Click “Create”

Create User

Click “User accounts” tab
Click “Add user account”
Enter username and password
Under “Database for user account”: select “Grant all privileges on database MythicFramework”
Click “Go”

MySQL Troubleshooting

Access Denied

Error: Access denied for user 'username'@'host'

Verify username and password
Check user exists: SELECT User, Host FROM mysql.user;
URL-encode special characters in passwords:

# Password: My$ecure@Pass → My%24ecure%40Pass
mysql://user:My%24ecure%40Pass@localhost/MythicFramework

Unknown Database

Error: Unknown database 'MythicFramework'Create it:

CREATE DATABASE MythicFramework CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

Too Many Connections

Increase MySQL max connections:

SET GLOBAL max_connections = 200;

Or reduce oxmysql connection limit in the connection string:

?charset=utf8mb4&connectionLimit=5

Complete server.cfg Example

# === MONGODB (Auth Database — accounts, bans) ===
set mongodb_auth_url "mongodb://localhost:27017/?readPreference=primary&ssl=false"
set mongodb_auth_database "auth"

# === MONGODB (Game Database — characters, vehicles, inventory, etc.) ===
set mongodb_game_url "mongodb://localhost:27017/?readPreference=primary&ssl=false"
set mongodb_game_database "fivem"

# === MYSQL (oxmysql — inventory persistence) ===
set mysql_connection_string "mysql://root@localhost/MythicFramework?charset=utf8mb4"
set mysql_slow_query_warning 300

Production Checklist

MongoDB

Authentication enabled with strong password
User has readWrite + dbAdmin roles on both auth and fivem
Connection strings include authSource=admin
Firewall configured (port 27017)
Regular backups configured

MySQL

Strong password set (not root with no password)
User limited to MythicFramework database
utf8mb4 charset used
Firewall configured (port 3306)
Regular backups configured

server.cfg

All 4 MongoDB convars set
MySQL connection string configured
Credentials not committed to git

Next Steps

Server Configuration

Complete server.cfg settings guide

Database Architecture

Learn how Mythic uses databases internally

Resource Management

Configure resource load order

Troubleshooting

Common setup issues and fixes

Getting Started

Installation

Core Concepts

Configuration

Database Requirements

MongoDB

MySQL

MongoDB Configuration

Basic Connection (Development)

Authenticated Connection (Production)

What Each Database Stores

Creating MongoDB User

MongoDB Troubleshooting

MySQL Configuration

Connection String

Connection String Components

Common Configurations

Slow Query Warning

Creating MySQL Database and User

MySQL Troubleshooting

Complete server.cfg Example

Production Checklist

Next Steps

Server Configuration

Database Architecture

Resource Management

Troubleshooting

Getting Started

Installation

Core Concepts

Configuration

​Database Requirements

MongoDB

MySQL

​MongoDB Configuration

​Basic Connection (Development)

​Authenticated Connection (Production)

​What Each Database Stores

​Creating MongoDB User

​MongoDB Troubleshooting

​MySQL Configuration

​Connection String

​Connection String Components

​Common Configurations

​Slow Query Warning

​Creating MySQL Database and User

​MySQL Troubleshooting

​Complete server.cfg Example

​Production Checklist

​Next Steps

Server Configuration

Database Architecture

Resource Management

Troubleshooting

Database Requirements

MongoDB Configuration

Basic Connection (Development)

Authenticated Connection (Production)

What Each Database Stores

Creating MongoDB User

MongoDB Troubleshooting

MySQL Configuration

Connection String

Connection String Components

Common Configurations

Slow Query Warning

Creating MySQL Database and User

MySQL Troubleshooting

Complete server.cfg Example

Production Checklist

Next Steps