How to create a MySQL Database with webmin.
In order to create a MySQL Database with proper user permissions please perform the following steps :
- Login to your Webmin control panel
- Click on the services tab within Webmin
- Click on the MySQL Database Server Option
- Click on create a new Database
- Type in the database name and then click create
- You will then be directed back to the Database list page
- If you need to add a user to the Database please proceed to the next step
- On the Database list page scroll down to user permissions and click on the link
- Click create new user
- For username click on the user radio button and then add the username.
- Choose Set to and then trype in a password
- Click Create. (Do not click any permissions in this step. We are going to do this in the next few steps.)
- You will be returned to the user list.
- Click on the module index link which will return you to the Database list.
- On the database list page scroll down to Database permissions and click on the link
- Click on new database permissions
- Slect the radio button for selected database and choose the Database that you have recently created in the previous step.
- Select the user radio button and type in the username that you want access to the database. This will be the username that you created in a previous step above.
- For setting permissions use your mouse to select all of the permission in the combo box. You can hold down your mouse button and scroll down to select all available permissions.
- Click create.
- You have successfully created your database and user permissions.







