In this module you can manage everything related to databases Database creation, User creation, User assignment to databases, Permission assignment, Security and optimization.
Navigate to:
SQL Services --> MySQL Manager
List Databases and Users
Here you can see the list of Users associated with the databases.
SQL Services --> MySQL Manager --> List Databases and Users
To add a new user to MySQL, click Add New User, add username, select local host or Any host, confirm the random generator password and click Create User.
List Users
You can see all MySQL users and change the permissions.
SQL Services --> MySQL Manager --> List Users
List Permissions
Here you can see the list of the permissions of the users assigned to databases.
SQL Services --> MySQL Manager --> List Permissions
Create Database
In this tab you will be able to create the databases to the server.
Select the user you want to create a database for, type the name of the database and click Create Database.
SQL Services --> MySQL Manager --> Create Database
Create Database and User
In this tab you can create the database and the user assigned to it.
The user will have the same name as the database.
Select the user, indicate the name you want to give it, confirm the random generator password and click on Create Database.
SQL Services --> MySQL Manager --> Create Database and User
Security & Optimization Check
In this tab you will be able to review the database configuration, permissions, optimization, error reports, function requests and downloads.
SQL Services --> MySQL Manager --> Security & Optimization Check