{"id":14176,"date":"2021-10-07T12:30:18","date_gmt":"2021-10-07T12:30:18","guid":{"rendered":"https:\/\/www.milesweb.in\/hosting-faqs\/?p=14176"},"modified":"2021-10-26T11:12:40","modified_gmt":"2021-10-26T11:12:40","slug":"modify-database-user-privileges-plesk","status":"publish","type":"post","link":"https:\/\/www.milesweb.in\/hosting-faqs\/modify-database-user-privileges-plesk\/","title":{"rendered":"How to Modify Database User Privileges in Plesk Panel?"},"content":{"rendered":"<p><strong>Watch this video for a step by step process on How to Modify Database User Privileges in Plesk Panel<\/strong><\/p>\n<div class=\"youtube-video\" style=\"border: 1px solid #ddd;\"><iframe src=\"https:\/\/www.youtube.com\/embed\/Vz6Ux6PZaIA\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/div>\n<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.in\/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.in\/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.in\/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>Watch this video for a step by step process on How to Modify Database User Privileges in Plesk Panel 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 [&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":[1555,2540,861,1992,2541,1420,1177],"class_list":["post-14176","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 v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\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.in\/hosting-faqs\/modify-database-user-privileges-plesk\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\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.in\/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:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-10-26T11:12:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.milesweb.in\/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=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/modify-database-user-privileges-plesk\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/modify-database-user-privileges-plesk\\\/\"},\"author\":{\"name\":\"Prasad Khartadkar\",\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/#\\\/schema\\\/person\\\/c9138a9488172a8d0aa2d4f40878d83e\"},\"headline\":\"How to Modify Database User Privileges in Plesk Panel?\",\"datePublished\":\"2021-10-07T12:30:18+00:00\",\"dateModified\":\"2021-10-26T11:12:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/modify-database-user-privileges-plesk\\\/\"},\"wordCount\":164,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/modify-database-user-privileges-plesk\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/wp-content\\\/uploads\\\/2021\\\/10\\\/plesk_databases_user_management_censored.jpg\",\"keywords\":[\"database management\",\"Database User Privileges Plesk\",\"database-user in Plesk\",\"databases in Plesk\",\"Maria DB user privileges\",\"mariadb database\",\"Plesk users\"],\"articleSection\":[\"Database\",\"How-Tos\",\"Plesk FAQ\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/modify-database-user-privileges-plesk\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/modify-database-user-privileges-plesk\\\/\",\"url\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/modify-database-user-privileges-plesk\\\/\",\"name\":\"How to Modify Database User Privileges in Plesk Panel?\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/modify-database-user-privileges-plesk\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/modify-database-user-privileges-plesk\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/wp-content\\\/uploads\\\/2021\\\/10\\\/plesk_databases_user_management_censored.jpg\",\"datePublished\":\"2021-10-07T12:30:18+00:00\",\"dateModified\":\"2021-10-26T11:12:40+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/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.in\\\/hosting-faqs\\\/modify-database-user-privileges-plesk\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/modify-database-user-privileges-plesk\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/modify-database-user-privileges-plesk\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/plesk_wp_act_deact_plugins.png\",\"contentUrl\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/plesk_wp_act_deact_plugins.png\",\"width\":1585,\"height\":414},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/modify-database-user-privileges-plesk\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Modify Database User Privileges in Plesk Panel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/#website\",\"url\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/\",\"name\":\"Web Hosting FAQs by MilesWeb\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/#\\\/schema\\\/person\\\/c9138a9488172a8d0aa2d4f40878d83e\",\"name\":\"Prasad Khartadkar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/Prasad-K.-1-150x150.jpg\",\"url\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/Prasad-K.-1-150x150.jpg\",\"contentUrl\":\"https:\\\/\\\/www.milesweb.in\\\/hosting-faqs\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/Prasad-K.-1-150x150.jpg\",\"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.\",\"sameAs\":[\"https:\\\/\\\/www.milesweb.in\"],\"url\":\"https:\\\/\\\/www.milesweb.in\\\/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.in\/hosting-faqs\/modify-database-user-privileges-plesk\/","og_locale":"en_US","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.in\/hosting-faqs\/modify-database-user-privileges-plesk\/","og_site_name":"Web Hosting FAQs by MilesWeb","article_published_time":"2021-10-07T12:30:18+00:00","article_modified_time":"2021-10-26T11:12:40+00:00","og_image":[{"url":"https:\/\/www.milesweb.in\/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","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/modify-database-user-privileges-plesk\/#article","isPartOf":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/modify-database-user-privileges-plesk\/"},"author":{"name":"Prasad Khartadkar","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/c9138a9488172a8d0aa2d4f40878d83e"},"headline":"How to Modify Database User Privileges in Plesk Panel?","datePublished":"2021-10-07T12:30:18+00:00","dateModified":"2021-10-26T11:12:40+00:00","mainEntityOfPage":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/modify-database-user-privileges-plesk\/"},"wordCount":164,"commentCount":0,"image":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/modify-database-user-privileges-plesk\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/10\/plesk_databases_user_management_censored.jpg","keywords":["database management","Database User Privileges Plesk","database-user in Plesk","databases in Plesk","Maria DB user privileges","mariadb database","Plesk users"],"articleSection":["Database","How-Tos","Plesk FAQ"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.milesweb.in\/hosting-faqs\/modify-database-user-privileges-plesk\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/modify-database-user-privileges-plesk\/","url":"https:\/\/www.milesweb.in\/hosting-faqs\/modify-database-user-privileges-plesk\/","name":"How to Modify Database User Privileges in Plesk Panel?","isPartOf":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/modify-database-user-privileges-plesk\/#primaryimage"},"image":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/modify-database-user-privileges-plesk\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/10\/plesk_databases_user_management_censored.jpg","datePublished":"2021-10-07T12:30:18+00:00","dateModified":"2021-10-26T11:12:40+00:00","author":{"@id":"https:\/\/www.milesweb.in\/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.in\/hosting-faqs\/modify-database-user-privileges-plesk\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.milesweb.in\/hosting-faqs\/modify-database-user-privileges-plesk\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/modify-database-user-privileges-plesk\/#primaryimage","url":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2019\/07\/plesk_wp_act_deact_plugins.png","contentUrl":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2019\/07\/plesk_wp_act_deact_plugins.png","width":1585,"height":414},{"@type":"BreadcrumbList","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/modify-database-user-privileges-plesk\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.milesweb.in\/hosting-faqs\/"},{"@type":"ListItem","position":2,"name":"How to Modify Database User Privileges in Plesk Panel?"}]},{"@type":"WebSite","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#website","url":"https:\/\/www.milesweb.in\/hosting-faqs\/","name":"Web Hosting FAQs by MilesWeb","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.milesweb.in\/hosting-faqs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/c9138a9488172a8d0aa2d4f40878d83e","name":"Prasad Khartadkar","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/08\/Prasad-K.-1-150x150.jpg","url":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/08\/Prasad-K.-1-150x150.jpg","contentUrl":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/08\/Prasad-K.-1-150x150.jpg","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.","sameAs":["https:\/\/www.milesweb.in"],"url":"https:\/\/www.milesweb.in\/hosting-faqs\/author\/prasad-khartadkar\/"}]}},"_links":{"self":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts\/14176","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/comments?post=14176"}],"version-history":[{"count":3,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts\/14176\/revisions"}],"predecessor-version":[{"id":14476,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts\/14176\/revisions\/14476"}],"wp:attachment":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/media?parent=14176"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/categories?post=14176"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/tags?post=14176"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}