Home

omp-MySQL Wiki

Welcome! This wiki is a book — read it top to bottom if you're new, or jump to what you need. It starts from "what even is a database?" and builds up to a full login/register system.

In a hurry? → Quick Start (10 minutes) Brand new to open.mp? → open.mp basics Hit an error? → Troubleshooting & FAQ

Part 1 — Understand it

1. open.mp basics (total newcomers) — gamemode/component/native/callback
2. What is MySQL? (start from zero)
3. How an open.mp server talks to a database — with diagrams
4. Why omp-MySQL? (vs. SA-MP-MySQL)
5. MySQL versions & history

Part 2 — Use it

6. Quick Start (10 minutes) — fastest path to a working connection
7. Installing MySQL (for complete beginners) — download links + GUI walkthrough
8. Docker Compose example — run MySQL the tidy way
9. Getting started
10. Configuration — credentials, TLS, the safe way
11. SQL crash course — learn SELECT/INSERT/UPDATE/DELETE from scratch
12. Designing your tables — schema basics
13. Storing game data — the right column types
14. Dates & times
15. Your first queries
16. Async patterns & pitfalls — the #1 thing to understand
17. Reading results (result sets) — getting data back
18. Prepared statements — the safe way to use user input
19. Passwords & hashing — Argon2id, login/register/change
20. Transactions — all-or-nothing changes (money transfers)
21. Models (active-record) — read/write a row without writing SQL
22. Tutorial: a simple login system from scratch — step by step
23. The mysql-admin demo — a full login/register system to learn from

Part 3 — Build it & go deeper

24. Building from source — Windows · Linux · macOS
25. Native reference — every mysql_* function
26. Performance & best practices — keep your server smooth
27. Multiple connections & databases — when one isn't enough
28. Backups & maintenance — don't lose your players' data
29. VECTOR & similarity search — MySQL 9.0+ AI features
30. Migrating from SA-MP-MySQL
31. Security — threat model, hardening, what we pentested

Reference

• Cheat sheet — everything on one page
• Cookbook — copy-paste recipes for everyday tasks
• Troubleshooting & FAQ — errors, what they mean, fixes
• Glossary — every term in plain English
• Changelog — version history
• Contributing — report bugs, build, submit PRs

---

Never used a database? Start at What is MySQL? — it assumes you know nothing and explains everything with simple pictures.