Welcome to our Support Centre
< Back
You are here:
Print

How to Create a New MySQL Database on cPanel

To create a new MySQL database in cPanel, follow these steps:

  1. Log in to your cPanel account.
  2. In theย Databasesย section, clickย MySQL Databases.
  3. Underย Create New Database, enter a name for the database and clickย Create Database.
  4. Clickย Go Back.
  5. The new database will appear in theย Current Databasesย table.

You can now create a user for the database and grant them the necessary permissions. To do this, follow these steps:

  1. Scroll down to theย Add New Userย section.
  2. Enter a username and password for the user.
  3. Clickย Add User.
  4. Underย Assign User to Database, select the database that you created in step 3 and clickย Assign.
  5. Underย Privileges, select the privileges that you want to grant to the user.
  6. Clickย Make Changes.

The new user will now be able to access and manage the database that you created.

Here are some additional tips for creating a MySQL database in cPanel:

  • Choose a descriptive name for the database. This will help you to identify the database later.
  • Use a strong password for the database user.
  • Grant the database user only the privileges that they need. This will help to keep your database secure.
Table of Contents