How to create MSSQL Database in cPanel

August 9, 2024

Creating a MSSQL database in cPanel is a straightforward process. cPanel provides tools like MySQL Databases and phpMyAdmin to manage databases. Here’s a step-by-step guide on how to create a database in cPanel:

Step-by-Step Guide to Creating a MSSQL Database in cPanel

1. Log in to cPanel

  • Access your cPanel account by navigating to https://yourdomain.com/cpanel and logging in with your credentials.

2. Navigate to MySQL Databases

  • In the cPanel dashboard, scroll down to the Databases section.
  • Click on MySQL Databases.

3. Create a New Database

  • In the Create New Database section:
    • Enter a name for your new database in the New Database field.
    • Click Create Database.
  • Example:
    • If your cPanel username is user123 and you name your database mydatabase, the full database name will be user123_mydatabase.
  • After creating the database, you will see a success message. Click Go Back to return to the MySQL Databases page.

4. Create a Database User

  • In the MySQL Users section:
    • Enter a username in the Username field.
    • Enter and confirm a strong password in the Password fields.
    • Click Create User.
  • Example:
    • If your cPanel username is user123 and you create a database user named dbuser, the full username will be user123_dbuser.
  • After creating the user, you will see a success message. Click Go Back to return to the MySQL Databases page.

5. Assign the User to the Database

  • In the Add User to Database section:
    • Select the user you just created from the User dropdown.
    • Select the database you created from the Database dropdown.
    • Click Add.
  • Set Privileges:
    • On the next screen, you will be prompted to set privileges for the user. Check All Privileges to grant the user full access to the database.
    • Click Make Changes.
  • After setting privileges, you will see a success message. Click Go Back to return to the MySQL Databases page.

6. Manage Your Database

  • Your database is now created and associated with a user.
  • You can manage your database using phpMyAdmin, which is also available in the Databases section of cPanel.

Optional: Access phpMyAdmin

  • Access phpMyAdmin:
    • In the cPanel Databases section, click on phpMyAdmin to manage your database.
    • Select your database from the list on the left to start managing tables, running SQL queries, and more.

Conclusion

Creating a MSSQL database in cPanel involves creating the database itself, setting up a user, and assigning the user to the database with the necessary privileges. These steps ensure that your database is ready for use with your website or application. cPanel simplifies this process with its intuitive interface, making database management accessible even for those with minimal technical experience.