{"id":456,"date":"2024-08-09T16:26:13","date_gmt":"2024-08-09T16:26:13","guid":{"rendered":"https:\/\/123webhostingindia.com\/tutorials\/?p=456"},"modified":"2024-08-09T16:26:15","modified_gmt":"2024-08-09T16:26:15","slug":"how-to-create-mssql-database-in-cpanel","status":"publish","type":"post","link":"https:\/\/123webhostingindia.com\/tutorials\/how-to-create-mssql-database-in-cpanel\/","title":{"rendered":"How to create MSSQL Database in cPanel"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"410\" src=\"https:\/\/123webhostingindia.com\/tutorials\/wp-content\/uploads\/2024\/08\/MSSQL-database-in-cPanel-1024x410.png\" alt=\"\" class=\"wp-image-462\" srcset=\"https:\/\/123webhostingindia.com\/tutorials\/wp-content\/uploads\/2024\/08\/MSSQL-database-in-cPanel-1024x410.png 1024w, https:\/\/123webhostingindia.com\/tutorials\/wp-content\/uploads\/2024\/08\/MSSQL-database-in-cPanel-300x120.png 300w, https:\/\/123webhostingindia.com\/tutorials\/wp-content\/uploads\/2024\/08\/MSSQL-database-in-cPanel-768x308.png 768w, https:\/\/123webhostingindia.com\/tutorials\/wp-content\/uploads\/2024\/08\/MSSQL-database-in-cPanel.png 1058w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div class=\"wp-block-rank-math-toc-block\" id=\"rank-math-toc\"><h2>Table of Contents<\/h2><nav><ul><li><a href=\"#step-by-step-guide-to-creating-a-mssql-database-in-c-panel\">Step-by-Step Guide to Creating a MSSQL Database in cPanel<\/a><ul><li><a href=\"#1-log-in-to-c-panel\">1. Log in to cPanel<\/a><\/li><li><a href=\"#2-navigate-to-my-sql-databases\">2. Navigate to MySQL Databases<\/a><\/li><li><a href=\"#3-create-a-new-database\">3. Create a New Database<\/a><\/li><li><a href=\"#4-create-a-database-user\">4. Create a Database User<\/a><\/li><li><a href=\"#5-assign-the-user-to-the-database\">5. Assign the User to the Database<\/a><\/li><\/ul><\/li><li><a href=\"#6-manage-your-database\">6. Manage Your Database<\/a><\/li><li><a href=\"#optional-access-php-my-admin\">Optional: Access phpMyAdmin<\/a><\/li><li><a href=\"#conclusion\">Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n\n\n\n<p>Creating a <a href=\"https:\/\/www.squarebrothers.com\/\" target=\"_blank\" rel=\"noopener\">MSSQL database in cPanel <\/a>is a straightforward process. cPanel provides tools like <strong>MySQL Databases<\/strong> and <strong>phpMyAdmin<\/strong> to manage databases. Here&#8217;s a step-by-step guide on how to create a database in cPanel:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"step-by-step-guide-to-creating-a-mssql-database-in-c-panel\">Step-by-Step Guide to Creating a MSSQL Database in cPanel<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"1-log-in-to-c-panel\">1. <strong>Log in to cPanel<\/strong><\/h4>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"804\" height=\"622\" src=\"https:\/\/123webhostingindia.com\/tutorials\/wp-content\/uploads\/2024\/08\/image-4.png\" alt=\"\" class=\"wp-image-461\" srcset=\"https:\/\/123webhostingindia.com\/tutorials\/wp-content\/uploads\/2024\/08\/image-4.png 804w, https:\/\/123webhostingindia.com\/tutorials\/wp-content\/uploads\/2024\/08\/image-4-300x232.png 300w, https:\/\/123webhostingindia.com\/tutorials\/wp-content\/uploads\/2024\/08\/image-4-768x594.png 768w\" sizes=\"auto, (max-width: 804px) 100vw, 804px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Access your cPanel account by navigating to <code>https:\/\/yourdomain.com\/cpanel<\/code> and logging in with your credentials.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"2-navigate-to-my-sql-databases\">2. <strong>Navigate to MySQL Databases<\/strong><\/h4>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"529\" src=\"https:\/\/123webhostingindia.com\/tutorials\/wp-content\/uploads\/2024\/08\/image-1024x529.png\" alt=\"\" class=\"wp-image-457\" srcset=\"https:\/\/123webhostingindia.com\/tutorials\/wp-content\/uploads\/2024\/08\/image-1024x529.png 1024w, https:\/\/123webhostingindia.com\/tutorials\/wp-content\/uploads\/2024\/08\/image-300x155.png 300w, https:\/\/123webhostingindia.com\/tutorials\/wp-content\/uploads\/2024\/08\/image-768x397.png 768w, https:\/\/123webhostingindia.com\/tutorials\/wp-content\/uploads\/2024\/08\/image.png 1074w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>In the cPanel dashboard, scroll down to the <strong>Databases<\/strong> section.<\/li>\n\n\n\n<li>Click on <strong>MySQL Databases<\/strong>.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"3-create-a-new-database\">3. <strong>Create a New Database<\/strong><\/h4>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"882\" height=\"444\" src=\"https:\/\/123webhostingindia.com\/tutorials\/wp-content\/uploads\/2024\/08\/image-1.png\" alt=\"\" class=\"wp-image-458\" srcset=\"https:\/\/123webhostingindia.com\/tutorials\/wp-content\/uploads\/2024\/08\/image-1.png 882w, https:\/\/123webhostingindia.com\/tutorials\/wp-content\/uploads\/2024\/08\/image-1-300x151.png 300w, https:\/\/123webhostingindia.com\/tutorials\/wp-content\/uploads\/2024\/08\/image-1-768x387.png 768w\" sizes=\"auto, (max-width: 882px) 100vw, 882px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>In the <strong>Create New Database<\/strong> section:\n<ul class=\"wp-block-list\">\n<li>Enter a name for your new database in the <strong>New Database<\/strong> field.<\/li>\n\n\n\n<li>Click <strong>Create Database<\/strong>.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Example:<\/strong>\n<ul class=\"wp-block-list\">\n<li>If your cPanel username is <code>user123<\/code> and you name your database <code>mydatabase<\/code>, the full database name will be <code>user123_mydatabase<\/code>.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>After creating the database, you will see a success message. Click <strong>Go Back<\/strong> to return to the MySQL Databases page.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"4-create-a-database-user\">4. <strong>Create a Database User<\/strong><\/h4>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"982\" height=\"431\" src=\"https:\/\/123webhostingindia.com\/tutorials\/wp-content\/uploads\/2024\/08\/image-2.png\" alt=\"\" class=\"wp-image-459\" srcset=\"https:\/\/123webhostingindia.com\/tutorials\/wp-content\/uploads\/2024\/08\/image-2.png 982w, https:\/\/123webhostingindia.com\/tutorials\/wp-content\/uploads\/2024\/08\/image-2-300x132.png 300w, https:\/\/123webhostingindia.com\/tutorials\/wp-content\/uploads\/2024\/08\/image-2-768x337.png 768w\" sizes=\"auto, (max-width: 982px) 100vw, 982px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>In the <strong>MySQL Users<\/strong> section:\n<ul class=\"wp-block-list\">\n<li>Enter a username in the <strong>Username<\/strong> field.<\/li>\n\n\n\n<li>Enter and confirm a strong password in the <strong>Password<\/strong> fields.<\/li>\n\n\n\n<li>Click <strong>Create User<\/strong>.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Example:<\/strong>\n<ul class=\"wp-block-list\">\n<li>If your cPanel username is <code>user123<\/code> and you create a database user named <code>dbuser<\/code>, the full username will be <code>user123_dbuser<\/code>.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>After creating the user, you will see a success message. Click <strong>Go Back<\/strong> to return to the MySQL Databases page.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"5-assign-the-user-to-the-database\">5. <strong>Assign the User to the Database<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>In the <strong>Add User to Database<\/strong> section:\n<ul class=\"wp-block-list\">\n<li>Select the user you just created from the <strong>User<\/strong> dropdown.<\/li>\n\n\n\n<li>Select the database you created from the <strong>Database<\/strong> dropdown.<\/li>\n\n\n\n<li>Click <strong>Add<\/strong>.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"881\" height=\"616\" src=\"https:\/\/123webhostingindia.com\/tutorials\/wp-content\/uploads\/2024\/08\/image-3.png\" alt=\"\" class=\"wp-image-460\" srcset=\"https:\/\/123webhostingindia.com\/tutorials\/wp-content\/uploads\/2024\/08\/image-3.png 881w, https:\/\/123webhostingindia.com\/tutorials\/wp-content\/uploads\/2024\/08\/image-3-300x210.png 300w, https:\/\/123webhostingindia.com\/tutorials\/wp-content\/uploads\/2024\/08\/image-3-768x537.png 768w\" sizes=\"auto, (max-width: 881px) 100vw, 881px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Set Privileges:<\/strong>\n<ul class=\"wp-block-list\">\n<li>On the next screen, you will be prompted to set privileges for the user. Check <strong>All Privileges<\/strong> to grant the user full access to the database.<\/li>\n\n\n\n<li>Click <strong>Make Changes<\/strong>.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>After setting privileges, you will see a success message. Click <strong>Go Back<\/strong> to return to the MySQL Databases page.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"6-manage-your-database\">6. <strong>Manage Your Database<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Your database is now created and associated with a user.<\/li>\n\n\n\n<li>You can manage your database using <strong>phpMyAdmin<\/strong>, which is also available in the <strong>Databases<\/strong> section of cPanel.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"optional-access-php-my-admin\">Optional: Access phpMyAdmin<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Access phpMyAdmin:<\/strong>\n<ul class=\"wp-block-list\">\n<li>In the cPanel <strong>Databases<\/strong> section, click on <strong>phpMyAdmin<\/strong> to manage your database.<\/li>\n\n\n\n<li>Select your database from the list on the left to start managing tables, running SQL queries, and more.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"conclusion\">Conclusion<\/h3>\n\n\n\n<p>Creating a <a href=\"http:\/\/123webhostingindia.com\">MSSQL database in cPanel<\/a> 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.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Creating a MSSQL database in cPanel is a straightforward process. cPanel provides tools like MySQL Databases and phpMyAdmin to manage databases. Here&#8217;s a step-by-step guide on how to create a&#8230;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[40],"tags":[],"class_list":["post-456","post","type-post","status-publish","format-standard","hentry","category-mssql-database-in-cpanel"],"_links":{"self":[{"href":"https:\/\/123webhostingindia.com\/tutorials\/wp-json\/wp\/v2\/posts\/456","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/123webhostingindia.com\/tutorials\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/123webhostingindia.com\/tutorials\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/123webhostingindia.com\/tutorials\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/123webhostingindia.com\/tutorials\/wp-json\/wp\/v2\/comments?post=456"}],"version-history":[{"count":1,"href":"https:\/\/123webhostingindia.com\/tutorials\/wp-json\/wp\/v2\/posts\/456\/revisions"}],"predecessor-version":[{"id":463,"href":"https:\/\/123webhostingindia.com\/tutorials\/wp-json\/wp\/v2\/posts\/456\/revisions\/463"}],"wp:attachment":[{"href":"https:\/\/123webhostingindia.com\/tutorials\/wp-json\/wp\/v2\/media?parent=456"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/123webhostingindia.com\/tutorials\/wp-json\/wp\/v2\/categories?post=456"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/123webhostingindia.com\/tutorials\/wp-json\/wp\/v2\/tags?post=456"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}