{"id":451,"date":"2016-01-20T09:06:36","date_gmt":"2016-01-20T09:06:36","guid":{"rendered":"http:\/\/kb.veeble.org\/?p=451"},"modified":"2025-03-13T12:13:36","modified_gmt":"2025-03-13T06:43:36","slug":"manage-mysql-users-webmin","status":"publish","type":"post","link":"https:\/\/www.veeble.com\/kb\/manage-mysql-users-webmin\/","title":{"rendered":"Manage MySQL Users – Webmin"},"content":{"rendered":"\n

When it comes to the database and user management with Webmin<\/a>, it can be a little confusing or sometimes we could not find the actual steps to follow. In this article, we will learn how to Manage MySQL users with the Webmin control panel installed on our server. The method is very easy.<\/p>\n\n\n\n

\"mysql_webmin\"<\/a><\/figure>\n\n\n\n
\"my_sql_webmin_2\"<\/a><\/figure>\n\n\n\n

You can follow the steps mentioned below to start managing your MySQL.
1. Login to webmin and find the section called \u201cServers\u201d
2. Click \u201cMySQL Database Server\u201d (If not found, please check in ‘un-used<\/strong>‘ modules and click on MySQL Database Server)

3. Select \u201cUser Permissions\u201d

To create a new user:<\/strong><\/p>\n\n\n\n

1. Click \u201cCreate new user\u201d under the table listing current users
2. Enter a username and password
3. Select permissions (these are global privileges \u2013 you can set privileges for individual databases in another section)
4. Click \u201cCreate\u201d<\/p>\n\n\n\n

To change permissions for specific databases, follow these steps:<\/strong><\/p>\n\n\n\n

1. From the MySQL Database Server page, click \u201cDatabase Permissions\u201d
2. Click the name of the database you want to manage
3. For \u201cUsername\u201d toggle the box to the right of the anonymous box and enter the user you want to have permissions for this database
4. Select the permissions you want to grant. To select multiple permissions, hold the Control key and click them
Click \u201cSave\u201d<\/p>\n\n\n\n

Webmin is a free web hosting control panel and you can use it with any Linux server. Thank you for reading!<\/p>\n\n\n\n

<\/div>\n\n\n\n

Focus on Growth, Not Servers \u2013 Fully Managed AWS Solutions!<\/h3>

Maximize ROI with hassle-free AWS hosting. We optimize costs, ensure compliance, and provide round-the-clock support\u2014so you can scale confidently without technical headaches.<\/p><\/div>

Get Started Now<\/path><\/svg><\/a><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"

When it comes to the database and user management with Webmin, it can be a little confusing or sometimes we could not find the […]<\/p>\n","protected":false},"author":10,"featured_media":7691,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[5],"tags":[],"class_list":["post-451","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-linux"],"uagb_featured_image_src":{"full":["https:\/\/www.veeble.com\/kb\/wp-content\/uploads\/2016\/01\/Manage-MySQL-Users-Webmin.jpg",1366,768,false],"thumbnail":["https:\/\/www.veeble.com\/kb\/wp-content\/uploads\/2016\/01\/Manage-MySQL-Users-Webmin-150x150.jpg",150,150,true],"medium":["https:\/\/www.veeble.com\/kb\/wp-content\/uploads\/2016\/01\/Manage-MySQL-Users-Webmin-300x169.jpg",300,169,true],"medium_large":["https:\/\/www.veeble.com\/kb\/wp-content\/uploads\/2016\/01\/Manage-MySQL-Users-Webmin-768x432.jpg",768,432,true],"large":["https:\/\/www.veeble.com\/kb\/wp-content\/uploads\/2016\/01\/Manage-MySQL-Users-Webmin-1024x576.jpg",1024,576,true],"1536x1536":["https:\/\/www.veeble.com\/kb\/wp-content\/uploads\/2016\/01\/Manage-MySQL-Users-Webmin.jpg",1366,768,false],"2048x2048":["https:\/\/www.veeble.com\/kb\/wp-content\/uploads\/2016\/01\/Manage-MySQL-Users-Webmin.jpg",1366,768,false]},"uagb_author_info":{"display_name":"Vipin Raj","author_link":"https:\/\/www.veeble.com\/kb\/author\/vipin\/"},"uagb_comment_info":0,"uagb_excerpt":"When it comes to the database and user management with Webmin, it can be a little confusing or sometimes we could not find the […]","_links":{"self":[{"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/posts\/451","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/comments?post=451"}],"version-history":[{"count":17,"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/posts\/451\/revisions"}],"predecessor-version":[{"id":8046,"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/posts\/451\/revisions\/8046"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/media\/7691"}],"wp:attachment":[{"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/media?parent=451"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/categories?post=451"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.veeble.com\/kb\/wp-json\/wp\/v2\/tags?post=451"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}