Skip to content
Host4u Limited

Databases: creating a database and user

Support Portal  »  Knowledgebase  »  Viewing Article
There was a problem loading the comments.
  Print

Most website software, such as WordPress, needs a MySQL database. If you install an app with Softaculous, it creates the database for you. To create one yourself, you need three things: a database, a database user, and the user added to the database.

Database and user names start with your cPanel username and an underscore, for example username_shop. Use the full name when your software asks for it.

The quick way: Database Wizard

  1. In cPanel, open Database Wizard (in the Databases section).
  2. Enter a name for the database and click Next Step.
  3. Enter a username and a strong password (or use Password Generator), and click Create User.
  4. Tick ALL PRIVILEGES and click Next Step.

Keep a note of the database name, username and password: your software will ask for them. The database server is localhost.

Doing it step by step

Manage My Databases (also in the Databases section) does the same in one page:

  1. Under Create New Database, enter a name and click Create Database.
  2. Under Add New User, enter a username and password and click Create User.
  3. Under Add User To Database, choose the user and the database, click Add, tick ALL PRIVILEGES and click Make Changes.

On the same page you can also Check Database and Repair Database, rename or delete databases, and change a database user's password.

Working with the data

To look at, export or import the data in a database, use phpMyAdmin. See phpMyAdmin: opening, exporting, importing and repairing.


Share via
Did you find this article useful?  

Related Articles


Self-Hosted Help Desk Software by SupportPal