How to create Database users to your existing MySQL Database ?

Follow the steps to create Database users to your existing MySQL Database

Step-1: Login into your hosting account control panel.

Step-2: Select “MySQL” option under “Database” menu option.

Create MySQL DB User

Step-3: Select “MySQL DBs” option.

Create MySQL DB User

Step-4: Click on “ADD” button option.

Create MySQL DB User

Step-5: In the form that appears, enter user name, password and assign privileges/user role to users of your Database.

Create MySQL DB User

Step-6: Click on “ADD” button.

Create MySQL DB User

Add a new user to the database you have just created.

User roles are explained below:

Note:  Each user role involves a fixed set of privileges on this specific database.

Role: Set  of  privileges:
read select
read/write Select, insert, delete, update
dba Select, insert, update, drop, create, after, index.

 

MORE INFORMATION

Click here to know more about Database Hosting 

Now get unlimited MySQL databases with our Database Hosting Plans

Hosting Plans that supports MySQL services in Host Department