Most web applications store their content in a MySQL database. If you use the one-click installer, it creates the database for you. To set one up manually:
Use the Database Wizard
- Log in to cPanel and open Databases → Database Wizard.
- Enter a name for the database and click Next Step.
- Create a database user with a strong password and click Create User.
- Tick ALL PRIVILEGES and click Next Step.
Note the full database name and username — cPanel adds your account name as a prefix, like account_dbname. Your application will also ask for the database host, which is localhost.
Manage the data with phpMyAdmin
Open Databases → phpMyAdmin to browse tables, run queries, or import and export .sql files.
Tip: Always export a copy of your database in phpMyAdmin before running queries or importing data.
Related articles
- How to Check and Repair a MySQL Database
- How to Install WordPress on Your Hosting Account
- How to Back Up and Restore Your Website in cPanel
Still need a hand?
Our team is available 24/7. Submit a support ticket or call 877.821.HOST and we’ll walk you through it — or do it for you.