Creating a MySQL database Print

  • mysql, database, phpmyadmin, user
  • 0

Create the database and user

  1. Log in to cPanel and open Manage My Databases.
  2. Under Create New Database, enter a name and click Create Database.
  3. Under Add New User, create a username and a strong password.
  4. Under Add User To Database, choose the user and database, click Add, tick ALL PRIVILEGES and click Make Changes.

Connection details for your app

SettingValue
Hostlocalhost
Database nameThe full name, including your cPanel username prefix
UsernameThe full username, including the prefix
PasswordThe password you set

Managing data

Open phpMyAdmin in cPanel to browse tables, run queries, and import or export a database.

WordPress and Softaculous create their own database when you install, so you don't need to do this for them.

Still stuck? Open a support ticket, email help@webcafe.co.za or call +27 87 654 8810.


Was this answer helpful?

« Back