Create a MySQL or PostgreSQL database and user

Set up a database, give a user the right privileges and find the connection details for your application.

Updated 22 July 20262 min read2 views0 found this helpful
On this page

Most web applications β€” WordPress, Laravel, custom PHP sites β€” store their content in a database.

Create a MySQL database

  1. In cPanel open Databases β†’ Database Wizard.
  2. Enter a database name. cPanel adds your username as a prefix, for example acme_shop.
  3. Create a database user with a strong generated password.
  4. Tick ALL PRIVILEGES (or only the privileges your app needs) and click Next Step.

Connection details

SettingValue
Hostlocalhost
Databasecpaneluser_dbname
Usernamecpaneluser_dbuser
Port3306 (MySQL) or 5432 (PostgreSQL)

PostgreSQL

Open Databases β†’ PostgreSQL Database Wizard and follow the same steps.

Import an existing database

Open phpMyAdmin, select the empty database, click Import and upload your .sql file. Very large files can be compressed as .sql.gz first.

#cPanel#MySQL#PostgreSQL#database

Was this article helpful?

Your vote helps us write better guides.

Keep reading

Related articles

Still stuck?

Talk to our support team

Open a ticket

Best for anything technical. Every reply is tracked.

Submit a ticket

Call our Nairobi team

+254 726 872 512 Β· +254 722 917 455

Call now

Message us

Send a question and we'll reply by email or phone.

Contact support
Launch today

Powering Your Online Success!

Domain, hosting, email and SSL from one local team β€” set up in minutes and backed by people you can call.

  • Free SSL
  • Free migration
  • 99.9% uptime
  • 24/7 expert support

Start with your domain

Check availability, then add hosting in the same order.

Prefer to talk? Call +254 726 872 512