• Services
    • Web Hosting
    • Reseller Hosting
    • VPS Hosting
    • Dedicated Hosting
  • Domains
  • Features
  • Company
    • About Us
    • Server Locations
    • Affiliates
    • Company Blog
  • Support
  • Client Login
  • Services
    • Web Hosting
    • Reseller Hosting
    • VPS Hosting
    • Dedicated Hosting
  • Domains
  • Features
  • Company
    • About Us
    • Server Locations
    • Affiliates
    • Company Blog
  • Support
  • Client Login
Home/Article/Web Hosting/Database/Create a MySQL Database and a User from cPanel

Create a MySQL Database and a User from cPanel

Written by VernalWeb
June 14, 2017

Creating MySQL Database & User from cPanel is very easy. One can perform these tasks within a few mouse clicks. Here is a step by step guide on ‘How to Create a MySQL Database and a User from cPanel’

 

Create Database:

Step 1: Log into your cPanel by providing your username and password.

cPanel

Step 2: Scroll down to database section and click on “MySQL Databases”

 

mysql

Step 3: Under “Create a New Database” enter your database name and click on “Create Database”.

 

mysql database

Step 4: The list of created databases can be found under “Current Databases” section. Users can delete and rename a database from this section.

 

Create User:

Step 1: Log into your cPanel by providing your username and password.
Step 2: Scroll down to database section and click on “MySQL Databases”
MySQL User

Step 3: Under “MySQL Users, Add a New User” enter your username and password(twice) and click on “Create a User”.

 

Step 4: The list of created users can be found under “Current Users” section. Users can delete and rename a username and change password from this section.

 

Add a User to a Database:

After creating both the database and user you need to give the privileges to the user who will have control over the database. To do this follow the steps below:

Step 1: Log into your cPanel by providing your username and password.

Step 2: Scroll down to database section and click on “MySQL Databases”

Step 3: Under “Add a User to a Database” choose username and database and click on “Add”. **It will redirect you to the page where you can give all the privilleges to the user.

We hope this tutorial helps you find the perfect solution. If your like our tutorials, definitely you’ll love our support. All VernalWeb hosting plans include 24/7 support from our amazing inhouse support staff. Check out our web hosting plans and have your website migrated today!

Was this helpful?

Yes  No
Related Articles
  • How to manage PostgreSQL databases and users in cPanel
  • How to Enable Remote MySQL Connection in WHM?
  • How to Configure Remote MySQL Database Connection in cPanel
  • How to create a MySQL database in cPanel
  • How to export a database using phpMyAdmin
  • How to import a database using phpMyAdmin

Didn't find your answer? Submit Ticket

Latest Articles

  • How to show Hidden Files (.htaccess) in cPanel File Manager
  • Setup a Domain Redirection in cPanel
  • Create a MySQL Database and a User from cPanel
  • Remove page extensions using .htaccess
  • Cron Job Usage & Policy
  • © 2014 - 2025 VernalWeb. All rights reserved.