How to Manage MySQL Users in Webmin

In a previous post, we looked at some of the ways in which you can manage a MySQL user from the mysql command-line prompt. Today, you will learn about managing MySQL users from within Webmin’s web-based control panel.

To begin managing MySQL in webmin, do the following:

  1. Login to webmin and find the section called “Servers”
  2. Click “MySQL Database Server”
  3. Select “User Permissions”

To create a new user:

  1. Click “Create new user” under the table listing current users
  2. Enter a user name and password
  3. Select permissions (these are global privileges – you can set privileges for individual databases in another section
  4. Click “Create”

To change permissions for specific databases, follow these steps:

  1. From the MySQL Database Server page, click “Database Permissions”
  2. Click the name of the database you want to manage
  3. For “Username” 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
  5. Click “Save”

As you can see, Webmin makes it easy to manage databases with little hassle. Webmin is a free and open source system administration panel. You can use it with any Linux server.