{"id":14171,"date":"2021-10-06T12:24:19","date_gmt":"2021-10-06T12:24:19","guid":{"rendered":"https:\/\/www.milesweb.in\/hosting-faqs\/?p=14171"},"modified":"2021-10-26T11:06:09","modified_gmt":"2021-10-26T11:06:09","slug":"modify-database-user-privileges-directadmin","status":"publish","type":"post","link":"https:\/\/www.milesweb.in\/hosting-faqs\/modify-database-user-privileges-directadmin\/","title":{"rendered":"How to Modify Database User Privileges in DirectAdmin?"},"content":{"rendered":"<p><strong>Watch this video for a step by step process on How to Modify Database User Privileges in DirectAdmin<\/strong><\/p>\n<div class=\"youtube-video\" style=\"border: 1px solid #ddd;\"><iframe src=\"https:\/\/www.youtube.com\/embed\/z6pZDZZhu90\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/div>\n<p>User privileges grant a level of authority to change and manage the objects of any database. With DirectAdmin, you can modify the database user privileges to impart customization powers to the users.<\/p>\n<h2>To Modify Database User Privileges<\/h2>\n<p>1. Log in to your DirectAdmin account.<\/p>\n<p>2. Click on <strong>MySQL Management<\/strong> in the<strong> Account Manager<\/strong> section.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11855\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/06\/da_mysql_management.png\" alt=\"\" width=\"1439\" height=\"368\" \/><\/p>\n<p>3. To change user privileges of a <strong>database<\/strong>, click on it.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12935\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/09\/da_mysql_db_select.jpg\" alt=\"\" width=\"1585\" height=\"390\" \/><\/p>\n<p>The options to customize the database user account will appear.<\/p>\n<p>4. Click on <strong>Modify Privileges<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-13216\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/10\/da_mysql_modify_privileges.jpg\" alt=\"\" width=\"1603\" height=\"292\" \/><\/p>\n<p>The <strong>CHANGE PRIVILEGES<\/strong> window will appear with a list of User Privileges.<\/p>\n<p>5. Tick the <strong>Privileges<\/strong> you want to grant the database user.<\/p>\n<p>6. Click on <strong>SAVE<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-13217\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/10\/da_mysql_user_privileges.jpg\" alt=\"\" width=\"1057\" height=\"706\" \/><\/p>\n<p>That&#8217;s it, DirectAdmin will apply the changes in the user privileges for the database.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Watch this video for a step by step process on How to Modify Database User Privileges in DirectAdmin User privileges grant a level of authority to change and manage the objects of any database. With DirectAdmin, you can modify the database user privileges to impart customization powers to the users. To Modify Database User Privileges [&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,1798,41],"tags":[1555,2538,1830,1898,2186,1506],"class_list":["post-14171","post","type-post","status-publish","format-standard","placeholder-for-hentry","category-database","category-directadmin","category-howtos","tag-database-management","tag-database-user-privileges-directadmin","tag-directadmin-database","tag-directadmin-faqs","tag-mysql-database-in-directadmin","tag-mysql-user-privileges"],"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 Modify Database User Privileges in DirectAdmin?<\/title>\n<meta name=\"description\" content=\"Managing or changing a database requires authority which is granted by user privileges. You can modify database user privileges with Directadmin.\" \/>\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-directadmin\/\" \/>\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 DirectAdmin?\" \/>\n<meta property=\"og:description\" content=\"Managing or changing a database requires authority which is granted by user privileges. You can modify database user privileges with Directadmin.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.milesweb.in\/hosting-faqs\/modify-database-user-privileges-directadmin\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"article:published_time\" content=\"2021-10-06T12:24:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-10-26T11:06:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/06\/da_mysql_management.png\" \/>\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-directadmin\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/modify-database-user-privileges-directadmin\/\"},\"author\":{\"name\":\"Prasad Khartadkar\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/c9138a9488172a8d0aa2d4f40878d83e\"},\"headline\":\"How to Modify Database User Privileges in DirectAdmin?\",\"datePublished\":\"2021-10-06T12:24:19+00:00\",\"dateModified\":\"2021-10-26T11:06:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/modify-database-user-privileges-directadmin\/\"},\"wordCount\":142,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/modify-database-user-privileges-directadmin\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/06\/da_mysql_management.png\",\"keywords\":[\"database management\",\"Database User Privileges DirectAdmin\",\"directadmin database\",\"DirectAdmin FAQs\",\"MySQL database in DirectAdmin\",\"mysql user privileges\"],\"articleSection\":[\"Database\",\"DirectAdmin\",\"How-Tos\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.milesweb.in\/hosting-faqs\/modify-database-user-privileges-directadmin\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/modify-database-user-privileges-directadmin\/\",\"url\":\"https:\/\/www.milesweb.in\/hosting-faqs\/modify-database-user-privileges-directadmin\/\",\"name\":\"How to Modify Database User Privileges in DirectAdmin?\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/modify-database-user-privileges-directadmin\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/modify-database-user-privileges-directadmin\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/06\/da_mysql_management.png\",\"datePublished\":\"2021-10-06T12:24:19+00:00\",\"dateModified\":\"2021-10-26T11:06:09+00:00\",\"author\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/c9138a9488172a8d0aa2d4f40878d83e\"},\"description\":\"Managing or changing a database requires authority which is granted by user privileges. You can modify database user privileges with Directadmin.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/modify-database-user-privileges-directadmin\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.milesweb.in\/hosting-faqs\/modify-database-user-privileges-directadmin\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/modify-database-user-privileges-directadmin\/#primaryimage\",\"url\":\"\",\"contentUrl\":\"\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/modify-database-user-privileges-directadmin\/#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 DirectAdmin?\"}]},{\"@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\/#\/schema\/person\/image\/\",\"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 DirectAdmin?","description":"Managing or changing a database requires authority which is granted by user privileges. You can modify database user privileges with Directadmin.","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-directadmin\/","og_locale":"en_US","og_type":"article","og_title":"How to Modify Database User Privileges in DirectAdmin?","og_description":"Managing or changing a database requires authority which is granted by user privileges. You can modify database user privileges with Directadmin.","og_url":"https:\/\/www.milesweb.in\/hosting-faqs\/modify-database-user-privileges-directadmin\/","og_site_name":"Web Hosting FAQs by MilesWeb","article_published_time":"2021-10-06T12:24:19+00:00","article_modified_time":"2021-10-26T11:06:09+00:00","og_image":[{"url":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/06\/da_mysql_management.png","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-directadmin\/#article","isPartOf":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/modify-database-user-privileges-directadmin\/"},"author":{"name":"Prasad Khartadkar","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/c9138a9488172a8d0aa2d4f40878d83e"},"headline":"How to Modify Database User Privileges in DirectAdmin?","datePublished":"2021-10-06T12:24:19+00:00","dateModified":"2021-10-26T11:06:09+00:00","mainEntityOfPage":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/modify-database-user-privileges-directadmin\/"},"wordCount":142,"commentCount":0,"image":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/modify-database-user-privileges-directadmin\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/06\/da_mysql_management.png","keywords":["database management","Database User Privileges DirectAdmin","directadmin database","DirectAdmin FAQs","MySQL database in DirectAdmin","mysql user privileges"],"articleSection":["Database","DirectAdmin","How-Tos"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.milesweb.in\/hosting-faqs\/modify-database-user-privileges-directadmin\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/modify-database-user-privileges-directadmin\/","url":"https:\/\/www.milesweb.in\/hosting-faqs\/modify-database-user-privileges-directadmin\/","name":"How to Modify Database User Privileges in DirectAdmin?","isPartOf":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/modify-database-user-privileges-directadmin\/#primaryimage"},"image":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/modify-database-user-privileges-directadmin\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/06\/da_mysql_management.png","datePublished":"2021-10-06T12:24:19+00:00","dateModified":"2021-10-26T11:06:09+00:00","author":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/c9138a9488172a8d0aa2d4f40878d83e"},"description":"Managing or changing a database requires authority which is granted by user privileges. You can modify database user privileges with Directadmin.","breadcrumb":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/modify-database-user-privileges-directadmin\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.milesweb.in\/hosting-faqs\/modify-database-user-privileges-directadmin\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/modify-database-user-privileges-directadmin\/#primaryimage","url":"","contentUrl":""},{"@type":"BreadcrumbList","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/modify-database-user-privileges-directadmin\/#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 DirectAdmin?"}]},{"@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\/#\/schema\/person\/image\/","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\/14171","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=14171"}],"version-history":[{"count":4,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts\/14171\/revisions"}],"predecessor-version":[{"id":14473,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts\/14171\/revisions\/14473"}],"wp:attachment":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/media?parent=14171"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/categories?post=14171"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/tags?post=14171"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}