{"id":43,"date":"2016-09-18T16:12:01","date_gmt":"2016-09-18T16:12:01","guid":{"rendered":"https:\/\/example.com\/wordpress\/?p=43"},"modified":"2016-09-18T16:12:01","modified_gmt":"2016-09-18T16:12:01","slug":"how-to-add-a-user-to-a-database-and-add-privileges","status":"publish","type":"post","link":"https:\/\/www.reselhost.eu\/kb\/how-to-add-a-user-to-a-database-and-add-privileges\/","title":{"rendered":"How to add a user to a database and add privileges?"},"content":{"rendered":"<p><span style=\"font-size: medium;\"><strong>1.<\/strong> Log into your cPanel account.<\/span><\/p>\n<p><span style=\"font-size: medium;\"><strong>2.<\/strong> In the <strong>Databases<\/strong> section, click on <strong>MySQL Databases<\/strong> Icon.<br \/>\n<img decoding=\"async\" src=\"\/img\/mysql-databases-icon.gif\" alt=\"\" align=\"middle\" \/><\/span><\/p>\n<p><span style=\"font-size: medium;\"><strong>3.<\/strong> Scroll down to the end of the page and under <strong>Add User to Database<\/strong>, select a user from the dropdown list, and then choose a Database from the list.<\/span><\/p>\n<p><span style=\"font-size: medium;\"><strong>4.<\/strong> Click on the <strong>Add<\/strong> button.<\/span><br \/>\n<span style=\"font-size: medium;\"><img decoding=\"async\" src=\"\/img\/add-db.gif\" alt=\"\" \/><\/span><\/p>\n<p><span style=\"font-size: medium;\"><strong>5.<\/strong> On <strong>Manage User Privileges<\/strong>, mark the box <strong>ALL PRIVILEGES<\/strong> and click on <strong>Make Changes<\/strong>.<\/span><br \/>\n<span style=\"font-size: medium;\"><img decoding=\"async\" src=\"\/img\/add-privileges.gif\" alt=\"\" \/><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. Log into your cPanel account. 2. In the Databases section, click on MySQL Databases Icon. 3. Scroll down to the end of the page and under Add User to Database, select a user from the dropdown list, and then choose a Database from the list. 4. Click on the Add button. 5. On Manage [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[],"class_list":["post-43","post","type-post","status-publish","format-standard","hentry","category-databases-mysql-cpanel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to add a user to a database and add privileges? - Reselhost<\/title>\n<meta name=\"description\" content=\"How to add a user to a database and add privileges? Reseller Hosting 50% OFF Unlimited cPanel Accounts Free SSL \u20ac 4.49\/month\" \/>\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.reselhost.eu\/kb\/how-to-add-a-user-to-a-database-and-add-privileges\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to add a user to a database and add privileges? - Reselhost\" \/>\n<meta property=\"og:description\" content=\"How to add a user to a database and add privileges? Reseller Hosting 50% OFF Unlimited cPanel Accounts Free SSL \u20ac 4.49\/month\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.reselhost.eu\/kb\/how-to-add-a-user-to-a-database-and-add-privileges\/\" \/>\n<meta property=\"og:site_name\" content=\"Reselhost\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/reselhost\" \/>\n<meta property=\"article:published_time\" content=\"2016-09-18T16:12:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.reselhost.eu\/kb\/wp-content\/uploads\/2021\/08\/face-anuncio.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"648\" \/>\n\t<meta property=\"og:image:height\" content=\"441\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"intelhost\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@reselhost\" \/>\n<meta name=\"twitter:site\" content=\"@reselhost\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"intelhost\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.reselhost.eu\/kb\/how-to-add-a-user-to-a-database-and-add-privileges\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.reselhost.eu\/kb\/how-to-add-a-user-to-a-database-and-add-privileges\/\"},\"author\":{\"name\":\"intelhost\",\"@id\":\"https:\/\/www.reselhost.eu\/kb\/#\/schema\/person\/cc9804f5a4bd9b28316dd9188422dd8e\"},\"headline\":\"How to add a user to a database and add privileges?\",\"datePublished\":\"2016-09-18T16:12:01+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.reselhost.eu\/kb\/how-to-add-a-user-to-a-database-and-add-privileges\/\"},\"wordCount\":73,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.reselhost.eu\/kb\/#organization\"},\"articleSection\":[\"Databases MySQL cPanel\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.reselhost.eu\/kb\/how-to-add-a-user-to-a-database-and-add-privileges\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.reselhost.eu\/kb\/how-to-add-a-user-to-a-database-and-add-privileges\/\",\"url\":\"https:\/\/www.reselhost.eu\/kb\/how-to-add-a-user-to-a-database-and-add-privileges\/\",\"name\":\"How to add a user to a database and add privileges? - Reselhost\",\"isPartOf\":{\"@id\":\"https:\/\/www.reselhost.eu\/kb\/#website\"},\"datePublished\":\"2016-09-18T16:12:01+00:00\",\"description\":\"How to add a user to a database and add privileges? Reseller Hosting 50% OFF Unlimited cPanel Accounts Free SSL \u20ac 4.49\/month\",\"breadcrumb\":{\"@id\":\"https:\/\/www.reselhost.eu\/kb\/how-to-add-a-user-to-a-database-and-add-privileges\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.reselhost.eu\/kb\/how-to-add-a-user-to-a-database-and-add-privileges\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.reselhost.eu\/kb\/how-to-add-a-user-to-a-database-and-add-privileges\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.reselhost.eu\/kb\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to add a user to a database and add privileges?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.reselhost.eu\/kb\/#website\",\"url\":\"https:\/\/www.reselhost.eu\/kb\/\",\"name\":\"Reselhost\",\"description\":\"Knowledge Base Web Hosting Reseller Hosting\",\"publisher\":{\"@id\":\"https:\/\/www.reselhost.eu\/kb\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.reselhost.eu\/kb\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.reselhost.eu\/kb\/#organization\",\"name\":\"Reselhost LLC\",\"alternateName\":\"Reselhost\",\"url\":\"https:\/\/www.reselhost.eu\/kb\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.reselhost.eu\/kb\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.reselhost.eu\/kb\/wp-content\/uploads\/2023\/06\/logo-grande-ok.jpg\",\"contentUrl\":\"https:\/\/www.reselhost.eu\/kb\/wp-content\/uploads\/2023\/06\/logo-grande-ok.jpg\",\"width\":500,\"height\":500,\"caption\":\"Reselhost LLC\"},\"image\":{\"@id\":\"https:\/\/www.reselhost.eu\/kb\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/reselhost\",\"https:\/\/x.com\/reselhost\",\"https:\/\/www.instagram.com\/reselhost\",\"https:\/\/www.linkedin.com\/in\/reselhost\",\"https:\/\/www.youtube.com\/@reselhost\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.reselhost.eu\/kb\/#\/schema\/person\/cc9804f5a4bd9b28316dd9188422dd8e\",\"name\":\"intelhost\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.reselhost.eu\/kb\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e889bfe45e57e333934f731d2f44d88bc7a50c1d0b8c9b5c48e9a69b5a775459?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e889bfe45e57e333934f731d2f44d88bc7a50c1d0b8c9b5c48e9a69b5a775459?s=96&d=mm&r=g\",\"caption\":\"intelhost\"},\"sameAs\":[\"https:\/\/www.intelhost.net\/kb\"],\"url\":\"https:\/\/www.reselhost.eu\/kb\/author\/intelhost\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to add a user to a database and add privileges? - Reselhost","description":"How to add a user to a database and add privileges? Reseller Hosting 50% OFF Unlimited cPanel Accounts Free SSL \u20ac 4.49\/month","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.reselhost.eu\/kb\/how-to-add-a-user-to-a-database-and-add-privileges\/","og_locale":"en_GB","og_type":"article","og_title":"How to add a user to a database and add privileges? - Reselhost","og_description":"How to add a user to a database and add privileges? Reseller Hosting 50% OFF Unlimited cPanel Accounts Free SSL \u20ac 4.49\/month","og_url":"https:\/\/www.reselhost.eu\/kb\/how-to-add-a-user-to-a-database-and-add-privileges\/","og_site_name":"Reselhost","article_publisher":"https:\/\/www.facebook.com\/reselhost","article_published_time":"2016-09-18T16:12:01+00:00","og_image":[{"width":648,"height":441,"url":"https:\/\/www.reselhost.eu\/kb\/wp-content\/uploads\/2021\/08\/face-anuncio.jpg","type":"image\/jpeg"}],"author":"intelhost","twitter_card":"summary_large_image","twitter_creator":"@reselhost","twitter_site":"@reselhost","twitter_misc":{"Written by":"intelhost"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.reselhost.eu\/kb\/how-to-add-a-user-to-a-database-and-add-privileges\/#article","isPartOf":{"@id":"https:\/\/www.reselhost.eu\/kb\/how-to-add-a-user-to-a-database-and-add-privileges\/"},"author":{"name":"intelhost","@id":"https:\/\/www.reselhost.eu\/kb\/#\/schema\/person\/cc9804f5a4bd9b28316dd9188422dd8e"},"headline":"How to add a user to a database and add privileges?","datePublished":"2016-09-18T16:12:01+00:00","mainEntityOfPage":{"@id":"https:\/\/www.reselhost.eu\/kb\/how-to-add-a-user-to-a-database-and-add-privileges\/"},"wordCount":73,"commentCount":0,"publisher":{"@id":"https:\/\/www.reselhost.eu\/kb\/#organization"},"articleSection":["Databases MySQL cPanel"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.reselhost.eu\/kb\/how-to-add-a-user-to-a-database-and-add-privileges\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.reselhost.eu\/kb\/how-to-add-a-user-to-a-database-and-add-privileges\/","url":"https:\/\/www.reselhost.eu\/kb\/how-to-add-a-user-to-a-database-and-add-privileges\/","name":"How to add a user to a database and add privileges? - Reselhost","isPartOf":{"@id":"https:\/\/www.reselhost.eu\/kb\/#website"},"datePublished":"2016-09-18T16:12:01+00:00","description":"How to add a user to a database and add privileges? Reseller Hosting 50% OFF Unlimited cPanel Accounts Free SSL \u20ac 4.49\/month","breadcrumb":{"@id":"https:\/\/www.reselhost.eu\/kb\/how-to-add-a-user-to-a-database-and-add-privileges\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.reselhost.eu\/kb\/how-to-add-a-user-to-a-database-and-add-privileges\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.reselhost.eu\/kb\/how-to-add-a-user-to-a-database-and-add-privileges\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.reselhost.eu\/kb\/"},{"@type":"ListItem","position":2,"name":"How to add a user to a database and add privileges?"}]},{"@type":"WebSite","@id":"https:\/\/www.reselhost.eu\/kb\/#website","url":"https:\/\/www.reselhost.eu\/kb\/","name":"Reselhost","description":"Knowledge Base Web Hosting Reseller Hosting","publisher":{"@id":"https:\/\/www.reselhost.eu\/kb\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.reselhost.eu\/kb\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/www.reselhost.eu\/kb\/#organization","name":"Reselhost LLC","alternateName":"Reselhost","url":"https:\/\/www.reselhost.eu\/kb\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.reselhost.eu\/kb\/#\/schema\/logo\/image\/","url":"https:\/\/www.reselhost.eu\/kb\/wp-content\/uploads\/2023\/06\/logo-grande-ok.jpg","contentUrl":"https:\/\/www.reselhost.eu\/kb\/wp-content\/uploads\/2023\/06\/logo-grande-ok.jpg","width":500,"height":500,"caption":"Reselhost LLC"},"image":{"@id":"https:\/\/www.reselhost.eu\/kb\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/reselhost","https:\/\/x.com\/reselhost","https:\/\/www.instagram.com\/reselhost","https:\/\/www.linkedin.com\/in\/reselhost","https:\/\/www.youtube.com\/@reselhost"]},{"@type":"Person","@id":"https:\/\/www.reselhost.eu\/kb\/#\/schema\/person\/cc9804f5a4bd9b28316dd9188422dd8e","name":"intelhost","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.reselhost.eu\/kb\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e889bfe45e57e333934f731d2f44d88bc7a50c1d0b8c9b5c48e9a69b5a775459?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e889bfe45e57e333934f731d2f44d88bc7a50c1d0b8c9b5c48e9a69b5a775459?s=96&d=mm&r=g","caption":"intelhost"},"sameAs":["https:\/\/www.intelhost.net\/kb"],"url":"https:\/\/www.reselhost.eu\/kb\/author\/intelhost\/"}]}},"_links":{"self":[{"href":"https:\/\/www.reselhost.eu\/kb\/wp-json\/wp\/v2\/posts\/43","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.reselhost.eu\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.reselhost.eu\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.reselhost.eu\/kb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.reselhost.eu\/kb\/wp-json\/wp\/v2\/comments?post=43"}],"version-history":[{"count":0,"href":"https:\/\/www.reselhost.eu\/kb\/wp-json\/wp\/v2\/posts\/43\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.reselhost.eu\/kb\/wp-json\/wp\/v2\/media?parent=43"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.reselhost.eu\/kb\/wp-json\/wp\/v2\/categories?post=43"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.reselhost.eu\/kb\/wp-json\/wp\/v2\/tags?post=43"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}