{"id":11841,"date":"2021-10-07T12:30:28","date_gmt":"2021-10-07T12:30:28","guid":{"rendered":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?p=11841"},"modified":"2024-04-23T14:09:30","modified_gmt":"2024-04-23T13:09:30","slug":"modify-database-user-privileges-plesk","status":"publish","type":"post","link":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/modify-database-user-privileges-plesk\/","title":{"rendered":"How to Modify Database User Privileges in Plesk Panel?"},"content":{"rendered":"<p>Privileges grant users the ability to change and manage databases. You can reassign or modify the Maria DB database user privileges with Plesk.<\/p>\n<h2>To Modify Database User Privileges<\/h2>\n<p>1. Log in to your Plesk.<\/p>\n<p>2. Select<strong> Databases<\/strong> from the navigation menu.<\/p>\n<p>All the operational databases in your Plesk account and related options will appear.<\/p>\n<p>3. Click on <strong>User Management<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-13224\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/10\/plesk_databases_user_management_censored.jpg\" alt=\"\" width=\"1899\" height=\"814\" \/><\/p>\n<p>A list of active database users will show up.<\/p>\n<p>4. Click on the name of the database user to change its privileges.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-13225\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/10\/plesk_databases_user_list.png\" alt=\"\" width=\"1184\" height=\"419\" \/><\/p>\n<p>A form with customization settings\u00a0for the user account is displayed.<\/p>\n<p>Scroll down and, you will spot the <strong>Privileges<\/strong> section divided as<em> Data Access<\/em> and <em>Structure Access<\/em>.<\/p>\n<p>5. Select the privileges you want to grant the user and click the <strong>OK<\/strong> button at the end form.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-13226\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/10\/plesk_databases_user_privileges.png\" alt=\"\" width=\"1226\" height=\"431\" \/><\/p>\n<p>That is all it takes to grant user privileges to a database in Plesk.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Privileges grant users the ability to change and manage databases. You can reassign or modify the Maria DB database user privileges with Plesk. To Modify Database User Privileges 1. Log in to your Plesk. 2. Select Databases from the navigation menu. All the operational databases in your Plesk account and related options will appear. 3. [&hellip;]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[230,41,10],"tags":[1536,2517,828,829,2518,1399,1158],"class_list":["post-11841","post","type-post","status-publish","format-standard","placeholder-for-hentry","category-database","category-howtos","category-plesk-faq","tag-database-management","tag-database-user-privileges-plesk","tag-database-user-in-plesk","tag-databases-in-plesk","tag-maria-db-user-privileges","tag-mariadb-database","tag-plesk-users"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Modify Database User Privileges in Plesk Panel?<\/title>\n<meta name=\"description\" content=\"In this short tutorial, you will learn to modify a database to grant privileges to a certain user with the help of the Plesk panel.\" \/>\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.milesweb.co.uk\/hosting-faqs\/modify-database-user-privileges-plesk\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Modify Database User Privileges in Plesk Panel?\" \/>\n<meta property=\"og:description\" content=\"In this short tutorial, you will learn to modify a database to grant privileges to a certain user with the help of the Plesk panel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/modify-database-user-privileges-plesk\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"article:published_time\" content=\"2021-10-07T12:30:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-23T13:09:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/10\/plesk_databases_user_management_censored.jpg\" \/>\n<meta name=\"author\" content=\"Prasad Khartadkar\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Prasad Khartadkar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated 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\":\"WebPage\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/modify-database-user-privileges-plesk\/\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/modify-database-user-privileges-plesk\/\",\"name\":\"How to Modify Database User Privileges in Plesk Panel?\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/modify-database-user-privileges-plesk\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/modify-database-user-privileges-plesk\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/10\/plesk_databases_user_management_censored.jpg\",\"datePublished\":\"2021-10-07T12:30:28+00:00\",\"dateModified\":\"2024-04-23T13:09:30+00:00\",\"author\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/c9138a9488172a8d0aa2d4f40878d83e\"},\"description\":\"In this short tutorial, you will learn to modify a database to grant privileges to a certain user with the help of the Plesk panel.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/modify-database-user-privileges-plesk\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/modify-database-user-privileges-plesk\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/modify-database-user-privileges-plesk\/#primaryimage\",\"url\":\"\",\"contentUrl\":\"\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/modify-database-user-privileges-plesk\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Modify Database User Privileges in Plesk Panel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\",\"name\":\"Web Hosting FAQs by MilesWeb\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/c9138a9488172a8d0aa2d4f40878d83e\",\"name\":\"Prasad Khartadkar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/fafb102a39aa8f8d38a11f3e2dcfa746?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/fafb102a39aa8f8d38a11f3e2dcfa746?s=96&d=blank&r=g\",\"caption\":\"Prasad Khartadkar\"},\"description\":\"Prasad is a business grad specialized in Marketing. He has garnered experience as a technical content writer and a digital marketer that he brings out in his work. He likes reading classics and travel in his free time.\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/prasad-khartadkar\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Modify Database User Privileges in Plesk Panel?","description":"In this short tutorial, you will learn to modify a database to grant privileges to a certain user with the help of the Plesk panel.","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.milesweb.co.uk\/hosting-faqs\/modify-database-user-privileges-plesk\/","og_locale":"en_GB","og_type":"article","og_title":"How to Modify Database User Privileges in Plesk Panel?","og_description":"In this short tutorial, you will learn to modify a database to grant privileges to a certain user with the help of the Plesk panel.","og_url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/modify-database-user-privileges-plesk\/","og_site_name":"Web Hosting FAQs by MilesWeb","article_published_time":"2021-10-07T12:30:28+00:00","article_modified_time":"2024-04-23T13:09:30+00:00","og_image":[{"url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/10\/plesk_databases_user_management_censored.jpg","type":"","width":"","height":""}],"author":"Prasad Khartadkar","twitter_misc":{"Written by":"Prasad Khartadkar","Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/modify-database-user-privileges-plesk\/","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/modify-database-user-privileges-plesk\/","name":"How to Modify Database User Privileges in Plesk Panel?","isPartOf":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/modify-database-user-privileges-plesk\/#primaryimage"},"image":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/modify-database-user-privileges-plesk\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/10\/plesk_databases_user_management_censored.jpg","datePublished":"2021-10-07T12:30:28+00:00","dateModified":"2024-04-23T13:09:30+00:00","author":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/c9138a9488172a8d0aa2d4f40878d83e"},"description":"In this short tutorial, you will learn to modify a database to grant privileges to a certain user with the help of the Plesk panel.","breadcrumb":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/modify-database-user-privileges-plesk\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.milesweb.co.uk\/hosting-faqs\/modify-database-user-privileges-plesk\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/modify-database-user-privileges-plesk\/#primaryimage","url":"","contentUrl":""},{"@type":"BreadcrumbList","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/modify-database-user-privileges-plesk\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/"},{"@type":"ListItem","position":2,"name":"How to Modify Database User Privileges in Plesk Panel?"}]},{"@type":"WebSite","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/","name":"Web Hosting FAQs by MilesWeb","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/c9138a9488172a8d0aa2d4f40878d83e","name":"Prasad Khartadkar","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/fafb102a39aa8f8d38a11f3e2dcfa746?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/fafb102a39aa8f8d38a11f3e2dcfa746?s=96&d=blank&r=g","caption":"Prasad Khartadkar"},"description":"Prasad is a business grad specialized in Marketing. He has garnered experience as a technical content writer and a digital marketer that he brings out in his work. He likes reading classics and travel in his free time.","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/prasad-khartadkar\/"}]}},"views":353,"_links":{"self":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/11841","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/comments?post=11841"}],"version-history":[{"count":3,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/11841\/revisions"}],"predecessor-version":[{"id":15489,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/11841\/revisions\/15489"}],"wp:attachment":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/media?parent=11841"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/categories?post=11841"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/tags?post=11841"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}