{"id":468,"date":"2024-06-01T14:22:51","date_gmt":"2024-06-01T14:22:51","guid":{"rendered":"https:\/\/webhostingdelhi.net.in\/tutorials\/?p=468"},"modified":"2024-06-01T14:23:35","modified_gmt":"2024-06-01T14:23:35","slug":"modify-database-user-privileges-in-directadmin","status":"publish","type":"post","link":"https:\/\/webhostingdelhi.net.in\/tutorials\/modify-database-user-privileges-in-directadmin\/","title":{"rendered":"How to Modify Database User Privileges in Directadmin ?"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Modify Database User Privileges in Directadmin, Its a web-based control panel that simplifies the management of <a href=\"https:\/\/www.webhostingdelhi.net.in\/web-hosting-delhi\/\">web hosting environments<\/a>, including database management. <\/p>\n\n\n\n<div class=\"wp-block-rank-math-toc-block\" id=\"rank-math-toc\"><h2>Step-by-Step Guide to Modify Database User Privileges in DirectAdmin<\/h2><nav><ul><li class=\"\"><a href=\"#log-in-to-direct-admin\">Log in to DirectAdmin:<\/a><\/li><li class=\"\"><a href=\"#navigate-to-database-management\">Navigate to Database Management:<\/a><\/li><li class=\"\"><a href=\"#select-the-database\">Select the Database:<\/a><\/li><li class=\"\"><a href=\"#manage-users\">Manage Users:<\/a><\/li><li class=\"\"><a href=\"#modify-database-user-privileges-in-directadmin\">Modify Database User Privileges in Directadmin:<\/a><\/li><li class=\"\"><a href=\"#confirmation\">Confirmation:<\/a><\/li><li class=\"\"><a href=\"#additional-tips\">Additional Tips<\/a><\/li><li class=\"\"><a href=\"#example\">Example<\/a><ul><li class=\"\"><a href=\"#granting-privileges\">Granting Privileges<\/a><\/li><li class=\"\"><a href=\"#revoking-privileges\">Revoking Privileges<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"log-in-to-direct-admin\"><strong>Log in to DirectAdmin:<\/strong><\/h2>\n\n\n\n<ol class=\"wp-block-list\"><\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Open your web browser and navigate to your DirectAdmin login page.<\/li>\n\n\n\n<li>Enter your username and password to log in.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"713\" height=\"638\" src=\"https:\/\/webhostingdelhi.net.in\/tutorials\/wp-content\/uploads\/2024\/06\/image.png\" alt=\"Modify Database User Privileges in Directadmin\" class=\"wp-image-469\" srcset=\"https:\/\/webhostingdelhi.net.in\/tutorials\/wp-content\/uploads\/2024\/06\/image.png 713w, https:\/\/webhostingdelhi.net.in\/tutorials\/wp-content\/uploads\/2024\/06\/image-300x268.png 300w\" sizes=\"auto, (max-width: 713px) 100vw, 713px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"navigate-to-database-management\"><strong>Navigate to Database Management:<\/strong><\/h2>\n\n\n\n<ol class=\"wp-block-list\"><\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>On the main dashboard, look for the &#8220;<strong>Database <\/strong>&#8221; option. This is usually under the &#8220;Account Manager&#8221; section.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"799\" height=\"208\" src=\"https:\/\/webhostingdelhi.net.in\/tutorials\/wp-content\/uploads\/2024\/06\/db.png\" alt=\"\" class=\"wp-image-470\" srcset=\"https:\/\/webhostingdelhi.net.in\/tutorials\/wp-content\/uploads\/2024\/06\/db.png 799w, https:\/\/webhostingdelhi.net.in\/tutorials\/wp-content\/uploads\/2024\/06\/db-300x78.png 300w, https:\/\/webhostingdelhi.net.in\/tutorials\/wp-content\/uploads\/2024\/06\/db-768x200.png 768w\" sizes=\"auto, (max-width: 799px) 100vw, 799px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"select-the-database\"><strong>Select the Database:<\/strong><\/h2>\n\n\n\n<ol class=\"wp-block-list\"><\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>In the MySQL Management page, you will see a list of all databases.<\/li>\n\n\n\n<li>Click on the name of the database for which you want to modify user privileges.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"181\" src=\"https:\/\/webhostingdelhi.net.in\/tutorials\/wp-content\/uploads\/2024\/06\/image-1-1024x181.png\" alt=\"\" class=\"wp-image-472\" srcset=\"https:\/\/webhostingdelhi.net.in\/tutorials\/wp-content\/uploads\/2024\/06\/image-1-1024x181.png 1024w, https:\/\/webhostingdelhi.net.in\/tutorials\/wp-content\/uploads\/2024\/06\/image-1-300x53.png 300w, https:\/\/webhostingdelhi.net.in\/tutorials\/wp-content\/uploads\/2024\/06\/image-1-768x135.png 768w, https:\/\/webhostingdelhi.net.in\/tutorials\/wp-content\/uploads\/2024\/06\/image-1-1536x271.png 1536w, https:\/\/webhostingdelhi.net.in\/tutorials\/wp-content\/uploads\/2024\/06\/image-1.png 1905w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"manage-users\"><strong>Manage Users:<\/strong><\/h2>\n\n\n\n<ol class=\"wp-block-list\"><\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>After selecting the database, you will see a list of users associated with that database.<\/li>\n\n\n\n<li>Click on the user for whom you want to modify privileges.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"151\" src=\"https:\/\/webhostingdelhi.net.in\/tutorials\/wp-content\/uploads\/2024\/06\/image-2-1024x151.png\" alt=\"\" class=\"wp-image-473\" srcset=\"https:\/\/webhostingdelhi.net.in\/tutorials\/wp-content\/uploads\/2024\/06\/image-2-1024x151.png 1024w, https:\/\/webhostingdelhi.net.in\/tutorials\/wp-content\/uploads\/2024\/06\/image-2-300x44.png 300w, https:\/\/webhostingdelhi.net.in\/tutorials\/wp-content\/uploads\/2024\/06\/image-2-768x114.png 768w, https:\/\/webhostingdelhi.net.in\/tutorials\/wp-content\/uploads\/2024\/06\/image-2-1536x227.png 1536w, https:\/\/webhostingdelhi.net.in\/tutorials\/wp-content\/uploads\/2024\/06\/image-2.png 1893w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"modify-database-user-privileges-in-directadmin\"><strong>Modify Database User Privileges in Directadmin:<\/strong><\/h2>\n\n\n\n<ol class=\"wp-block-list\"><\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>You will be presented with a list of privileges (e.g., SELECT, INSERT, UPDATE, DELETE).<\/li>\n\n\n\n<li>Check or uncheck the boxes to grant or revoke specific privileges for the user.<\/li>\n\n\n\n<li>After making the changes, click the &#8220;Save&#8221; or &#8220;Update&#8221; button to apply the changes.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"184\" src=\"https:\/\/webhostingdelhi.net.in\/tutorials\/wp-content\/uploads\/2024\/06\/image-3-1024x184.png\" alt=\"\" class=\"wp-image-474\" srcset=\"https:\/\/webhostingdelhi.net.in\/tutorials\/wp-content\/uploads\/2024\/06\/image-3-1024x184.png 1024w, https:\/\/webhostingdelhi.net.in\/tutorials\/wp-content\/uploads\/2024\/06\/image-3-300x54.png 300w, https:\/\/webhostingdelhi.net.in\/tutorials\/wp-content\/uploads\/2024\/06\/image-3-768x138.png 768w, https:\/\/webhostingdelhi.net.in\/tutorials\/wp-content\/uploads\/2024\/06\/image-3-1536x275.png 1536w, https:\/\/webhostingdelhi.net.in\/tutorials\/wp-content\/uploads\/2024\/06\/image-3.png 1568w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"confirmation\"><strong>Confirmation:<\/strong><\/h2>\n\n\n\n<ol class=\"wp-block-list\"><\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ensure that the changes have been saved by reviewing the user&#8217;s privileges again.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"486\" height=\"109\" src=\"https:\/\/webhostingdelhi.net.in\/tutorials\/wp-content\/uploads\/2024\/06\/image-4.png\" alt=\"\" class=\"wp-image-475\" srcset=\"https:\/\/webhostingdelhi.net.in\/tutorials\/wp-content\/uploads\/2024\/06\/image-4.png 486w, https:\/\/webhostingdelhi.net.in\/tutorials\/wp-content\/uploads\/2024\/06\/image-4-300x67.png 300w\" sizes=\"auto, (max-width: 486px) 100vw, 486px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"additional-tips\">Additional Tips<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>User Management:<\/strong> If you need to add or remove users, there should be options for creating new users or deleting existing ones within the MySQL Management section.<\/li>\n\n\n\n<li><strong>Backup:<\/strong> Always consider backing up your database before making significant changes to user privileges.<\/li>\n\n\n\n<li><strong>Documentation:<\/strong> Refer to DirectAdmin&#8217;s official documentation or support resources if you encounter any issues or need more detailed instructions.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"example\">Example<\/h2>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"granting-privileges\">Granting Privileges<\/h4>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Log in to DirectAdmin.<\/li>\n\n\n\n<li>Go to &#8220;MySQL Management&#8221;.<\/li>\n\n\n\n<li>Select the database <code>example_db<\/code>.<\/li>\n\n\n\n<li>Click on the user <code>example_user<\/code>.<\/li>\n\n\n\n<li>Check the privileges you want to grant (e.g., SELECT, INSERT).<\/li>\n\n\n\n<li>Click &#8220;Save&#8221; to apply the changes.<\/li>\n<\/ol>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"revoking-privileges\">Revoking Privileges<\/h4>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Log in to DirectAdmin.<\/li>\n\n\n\n<li>Go to &#8220;MySQL Management&#8221;.<\/li>\n\n\n\n<li>Select the database <code>example_db<\/code>.<\/li>\n\n\n\n<li>Click on the user <code>example_user<\/code>.<\/li>\n\n\n\n<li>Uncheck the privileges you want to revoke (e.g., DELETE).<\/li>\n\n\n\n<li>Click &#8220;Save&#8221; to apply the changes.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">By following these steps, you can easily manage and modify database user privileges using the DirectAdmin control panel.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Modify Database User Privileges in Directadmin, Its a web-based control panel that simplifies the management of web hosting environments, including database management. Log in to DirectAdmin: Navigate to Database Management: Select the Database: Manage Users: Modify Database User Privileges in Directadmin: Confirmation: Additional Tips Example Granting Privileges Revoking Privileges By following these steps, you can [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":477,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31],"tags":[47],"class_list":["post-468","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-directadmin","tag-modify-database-user-privileges-in-directadmin"],"_links":{"self":[{"href":"https:\/\/webhostingdelhi.net.in\/tutorials\/wp-json\/wp\/v2\/posts\/468","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webhostingdelhi.net.in\/tutorials\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webhostingdelhi.net.in\/tutorials\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webhostingdelhi.net.in\/tutorials\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/webhostingdelhi.net.in\/tutorials\/wp-json\/wp\/v2\/comments?post=468"}],"version-history":[{"count":2,"href":"https:\/\/webhostingdelhi.net.in\/tutorials\/wp-json\/wp\/v2\/posts\/468\/revisions"}],"predecessor-version":[{"id":476,"href":"https:\/\/webhostingdelhi.net.in\/tutorials\/wp-json\/wp\/v2\/posts\/468\/revisions\/476"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/webhostingdelhi.net.in\/tutorials\/wp-json\/wp\/v2\/media\/477"}],"wp:attachment":[{"href":"https:\/\/webhostingdelhi.net.in\/tutorials\/wp-json\/wp\/v2\/media?parent=468"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webhostingdelhi.net.in\/tutorials\/wp-json\/wp\/v2\/categories?post=468"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webhostingdelhi.net.in\/tutorials\/wp-json\/wp\/v2\/tags?post=468"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}