{"id":2508,"date":"2021-08-20T09:02:40","date_gmt":"2021-08-20T14:02:40","guid":{"rendered":"https:\/\/www.knownhost.com\/kb\/?p=2508"},"modified":"2021-10-12T06:46:08","modified_gmt":"2021-10-12T11:46:08","slug":"how-to-create-mysql-database-and-user-in-cpanel","status":"publish","type":"post","link":"https:\/\/www.knownhost.com\/kb\/how-to-create-mysql-database-and-user-in-cpanel\/","title":{"rendered":"How to create MySQL Database and User in cPanel?"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-right counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #212121;color:#212121\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #212121;color:#212121\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 eztoc-toggle-hide-by-default' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.knownhost.com\/kb\/how-to-create-mysql-database-and-user-in-cpanel\/#how_to_create_a_mysql_database\" >How to create a MySQL Database?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.knownhost.com\/kb\/how-to-create-mysql-database-and-user-in-cpanel\/#how_to_create_a_mysql_user\" >How to create a MySQL User?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.knownhost.com\/kb\/how-to-create-mysql-database-and-user-in-cpanel\/#how_to_assign_a_user_to_a_mysql_database\" >How to assign a User to a MySQL Database?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.knownhost.com\/kb\/how-to-create-mysql-database-and-user-in-cpanel\/#how_to_delete_mysql_database\" >How to delete MySQL Database?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.knownhost.com\/kb\/how-to-create-mysql-database-and-user-in-cpanel\/#how_to_delete_mysql_user\" >How to delete MySQL User?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.knownhost.com\/kb\/how-to-create-mysql-database-and-user-in-cpanel\/#conclusion\" >Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n\n<p>Creating a MySQL database, User, and assigning that User to the Database through a command-line interface may get tricky for newbies who don&#8217;t know of it. Through <a href=\"https:\/\/docs.cpanel.net\/cpanel\/databases\/mysql-databases\/\">cPanel<\/a>, this job gets easier. All you have to do is perform some informed clicks and VOILA! You&#8217;re good to go!<\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"how_to_create_a_mysql_database\"><\/span><strong>How to create a MySQL Database?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>1. Log in to cPanel using&nbsp;<strong>Username&nbsp;<\/strong>&amp;&nbsp;<strong>Password<\/strong>.&nbsp;i.e;&nbsp;<em>(https:\/\/yourdomain.com:2083 or https:\/\/yourdomain.com\/cpanel)<\/em><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/Login-to-cpanel-using-user-and-password.png\" alt=\"\" class=\"wp-image-2388\"\/><\/figure>\n\n\n\n<p>2. Navigate to <strong>Databases \u2192 MySQL\u00ae Databases<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"519\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-mysql-database-cpanel-1024x519.jpg\" alt=\"\" class=\"wp-image-2509\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-mysql-database-cpanel-1024x519.jpg 1024w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-mysql-database-cpanel-300x152.jpg 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-mysql-database-cpanel-768x389.jpg 768w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-mysql-database-cpanel.jpg 1433w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>3. Enter the name of Database \u2192 Click on &#8220;<strong>Create Database<\/strong>&#8220;.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"519\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/enter-database-name-cpanel-to-create-1024x519.jpg\" alt=\"\" class=\"wp-image-2510\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/enter-database-name-cpanel-to-create-1024x519.jpg 1024w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/enter-database-name-cpanel-to-create-300x152.jpg 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/enter-database-name-cpanel-to-create-768x389.jpg 768w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/enter-database-name-cpanel-to-create.jpg 1433w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"how_to_create_a_mysql_user\"><\/span><strong>How to create a MySQL User?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>1. Log in to cPanel using&nbsp;<strong>Username&nbsp;<\/strong>&amp;&nbsp;<strong>Password<\/strong>.&nbsp;i.e;&nbsp;<em>(https:\/\/yourdomain.com:2083 or https:\/\/yourdomain.com\/cpanel)<\/em><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/Login-to-cpanel-using-user-and-password.png\" alt=\"\" class=\"wp-image-2388\"\/><\/figure>\n\n\n\n<p>2. Navigate to <strong>Databases \u2192 MySQL\u00ae Databases<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"519\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-mysql-database-cpanel-1024x519.jpg\" alt=\"\" class=\"wp-image-2509\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-mysql-database-cpanel-1024x519.jpg 1024w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-mysql-database-cpanel-300x152.jpg 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-mysql-database-cpanel-768x389.jpg 768w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-mysql-database-cpanel.jpg 1433w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>3. Navigate to <strong>MySQL Users<\/strong> and enter the required information.<\/p>\n\n\n\n<p><strong>Username<\/strong>: Type username for the database user.<\/p>\n\n\n\n<p><strong>Password<\/strong>: Enter the complex password, or you can take a help password generator to that job for you.<\/p>\n\n\n\n<p><strong>Password (Again)<\/strong>: Re-confirm the password by entering it again in this file.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"469\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/create-user-for-database-in-cpanel-1024x469.jpg\" alt=\"\" class=\"wp-image-2512\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/create-user-for-database-in-cpanel-1024x469.jpg 1024w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/create-user-for-database-in-cpanel-300x137.jpg 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/create-user-for-database-in-cpanel-768x352.jpg 768w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/create-user-for-database-in-cpanel.jpg 1433w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>4. To save all the configurations and create a new database user, Click on &#8220;<strong>Create User<\/strong>&#8220;.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"469\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/confirm-the-user-creation-by-create-user-1024x469.jpg\" alt=\"\" class=\"wp-image-2513\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/confirm-the-user-creation-by-create-user-1024x469.jpg 1024w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/confirm-the-user-creation-by-create-user-300x137.jpg 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/confirm-the-user-creation-by-create-user-768x352.jpg 768w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/confirm-the-user-creation-by-create-user.jpg 1433w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"how_to_assign_a_user_to_a_mysql_database\"><\/span><strong>How to assign a User to a MySQL Database?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>1. Log in to cPanel using&nbsp;<strong>Username&nbsp;<\/strong>&amp;&nbsp;<strong>Password<\/strong>.&nbsp;i.e;&nbsp;<em>(https:\/\/yourdomain.com:2083 or https:\/\/yourdomain.com\/cpanel)<\/em><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/Login-to-cpanel-using-user-and-password.png\" alt=\"\" class=\"wp-image-2388\"\/><\/figure>\n\n\n\n<p>2. Navigate to&nbsp;<strong>Databases \u2192 MySQL\u00ae Databases<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"1024\" height=\"519\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-mysql-database-cpanel-1024x519.jpg\" alt=\"\" class=\"wp-image-2509\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-mysql-database-cpanel-1024x519.jpg 1024w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-mysql-database-cpanel-300x152.jpg 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-mysql-database-cpanel-768x389.jpg 768w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-mysql-database-cpanel.jpg 1433w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>3. Navigate to <strong>Add User To Database<\/strong> \u2192 <strong>Select Database &amp; User<\/strong> \u2192 Click on <strong>Add<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"469\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-assign-user-to-database-1024x469.jpg\" alt=\"\" class=\"wp-image-2515\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-assign-user-to-database-1024x469.jpg 1024w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-assign-user-to-database-300x137.jpg 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-assign-user-to-database-768x352.jpg 768w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-assign-user-to-database.jpg 1433w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>4. Select the required permissions\/privileges \u2192 Click on <strong>Make Changes<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"991\" height=\"880\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/select-permissions-for-mysql-user-database.jpg\" alt=\"\" class=\"wp-image-2516\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/select-permissions-for-mysql-user-database.jpg 991w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/select-permissions-for-mysql-user-database-300x266.jpg 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/select-permissions-for-mysql-user-database-768x682.jpg 768w\" sizes=\"(max-width: 991px) 100vw, 991px\" \/><\/figure>\n\n\n\n<p>5. You can see confirmation: <em><strong>Success:<\/strong>&nbsp;You saved \u201ckhdemoco_test\u201d\u2019s privileges on the database \u201ckhdemoco_dbname\u201d.<\/em><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"991\" height=\"707\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/confirmation-permission-added.jpg\" alt=\"\" class=\"wp-image-2518\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/confirmation-permission-added.jpg 991w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/confirmation-permission-added-300x214.jpg 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/confirmation-permission-added-768x548.jpg 768w\" sizes=\"(max-width: 991px) 100vw, 991px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"how_to_delete_mysql_database\"><\/span><strong>How to delete MySQL Database?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>1. Log in to cPanel using&nbsp;<strong>Username&nbsp;<\/strong>&amp;&nbsp;<strong>Password<\/strong>.&nbsp;i.e;&nbsp;<em>(https:\/\/yourdomain.com:2083 or https:\/\/yourdomain.com\/cpanel)<\/em><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/Login-to-cpanel-using-user-and-password.png\" alt=\"\" class=\"wp-image-2388\"\/><\/figure>\n\n\n\n<p>2. Navigate to&nbsp;<strong>Databases \u2192 MySQL\u00ae Databases<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"1024\" height=\"519\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-mysql-database-cpanel-1024x519.jpg\" alt=\"\" class=\"wp-image-2509\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-mysql-database-cpanel-1024x519.jpg 1024w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-mysql-database-cpanel-300x152.jpg 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-mysql-database-cpanel-768x389.jpg 768w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-mysql-database-cpanel.jpg 1433w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>3. Navigate to the &#8220;<strong>Current Databases<\/strong>&#8220;.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"613\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-current-databases-1024x613.jpg\" alt=\"\" class=\"wp-image-2520\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-current-databases-1024x613.jpg 1024w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-current-databases-300x180.jpg 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-current-databases-768x460.jpg 768w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-current-databases.jpg 1120w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>4. Locate the Database Name which you want to delete \u2192 Click on &#8220;<strong>Delete<\/strong>&#8220;.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"613\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/delete-mysql-database-cpanel-1024x613.jpg\" alt=\"\" class=\"wp-image-2521\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/delete-mysql-database-cpanel-1024x613.jpg 1024w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/delete-mysql-database-cpanel-300x180.jpg 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/delete-mysql-database-cpanel-768x460.jpg 768w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/delete-mysql-database-cpanel.jpg 1120w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"how_to_delete_mysql_user\"><\/span><strong>How to delete MySQL User?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>1. Log in to cPanel using&nbsp;<strong>Username&nbsp;<\/strong>&amp;&nbsp;<strong>Password<\/strong>.&nbsp;i.e;&nbsp;<em>(https:\/\/yourdomain.com:2083 or https:\/\/yourdomain.com\/cpanel)<\/em><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/Login-to-cpanel-using-user-and-password.png\" alt=\"\" class=\"wp-image-2388\"\/><\/figure>\n\n\n\n<p>2. Navigate to&nbsp;<strong>Databases \u2192 MySQL\u00ae Databases<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"1024\" height=\"519\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-mysql-database-cpanel-1024x519.jpg\" alt=\"\" class=\"wp-image-2509\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-mysql-database-cpanel-1024x519.jpg 1024w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-mysql-database-cpanel-300x152.jpg 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-mysql-database-cpanel-768x389.jpg 768w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-mysql-database-cpanel.jpg 1433w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>3. Navigate to <strong>Current Users<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"936\" height=\"481\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-current-users.jpg\" alt=\"\" class=\"wp-image-2523\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-current-users.jpg 936w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-current-users-300x154.jpg 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/navigate-to-current-users-768x395.jpg 768w\" sizes=\"(max-width: 936px) 100vw, 936px\" \/><\/figure>\n\n\n\n<p>4. Locate the MySQL User \u2192 Click on &#8220;<strong>Delete<\/strong>&#8220;.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"936\" height=\"481\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/remove-mysql-user.jpg\" alt=\"\" class=\"wp-image-2524\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/remove-mysql-user.jpg 936w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/remove-mysql-user-300x154.jpg 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/remove-mysql-user-768x395.jpg 768w\" sizes=\"(max-width: 936px) 100vw, 936px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Now that we\u2019ve gone over how to create MySQL database, MySQL user, delete MySQL database, delete MySQL user with the assignment of privileges to MySQL user with step by step instructions. Now you can perform any operation\/action described in this article.<\/p>\n\n\n\n<p>KnownHost offers 365 days a year, 24 hours a day, all 7 days of the week best in class technical support. A dedicated team is ready to help you with requests such as creating MySQL databases and users, should you need our assistance. You\u2019re not using KnownHost for the best web hosting experience? Well, why not? Check with\u00a0<a href=\"https:\/\/www.knownhost.com\/contact\">our Sales team<\/a>\u00a0to see what can KnownHost do for you in improving your <a href=\"https:\/\/www.knownhost.com\/web-hosting\">web hosting<\/a> experience.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Creating a MySQL database, User, and assigning that User to the Database through a command-line interface may get tricky for newbies who don&#8217;t know of it. Through cPanel, this job gets easier. All you have to do is perform some informed clicks and VOILA! You&#8217;re good to go! How to create a MySQL Database? 1. [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[101],"tags":[109,331,257,354,186,356,355,357],"class_list":["post-2508","post","type-post","status-publish","format-standard","hentry","category-cpanel","tag-cpanel","tag-create","tag-database","tag-delete","tag-mysql","tag-privileges","tag-remove","tag-user"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to create MySQL Database and User in cPanel? - KnownHost<\/title>\n<meta name=\"description\" content=\"Need to create a MySQL database for your web application? Read here to find out how to accomplish this on KnownHost servers using cPanel.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.knownhost.com\/kb\/how-to-create-mysql-database-and-user-in-cpanel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to create MySQL Database and User in cPanel? - KnownHost\" \/>\n<meta property=\"og:description\" content=\"Need to create a MySQL database for your web application? Read here to find out how to accomplish this on KnownHost servers using cPanel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.knownhost.com\/kb\/how-to-create-mysql-database-and-user-in-cpanel\/\" \/>\n<meta property=\"og:site_name\" content=\"KnownHost\" \/>\n<meta property=\"article:published_time\" content=\"2021-08-20T14:02:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-10-12T11:46:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/Login-to-cpanel-using-user-and-password.png\" \/>\n<meta name=\"author\" content=\"Somesh Z\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Somesh Z\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-create-mysql-database-and-user-in-cpanel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-create-mysql-database-and-user-in-cpanel\\\/\"},\"author\":{\"name\":\"Somesh Z\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#\\\/schema\\\/person\\\/8b518f13cf69dd00d147e577d63ff3b1\"},\"headline\":\"How to create MySQL Database and User in cPanel?\",\"datePublished\":\"2021-08-20T14:02:40+00:00\",\"dateModified\":\"2021-10-12T11:46:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-create-mysql-database-and-user-in-cpanel\\\/\"},\"wordCount\":485,\"image\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-create-mysql-database-and-user-in-cpanel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/Login-to-cpanel-using-user-and-password.png\",\"keywords\":[\"cpanel\",\"create\",\"database\",\"delete\",\"mysql\",\"privileges\",\"remove\",\"user\"],\"articleSection\":[\"cPanel\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-create-mysql-database-and-user-in-cpanel\\\/\",\"url\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-create-mysql-database-and-user-in-cpanel\\\/\",\"name\":\"How to create MySQL Database and User in cPanel? - KnownHost\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-create-mysql-database-and-user-in-cpanel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-create-mysql-database-and-user-in-cpanel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/Login-to-cpanel-using-user-and-password.png\",\"datePublished\":\"2021-08-20T14:02:40+00:00\",\"dateModified\":\"2021-10-12T11:46:08+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#\\\/schema\\\/person\\\/8b518f13cf69dd00d147e577d63ff3b1\"},\"description\":\"Need to create a MySQL database for your web application? Read here to find out how to accomplish this on KnownHost servers using cPanel.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-create-mysql-database-and-user-in-cpanel\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-create-mysql-database-and-user-in-cpanel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-create-mysql-database-and-user-in-cpanel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/Login-to-cpanel-using-user-and-password.png\",\"contentUrl\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/Login-to-cpanel-using-user-and-password.png\",\"width\":1002,\"height\":829},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/how-to-create-mysql-database-and-user-in-cpanel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to create MySQL Database and User in cPanel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#website\",\"url\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/\",\"name\":\"KnownHost\",\"description\":\"KnownHost provides a comprehensive webhosting knowledge base to help answer many of your common webhosting and linux questions.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#\\\/schema\\\/person\\\/8b518f13cf69dd00d147e577d63ff3b1\",\"name\":\"Somesh Z\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/276c97317c2d6905cc5a1bd9ceb10a0fd121cc4da22126f648fa88f95dcf32dd?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/276c97317c2d6905cc5a1bd9ceb10a0fd121cc4da22126f648fa88f95dcf32dd?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/276c97317c2d6905cc5a1bd9ceb10a0fd121cc4da22126f648fa88f95dcf32dd?s=96&d=mm&r=g\",\"caption\":\"Somesh Z\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to create MySQL Database and User in cPanel? - KnownHost","description":"Need to create a MySQL database for your web application? Read here to find out how to accomplish this on KnownHost servers using cPanel.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.knownhost.com\/kb\/how-to-create-mysql-database-and-user-in-cpanel\/","og_locale":"en_US","og_type":"article","og_title":"How to create MySQL Database and User in cPanel? - KnownHost","og_description":"Need to create a MySQL database for your web application? Read here to find out how to accomplish this on KnownHost servers using cPanel.","og_url":"https:\/\/www.knownhost.com\/kb\/how-to-create-mysql-database-and-user-in-cpanel\/","og_site_name":"KnownHost","article_published_time":"2021-08-20T14:02:40+00:00","article_modified_time":"2021-10-12T11:46:08+00:00","og_image":[{"url":"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/Login-to-cpanel-using-user-and-password.png","type":"","width":"","height":""}],"author":"Somesh Z","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Somesh Z","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.knownhost.com\/kb\/how-to-create-mysql-database-and-user-in-cpanel\/#article","isPartOf":{"@id":"https:\/\/www.knownhost.com\/kb\/how-to-create-mysql-database-and-user-in-cpanel\/"},"author":{"name":"Somesh Z","@id":"https:\/\/www.knownhost.com\/kb\/#\/schema\/person\/8b518f13cf69dd00d147e577d63ff3b1"},"headline":"How to create MySQL Database and User in cPanel?","datePublished":"2021-08-20T14:02:40+00:00","dateModified":"2021-10-12T11:46:08+00:00","mainEntityOfPage":{"@id":"https:\/\/www.knownhost.com\/kb\/how-to-create-mysql-database-and-user-in-cpanel\/"},"wordCount":485,"image":{"@id":"https:\/\/www.knownhost.com\/kb\/how-to-create-mysql-database-and-user-in-cpanel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/Login-to-cpanel-using-user-and-password.png","keywords":["cpanel","create","database","delete","mysql","privileges","remove","user"],"articleSection":["cPanel"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.knownhost.com\/kb\/how-to-create-mysql-database-and-user-in-cpanel\/","url":"https:\/\/www.knownhost.com\/kb\/how-to-create-mysql-database-and-user-in-cpanel\/","name":"How to create MySQL Database and User in cPanel? - KnownHost","isPartOf":{"@id":"https:\/\/www.knownhost.com\/kb\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.knownhost.com\/kb\/how-to-create-mysql-database-and-user-in-cpanel\/#primaryimage"},"image":{"@id":"https:\/\/www.knownhost.com\/kb\/how-to-create-mysql-database-and-user-in-cpanel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/Login-to-cpanel-using-user-and-password.png","datePublished":"2021-08-20T14:02:40+00:00","dateModified":"2021-10-12T11:46:08+00:00","author":{"@id":"https:\/\/www.knownhost.com\/kb\/#\/schema\/person\/8b518f13cf69dd00d147e577d63ff3b1"},"description":"Need to create a MySQL database for your web application? Read here to find out how to accomplish this on KnownHost servers using cPanel.","breadcrumb":{"@id":"https:\/\/www.knownhost.com\/kb\/how-to-create-mysql-database-and-user-in-cpanel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.knownhost.com\/kb\/how-to-create-mysql-database-and-user-in-cpanel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.knownhost.com\/kb\/how-to-create-mysql-database-and-user-in-cpanel\/#primaryimage","url":"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/Login-to-cpanel-using-user-and-password.png","contentUrl":"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/08\/Login-to-cpanel-using-user-and-password.png","width":1002,"height":829},{"@type":"BreadcrumbList","@id":"https:\/\/www.knownhost.com\/kb\/how-to-create-mysql-database-and-user-in-cpanel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.knownhost.com\/kb\/"},{"@type":"ListItem","position":2,"name":"How to create MySQL Database and User in cPanel?"}]},{"@type":"WebSite","@id":"https:\/\/www.knownhost.com\/kb\/#website","url":"https:\/\/www.knownhost.com\/kb\/","name":"KnownHost","description":"KnownHost provides a comprehensive webhosting knowledge base to help answer many of your common webhosting and linux questions.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.knownhost.com\/kb\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.knownhost.com\/kb\/#\/schema\/person\/8b518f13cf69dd00d147e577d63ff3b1","name":"Somesh Z","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/276c97317c2d6905cc5a1bd9ceb10a0fd121cc4da22126f648fa88f95dcf32dd?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/276c97317c2d6905cc5a1bd9ceb10a0fd121cc4da22126f648fa88f95dcf32dd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/276c97317c2d6905cc5a1bd9ceb10a0fd121cc4da22126f648fa88f95dcf32dd?s=96&d=mm&r=g","caption":"Somesh Z"}}]}},"_links":{"self":[{"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/posts\/2508","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/comments?post=2508"}],"version-history":[{"count":0,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/posts\/2508\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/media?parent=2508"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/categories?post=2508"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/tags?post=2508"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}