Most websites, including WordPress, store their content in a database. If you install WordPress using WordPress Manager by Softaculous, the database is created for you, so you usually won't need to do this yourself. You might need to create one if you're setting up a website by hand or a developer has asked for one.

Creating a database

  1. Log in to cPanel. See How to log in to cPanel if you're not sure how.
  2. Under Databases, click Database Wizard.

The Databases section in cPanel, with phpMyAdmin and Database Wizard highlighted

  1. Enter a name for the database and click Next Step. cPanel adds your account name to the start automatically, so the full name will look like account_name.

Step 1 of the Database Wizard, with the database name box and Next Step highlighted

  1. Create a database user. Enter a username and a strong password, or click Password Generator, then click Create User. Make a note of the full username and password, as you'll need them to connect your website.
  2. Tick ALL PRIVILEGES and click Next Step. This lets the user read and change the database.

Your database is now ready. Your website will need the database name, username and password, and the host, which is localhost.

Using phpMyAdmin

phpMyAdmin lets you look at and manage the contents of your databases. It's mostly used for downloading a copy of a database, or importing one when moving a website.

  1. In cPanel, under Databases, click phpMyAdmin.
  2. Click the database you want on the left.
  3. Use Export to download a copy, or Import to upload one.

phpMyAdmin, with the list of databases and the Export and Import tabs highlighted

Be careful in phpMyAdmin. Changes take effect straight away and can't be undone, and a mistake can break your website. Take a backup first, and if you're not sure, raise a ticket and we'll help.

Was this answer helpful? 0 Users Found This Useful (0 Votes)