Learning Hub · Beginner · 5 minutes
How to Create a MySQL Database
Everything you need to database, user and privileges — the three-step every app needs — the steps, the gotcha, and the tip the support desk gives everyone.
The short answer
Goal: database, user and privileges — the three-step every app needs. Time needed: 5 minutes. Difficulty: beginner.
The walkthrough below covers each step, the mistake most people make, and the shortcut worth knowing. On HostingAlly plans, several of the steps are handled for you — we note where.
Beginner
Difficulty
5 minutes
Time needed
5
Steps
24/7
Help if you're stuck
You don't need to be technical for this — the walkthrough is written for first-timers, tested against our own platform, and honest about which parts are genuinely fiddly versus merely unfamiliar.
Rule of the road: read the gotcha section before you begin, not after — it's harvested from the support tickets of people who didn't.
Overview before the detail
Here's the complete route: use the mysql database wizard, name for future recognition, generate and store the password, grant all privileges to the app user and record the connection details.
None of the stages requires code or a terminal unless the guide explicitly says so — and where it does, the exact commands are given. The full step-by-step sits below; the surrounding sections cover the context that makes it stick.
The classic gotcha
Creating the database and user but skipping the privilege grant — the app's 'access denied' error looks like a wrong password while both credentials are perfectly correct.
Forewarned is genuinely forearmed here — this exact mistake accounts for most of the frustration this topic produces, and it's entirely avoidable once named.
The pro tip worth stealing
One database per application, always — sharing a database between apps saves nothing and turns every backup, restore and cleanup into a hostage negotiation.
Small habits like this are the real difference between people who find hosting easy and people who find it stressful — the tools are identical; the workflow isn't.
How HostingAlly makes this easier
We've automated the steps that don't deserve your time: certificates issue and renew themselves, the installer handles application setup, daily backups cover the what-if, and per-site settings live in a panel instead of config files. The guide above covers what's left — the part that's actually about your site.
And when a step misbehaves anyway, support answers around the clock — with the actual fix, not a knowledge-base link and a shrug. Half our best guides started as patterns in the tickets.
Guides are easier on a good platform
Tutorials age badly when they're written against imaginary hosting. These are written against ours — the same panel, installer and defaults you'll actually see.
Renewal prices match signup prices, so the year-two invoice is the most boring email you'll get from us.
- Step-by-step, tested as written
- The gotcha flagged before you hit it
- Automation covers the boring steps
- 24/7 support if you get stuck
Why HostingAlly
What you get with every plan
Works as written
Every step tested on our own platform — no 'your host may vary' hand-waving.
No jargon tax
Terms are explained in place or linked to the glossary — nothing assumes you already know.
The undo is always named
Where a step could bite, the guide says so and gives the reversal.
Automation where it belongs
SSL, backups and installs run themselves here — the guide covers only what's genuinely yours to do.
Help on standby
Stuck at step three at midnight? Support answers around the clock, mid-guide included.
Written from real tickets
Our guides come from the support desk — the gotchas are the ones people actually hit.
Getting Started
How to get going
- 1
Use the MySQL Database Wizard
The wizard chains the three required steps — create database, create user, grant privileges — the trio that manual creation sometimes leaves incomplete.
- 2
Name for future recognition
Prefixed names (account_projectname) are automatic; make the suffix meaningful — six months on, 'db1' and 'test' are archaeology.
- 3
Generate and store the password
The database password goes straight into your password manager and the app's config — it's infrastructure, not something to memorise.
- 4
Grant all privileges to the app user
Applications expect full rights on their own database — restricted accounts are for special cases like read-only reporting users.
- 5
Record the connection details
Host is localhost on the same server, plus database, user, password — the four values every installer asks for.
Included
What's covered on our plans
- Per-site PHP version selection
- One-click installer for WordPress and 400+ apps
- 99.9% uptime commitment, monitored around the clock
- No setup fees, ever
- Free website migration handled by our team
- NVMe SSD storage as standard
- LiteSpeed server-level caching
- SSH, Git and Composer access on developer-friendly plans
- Free SSL certificate on every plan, renewed automatically
- Renewal prices that match signup prices
FAQ
Your questions, answered
What's the database host — localhost or something else?
For apps on the same hosting account, localhost. Remote connections (your desktop's MySQL client) use the server hostname with your IP whitelisted in Remote MySQL — a deliberate, separate enablement.
Can I browse what's inside the database?
phpMyAdmin (linked beside the database tools) shows tables and data visually — the standard window into what your application actually stores.
Do you include email with hosting?
Yes — mailboxes on your own domain come with every hosting plan, with webmail, IMAP/POP/SMTP access and spam filtering. Standalone email hosting also exists for domains whose websites live elsewhere.
Is there a money-back guarantee?
Yes — try the hosting properly and if it doesn't fit, the refund process is a request, not a retention gauntlet. Domain registrations are the one standard carve-out, since registries make those non-refundable the moment they're placed.
What does your 24/7 support actually cover?
Real people at every hour, and a scope that includes the practical questions — email setup, DNS, WordPress issues, restores — not just 'the server is up, ticket closed'. Pre-sales questions are welcome too; ask us something difficult and judge the reply.
Is SSL really included at no cost?
On every plan, with no exceptions — certificates are issued automatically when your domain points to us and renew themselves before expiry. The encryption is identical to paid DV certificates; paid tiers exist only for wildcard convenience or organisation-level validation.
Where is your company based?
HostingAlly is a trading name of Bohzo Ltd, a company registered in England and Wales — a real, verifiable business with published terms under English law, which is worth checking about any host before you hand them your domain.
Keep exploring
How to Submit a Sitemap to Google
Give search engines the complete map of what to crawl — beginner level, 15 minutes.
How to Change Nameservers
Delegate a domain's DNS to a new provider cleanly — beginner level, 5 minutes plus propagation.
Web Hosting
NVMe cPanel hosting with free SSL, migration and a free first-year domain.
VPS Hosting
KVM virtual servers with root access, DDoS protection and flat pricing.
Ready when you are.
Fast NVMe hosting, free SSL and migration, and real people on support around the clock — at prices that stay put.
See Hosting Plans