How to create a MySQL database in cPanel

How to create a MySQL database in cPanel

Most website software (WordPress, Joomla, shops) needs a database.

Quickest way: MySQL Database Wizard

  1. In cPanel, open Database Wizard in the Databases section.
  2. Enter a database name and click Next Step.
  3. Create a database user with a strong password and click Create User.
  4. Tick ALL PRIVILEGES and click Next Step.

Manual way

In MySQL Databases: create the database, create a user, then use Add User to Database and grant all privileges.

Important: prefixes

cPanel adds your account username to the start of every database and user name. If you name a database shop and your username is cpuser, the real name is cpuser_shop. Use the full prefixed names in your website's configuration.

Database host for your website is localhost. Manage the contents of your databases with phpMyAdmin.

    • Related Articles

    • How to import a large MySQL database via SSH

      phpMyAdmin is fine for smaller databases, but large imports can time out. Importing over SSH is faster and more reliable. Create the database and user in cPanel (see How to create a MySQL database). Upload your .sql file to your home directory using ...

    • How to connect to a MySQL database using PHP

      Before you start Create a database and a user in cPanel (see How to create a MySQL database in cPanel) and note: The database name and username – cPanel adds your account username as a prefix, e.g. cpuser_shop and cpuser_shopuser The user's password ...

    • How to create FTP accounts in cPanel

      Extra FTP accounts let a web designer or developer upload files without giving them your cPanel login. Each account can be limited to one folder. In cPanel, open FTP Accounts in the Files section. Enter a Log In name and choose the domain. Set a ...

    • How to create an email account in cPanel

      Log in to cPanel. In the Email section, click Email Accounts. Click + Create. Choose the domain (if you have more than one) and enter the part of the address before the @, for example sales. Set a strong password, or click Generate to create one. ...

    • How to create a mailing list in cPanel

      Mailing lists let you send one email to a group of subscribers using a single address, such as team@yourdomain.co.uk. Log in to cPanel and open Mailing Lists in the Email section. Enter a List Name and choose the domain. Set an administrator ...