{"id":11836,"date":"2021-10-06T12:24:24","date_gmt":"2021-10-06T12:24:24","guid":{"rendered":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?p=11836"},"modified":"2024-04-23T14:12:17","modified_gmt":"2024-04-23T13:12:17","slug":"modify-database-user-privileges-directadmin","status":"publish","type":"post","link":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/modify-database-user-privileges-directadmin\/","title":{"rendered":"How to Modify Database User Privileges in DirectAdmin?"},"content":{"rendered":"<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.co.uk\/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.co.uk\/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.co.uk\/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.co.uk\/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>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 1. Log in to your DirectAdmin account. 2. Click on MySQL Management in the Account Manager section. 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,1777,41],"tags":[1536,2515,1809,1877,2166,1486],"class_list":["post-11836","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 v25.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\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.co.uk\/hosting-faqs\/modify-database-user-privileges-directadmin\/\" \/>\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 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.co.uk\/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:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-23T13:12:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.milesweb.co.uk\/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=\"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-directadmin\/\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/modify-database-user-privileges-directadmin\/\",\"name\":\"How to Modify Database User Privileges in DirectAdmin?\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/modify-database-user-privileges-directadmin\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/modify-database-user-privileges-directadmin\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/06\/da_mysql_management.png\",\"datePublished\":\"2021-10-06T12:24:24+00:00\",\"dateModified\":\"2024-04-23T13:12:17+00:00\",\"author\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/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.co.uk\/hosting-faqs\/modify-database-user-privileges-directadmin\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/modify-database-user-privileges-directadmin\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/modify-database-user-privileges-directadmin\/#primaryimage\",\"url\":\"\",\"contentUrl\":\"\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/modify-database-user-privileges-directadmin\/#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 DirectAdmin?\"}]},{\"@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 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.co.uk\/hosting-faqs\/modify-database-user-privileges-directadmin\/","og_locale":"en_GB","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.co.uk\/hosting-faqs\/modify-database-user-privileges-directadmin\/","og_site_name":"Web Hosting FAQs by MilesWeb","article_published_time":"2021-10-06T12:24:24+00:00","article_modified_time":"2024-04-23T13:12:17+00:00","og_image":[{"url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/06\/da_mysql_management.png","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-directadmin\/","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/modify-database-user-privileges-directadmin\/","name":"How to Modify Database User Privileges in DirectAdmin?","isPartOf":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/modify-database-user-privileges-directadmin\/#primaryimage"},"image":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/modify-database-user-privileges-directadmin\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/06\/da_mysql_management.png","datePublished":"2021-10-06T12:24:24+00:00","dateModified":"2024-04-23T13:12:17+00:00","author":{"@id":"https:\/\/www.milesweb.co.uk\/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.co.uk\/hosting-faqs\/modify-database-user-privileges-directadmin\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.milesweb.co.uk\/hosting-faqs\/modify-database-user-privileges-directadmin\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/modify-database-user-privileges-directadmin\/#primaryimage","url":"","contentUrl":""},{"@type":"BreadcrumbList","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/modify-database-user-privileges-directadmin\/#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 DirectAdmin?"}]},{"@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":327,"_links":{"self":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/11836","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=11836"}],"version-history":[{"count":4,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/11836\/revisions"}],"predecessor-version":[{"id":15492,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/11836\/revisions\/15492"}],"wp:attachment":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/media?parent=11836"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/categories?post=11836"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/tags?post=11836"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}