Add multiple users to a MySQL database
Add Multiple Users to a MySQL Database
MySQL is an open source relational database management system (RDBMS). To add multiple users to a MySQL database, follow the below steps
Step 2: Select MySQL Databases under the section Databases
Step 3: To assign a new user to the database. Go to the option Add User to Database
Step 4: Select the users to be added from the drop-down list box
Step 5: Select the corresponding database from the drop-down list
Step 6: Click the option “Add button” after selecting the respective user and database
Step 7: Select the privileges for the user by clicking the checkbox “All privileges”
Step 8: Otherwise, few privileges can be selected for the users to access
Step 9: Once the privileges are assigned to the user, click the option “Make Changes”
Step 1 Login to cPanel.
Step 2 Click MySQL Database under Database section.
Click MySQL Database
It has all the specific feature to create and manage Database.
Step 3 To assign a new user to the database. Go to Add User to Database.
Go to Add user to Database.
Step 4 Select the user’s from the drop-down list box.
Select the User name
Step 5 Select corresponding database from the drop-down list.
Select the Database name
Step 6 Click Add button after selecting the respective user and database.
Click Add Button
Step 7 Then it redirects us to next page to assign the User’s privileges of the current user. Select all the privileges by clicking the checkbox.
Set all privileges to the user
Step 8 Otherwise we can grant few privileges also to a particular user.
set particular privileges to the user
Step 9 After assigning the privileges to the user, click the option Make Changes.
Click make changes button