Admin-Ahead Community

Linux => Control Panels => Webmin/Virtualmin => Topic started by: rohitj on October 26, 2013, 04:03:43 pm

Title: Create and Manage MySQL Users in Webmin
Post by: rohitj 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”.