Get your server issues fixed by our experts for a price starting at just 25 USD/Hour. Click here to register and open a ticket with us now!

Author Topic: Create and Manage MySQL Users in Webmin  (Read 5872 times)

0 Members and 1 Guest are viewing this topic.

rohitj

  • Guest
Create and Manage MySQL Users in Webmin
« on: October 26, 2013, 04:03:43 pm »
Create and Manage MySQL Users in Webmin


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”.