{"id":529,"date":"2013-01-29T18:04:02","date_gmt":"2013-01-29T18:04:02","guid":{"rendered":"https:\/\/www.inmotionhosting.com\/support\/2013\/01\/29\/create-db-user\/"},"modified":"2021-08-16T23:23:31","modified_gmt":"2021-08-17T03:23:31","slug":"create-database-user","status":"publish","type":"post","link":"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/create-database-user\/","title":{"rendered":"How to create and attach a database user in cPanel"},"content":{"rendered":"

Generally, when you want to create a database in the cPanel, using the MySQL Database wizard is the fastest and easiest way. This creates both the database and a user for that database. However, you may need to either add a database user to a database or wish to create a single user you want to add to multiple databases. In that case, you will need to create the users manually. This article will guide you through how to create and attach a database user in cPanel<\/strong>.<\/p>\n

Creating the database user<\/h2>\n
    \n
  1. Log into your cPanel dashboard<\/a>.<\/li>\n
  2. Locate the Databases icon from your main cPanel page and click on the MySQL Databases icon.
    \n    \"\"<\/a>\n
    \u00a0<\/div>\n<\/li>\n
  3. Once inside the database area, scroll down until you see the MySQL Users Add New User<\/b> section. From here, you will see the form to create your new user. Note that the database name will always be prefixed with your cpanel username. Add the second portion to create the new database username. For example, our new user will be named inmoti6_imhtest<\/em>.
    \n    \"\"<\/a>\n
    \u00a0<\/div>\n<\/li>\n
  4. Type in the password you desire for both the Password<\/b> and Password (Again)<\/b> fields.<\/li>\n
  5. Click the Create User<\/b> button to complete the database user creation.<\/li>\n<\/ol>\n

    <\/a><\/p>\n

    Assign the user to one or more databases<\/h2>\n
    Now that you have created the user, it is time to assign it to the database or databases you wish for it to access. You will begin from the same Database page where you created the user.<\/div>\n
      \n
    1. Locate the Add User to database<\/b> section. You will see two dropdowns here. Select your desired user from the top dropdown and the database you wish to add it to from the lower dropdown.
      \n      \"\"<\/a>\n
      \u00a0<\/div>\n<\/li>\n
    2. Click the Add<\/b> button to save the changes.<\/li>\n
    3. You are brought to a screen that allows you to select privileges. Generally speaking you will want to click the checkbox for ALL PRIVILEGES.<\/b> Selecting individual privileges is a customization for advanced users.
      \n      \"\"<\/a>\n
      \u00a0<\/div>\n<\/li>\n
    4. Click the Make Changes<\/b> button at the bottom to save the user and privileges to the database. You will be able to see the new user in the user list for each database they are assigned to in the database list.
      \n      \"\"<\/a>\n
      \u00a0<\/div>\n<\/li>\n
    5. Repeat steps 1-4 for any additional databases you want to allow the user to have access to.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

      Generally, when you want to create a database in the cPanel, using the MySQL Database wizard is the fastest and easiest way. This creates both the database and a user for that database. However, you may need to either add a database user to a database or wish to create a single user you want Read More ><\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[51,4288,4305],"tags":[],"class_list":["post-529","post","type-post","status-publish","format-standard","hentry","category-cpanel","category-website","category-databases"],"acf":[],"yoast_head":"\nHow to create and attach a database user in cPanel | InMotion Hosting<\/title>\n<meta name=\"description\" content=\"This article guides you on how to create a database user and assign them to one or more databases in 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.inmotionhosting.com\/support\/edu\/cpanel\/create-database-user\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to create and attach a database user in cPanel | InMotion Hosting\" \/>\n<meta property=\"og:description\" content=\"This article guides you on how to create a database user and assign them to one or more databases in cPanel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/create-database-user\/\" \/>\n<meta property=\"og:site_name\" content=\"InMotion Hosting Support Center\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/inmotionhosting\/\" \/>\n<meta property=\"article:published_time\" content=\"2013-01-29T18:04:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-08-17T03:23:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/01\/cm-cpanel-databases1.png\" \/>\n<meta name=\"author\" content=\"Scott Mitchell\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:site\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Scott Mitchell\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/create-database-user\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/create-database-user\/\"},\"author\":{\"name\":\"Scott Mitchell\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/d850efb28ef3573db7d24b0d8fa9eaed\"},\"headline\":\"How to create and attach a database user in cPanel\",\"datePublished\":\"2013-01-29T18:04:02+00:00\",\"dateModified\":\"2021-08-17T03:23:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/create-database-user\/\"},\"wordCount\":392,\"commentCount\":7,\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/create-database-user\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/01\/cm-cpanel-databases1.png\",\"articleSection\":[\"cPanel\",\"Website\",\"Working with Databases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/create-database-user\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/create-database-user\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/create-database-user\/\",\"name\":\"How to create and attach a database user in cPanel | InMotion Hosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/create-database-user\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/create-database-user\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/01\/cm-cpanel-databases1.png\",\"datePublished\":\"2013-01-29T18:04:02+00:00\",\"dateModified\":\"2021-08-17T03:23:31+00:00\",\"description\":\"This article guides you on how to create a database user and assign them to one or more databases in cPanel.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/create-database-user\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/create-database-user\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/create-database-user\/#primaryimage\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/01\/cm-cpanel-databases1.png\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/01\/cm-cpanel-databases1.png\",\"width\":580,\"height\":208},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/create-database-user\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.inmotionhosting.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to create and attach a database user in cPanel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"name\":\"InMotion Hosting Support Center\",\"description\":\"Web Hosting Support & Tutorials\",\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\",\"name\":\"InMotion Hosting\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"width\":696,\"height\":696,\"caption\":\"InMotion Hosting\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/inmotionhosting\/\",\"https:\/\/x.com\/InMotionHosting\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/d850efb28ef3573db7d24b0d8fa9eaed\",\"name\":\"Scott Mitchell\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/author\/scott\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to create and attach a database user in cPanel | InMotion Hosting","description":"This article guides you on how to create a database user and assign them to one or more databases in 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.inmotionhosting.com\/support\/edu\/cpanel\/create-database-user\/","og_locale":"en_US","og_type":"article","og_title":"How to create and attach a database user in cPanel | InMotion Hosting","og_description":"This article guides you on how to create a database user and assign them to one or more databases in cPanel.","og_url":"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/create-database-user\/","og_site_name":"InMotion Hosting Support Center","article_publisher":"https:\/\/www.facebook.com\/inmotionhosting\/","article_published_time":"2013-01-29T18:04:02+00:00","article_modified_time":"2021-08-17T03:23:31+00:00","og_image":[{"url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/01\/cm-cpanel-databases1.png","type":"","width":"","height":""}],"author":"Scott Mitchell","twitter_card":"summary_large_image","twitter_creator":"@InMotionHosting","twitter_site":"@InMotionHosting","twitter_misc":{"Written by":"Scott Mitchell","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/create-database-user\/#article","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/create-database-user\/"},"author":{"name":"Scott Mitchell","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/d850efb28ef3573db7d24b0d8fa9eaed"},"headline":"How to create and attach a database user in cPanel","datePublished":"2013-01-29T18:04:02+00:00","dateModified":"2021-08-17T03:23:31+00:00","mainEntityOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/create-database-user\/"},"wordCount":392,"commentCount":7,"publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/create-database-user\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/01\/cm-cpanel-databases1.png","articleSection":["cPanel","Website","Working with Databases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/create-database-user\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/create-database-user\/","url":"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/create-database-user\/","name":"How to create and attach a database user in cPanel | InMotion Hosting","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/create-database-user\/#primaryimage"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/create-database-user\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/01\/cm-cpanel-databases1.png","datePublished":"2013-01-29T18:04:02+00:00","dateModified":"2021-08-17T03:23:31+00:00","description":"This article guides you on how to create a database user and assign them to one or more databases in cPanel.","breadcrumb":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/create-database-user\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/create-database-user\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/create-database-user\/#primaryimage","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/01\/cm-cpanel-databases1.png","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/01\/cm-cpanel-databases1.png","width":580,"height":208},{"@type":"BreadcrumbList","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/create-database-user\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.inmotionhosting.com\/support\/"},{"@type":"ListItem","position":2,"name":"How to create and attach a database user in cPanel"}]},{"@type":"WebSite","@id":"https:\/\/www.inmotionhosting.com\/support\/#website","url":"https:\/\/www.inmotionhosting.com\/support\/","name":"InMotion Hosting Support Center","description":"Web Hosting Support & Tutorials","publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.inmotionhosting.com\/support\/#organization","name":"InMotion Hosting","url":"https:\/\/www.inmotionhosting.com\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","width":696,"height":696,"caption":"InMotion Hosting"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/inmotionhosting\/","https:\/\/x.com\/InMotionHosting"]},{"@type":"Person","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/d850efb28ef3573db7d24b0d8fa9eaed","name":"Scott Mitchell","url":"https:\/\/www.inmotionhosting.com\/support\/author\/scott\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"primary_category":null,"_links":{"self":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/529","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/comments?post=529"}],"version-history":[{"count":4,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/529\/revisions"}],"predecessor-version":[{"id":85009,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/529\/revisions\/85009"}],"wp:attachment":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/media?parent=529"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/categories?post=529"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/tags?post=529"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}