How to Create and Manage MySQL User and Database
Table of Contents
This tutorial explains how to create a new MySQL user and database.
Video tutorial:
How To Create a Database?
Go to Site Tools > Site > MySQL where you can easily create a MySQL user and a database and then assign the user to the database.
On the page that opens, go to the Databases tab. Click on Create Database. Bear in mind that the Database names are automatically generated.
How to Create a User?
Next, click on the Users tab to create a new database user. Click on Create User. Bear in mind that they are automatically generated and once set you will receive a notice with the username and its password.
How to Assign a User to a Database?
In order for a MySQL user to be used to manage a certain database, the user permissions for that database must be set. This should be done from the Manage Users section, go to the preferred username and click on Add New Database.
On the page that opens, choose the desired privileges the user should have to the database and click on Confirm.
How to manage user privileges to a MySQL database?
To manage user privileges to a MySQL database, go to Site Tools > Site > MySQL > Databases. Click on the number in the Users column in the Manage Databases table.
From the pop-up, click Manage Access (manage access icon) in the pop-up.
Select or deselect the desired privileges and click Confirm.
