Databases for beginners

A database sounds intimidating but it’s basically a smart spreadsheet your app reads and writes — users, posts, orders, whatever your site needs to remember. Your app talks to it using one line of settings called a connection string.

The idea

• A database stores your data in tables (like sheets), made of rows (records) and columns (fields). A users table has a row per user with columns like id, name, email.
• Your app doesn’t store this in files — it asks the database (“give me user #2”, “save this new order”). The database is fast and keeps everything consistent.
• On most hosting, the database is MySQL (or MariaDB, which is the same thing).

Create one in OrbixPanel

1. Go to Databases → Create database (give it a name; the panel may add a prefix like myacct_).

2. Create a user with a strong password, and assign it to that database.

3. You now have the four things your app needs — the connection string pieces:

   Piece	Value
   Host	127.0.0.1 (same server)
   Database	the full name, e.g. myacct_blog
   User	the user you made
   Password	its password

   Example your app would use:

   mysql://myacct_user:YourPassword@127.0.0.1:3306/myacct_blog

Put it into your app

• WordPress / installers ask for these four values during setup — just paste them in.
• Node / Laravel / etc. read them from a config or .env file (often as a single DATABASE_URL). Set them in the app’s Environment Variables.

Password tip: stick to letters and numbers. Symbols like @ : / # have special meaning in a connection string and have to be “escaped,” which is the #1 cause of authentication failed. Letters + digits = no headaches.

Looking inside

Use phpMyAdmin (a visual tool your provider can enable) to browse tables, run searches, and import/export a backup (.sql file) — all in the browser, no commands.

Next: Deploy WordPress →