How to Create MySQL Database in Hostinger & Access Phpmyadmin Easily 2026
By Impran M NLast checked against official docs
Whether you're setting up WordPress or building a custom application, most projects eventually need a MySQL database. Hostinger keeps the whole process, creating the database, connecting it to phpMyAdmin, and browsing what's inside, in one control panel. This guide walks from the site dashboard where the Databases tool lives through to browsing tables inside phpMyAdmin, including two constraints that are easy to hit by surprise: a password rule on the account you create, and a one-user-per-database limit on shared and cloud plans.
Before you start
- An active Hostinger hosting plan (shared or cloud) with a website already set up
- A password ready that meets Hostinger's rule: at least 8 characters, with one uppercase letter, one lowercase letter, and one number
01Open your site's dashboard in hPanel
Log in to Hostinger and select the website you're working on to land on its Dashboard. This overview page shows tiles for Domain, Hosting, Free Email, and Backups near the top, and a second row further down with PageSpeed Insights, File manager, and Databases. The Databases tile is your entry point for everything in this guide: creating a new database, managing existing ones, and launching phpMyAdmin.

02Create a new MySQL database
Click into Databases and choose the option to create a new one. Hostinger attaches your account's numeric prefix automatically, so a database you name pmnonline becomes something like u276259427_pmnonline.
The name you type becomes a suffix, and that prefix cannot be removed or changed later. Pick a name that describes what the database is for, since you'll reference the full prefixed name in your site's configuration file.
03Create a database user and assign permissions
Alongside the database, create a MySQL user with its own username and password, then assign that user full permissions on the new database. The password needs at least 8 characters, with an uppercase letter, a lowercase letter, and a number, or Hostinger will reject it.
Each database can only have one user on shared and cloud hosting; a project needing several separate credentials on the same database would need a VPS plan instead. Keep the password somewhere secure, since Hostinger typically shows it only once, at creation.
04Connect the database to your site or app
For WordPress, enter the database name, username, password, and host (usually localhost) into wp-config.php during setup, or let the WordPress installer handle it if you're using Hostinger's one-click install. For a custom app, use the same four credentials in whatever connection string or environment file your framework expects. Use the full prefixed name Hostinger generated (u276259427_pmnonline, not just pmnonline) everywhere a database name is expected; a connection failure after setup is often just the short name sitting where the full one belongs.
05Log in to phpMyAdmin
From the Databases section, launch phpMyAdmin, which opens to a Structure view of whatever database is currently selected. By default this often lands on the internal information_schema database, showing dozens of system tables like COLUMNS, ENGINES, and EVENTS with their row counts, types, and collations. That's normal; information_schema is MySQL's built-in metadata database, not something you created.

06Switch to your own database
In phpMyAdmin's left sidebar, click your actual database. It appears with the same prefixed name Hostinger generated, such as u276259427_pmnonline, sitting below information_schema in the list. Selecting it switches the Structure view to your own tables instead of MySQL's internal ones, which is where the real work of browsing rows, editing structure, and running queries happens.

07Manage tables, import data, and run queries
Once inside your own database, use the Browse and Structure links per table to view or edit rows and columns, the SQL tab to run raw queries directly, and Import or Export at the top to move data in or out as a .sql file. This covers the everyday database management most WordPress and custom-app workflows need without leaving the browser.
When it doesn't work
Hostinger won't let me create the database user
Why: The password doesn't meet the minimum rule: 8+ characters with an uppercase letter, a lowercase letter, and a number.
Fix: Use a password that satisfies all four conditions.
I can't add a second user to an existing database
Why: Shared and cloud hosting plans limit each database to a single user.
Fix: Use that one user's credentials everywhere the database needs to be reached, or move to a VPS plan if separate logins are genuinely required.
WordPress or my app can't connect after setup
Why: The config file has the short database name (pmnonline) instead of the full Hostinger-generated one (u276259427_pmnonline).
Fix: Copy the exact name shown in hPanel's database list into the config, prefix included.
Frequently asked questions
Do I need to create a user separately from the database?
Yes. You create the database, then create a MySQL user with permissions on it, since Hostinger treats the database and its access credentials as separate objects.
Why is my database name longer than what I typed?
Hostinger prefixes every database and username with your account's numeric ID automatically, so a name entered as "pmnonline" becomes something like u276259427_pmnonline.
Is there a password requirement for the database user?
Yes. Hostinger requires at least 8 characters, with one uppercase letter, one lowercase letter, and one number; weaker passwords are rejected at creation.
Can I import and export data in phpMyAdmin?
Yes, as .sql files, along with running SQL queries directly from the SQL tab.
Why does phpMyAdmin open to information_schema instead of my database?
information_schema is MySQL's built-in metadata database and is often the default selection. Click your own prefixed database name in the sidebar to switch to it.
Sources and last check
Click path and screens come from a walkthrough recorded in August 2025. The password rule and the one-user-per-database limit on shared and cloud hosting were confirmed against Hostinger's official documentation in September 2026 and added, since neither appeared in the original draft. The database and username prefix behavior was already correct and is unchanged.
About the author

Impran M N
I've been hooked on technology for as long as I can remember — especially the new tools and AI apps that seem to land every other week. Easy Tech Tuts is where I write up whatever I've just worked out: I do the task in the real product, record the screen, and turn it into the guide I wish I'd found first.



