How to create database 用户 and 限制 it’s 访问 to the only database (cPanel, WebHost Manager, 交通和)

In this tutorial you will learn how to create database 用户 and 限制 its 访问 to the only database.

1. Login to your hosting control panel and click on MySQL – Databases option.

2. In 新 Database option, type in your database 名字.

3. In 用户名字 option, type in 用户名字

Specify password for it and cick on ‘create 用户’ button.

Now, we need to add 用户 to Database.

4. In 用户 option, select our newly added 用户名字

5. In Database option, select our newly added database 名字

6. Click on ‘Add’ button to add our new 用户 to new database.

7. Next thing we should add Privileges.

8. You can select which privileges will have specific 用户 for Database.

For example,

改动: you need it to modify existing data

下降: allows to drop tables/database

CREATE: you need it to create additional tables

INSERT: you need it to insert data

Select needed options and click ‘Make Changes’

This is it.We have created new database, new 用户 and assigned 用户 to Database.

Lets create new 用户 and assign in to existing Database.

1. Create new 用户 and select it in ‘Add 用户 to Database’ option.

2. In Database option, select your existing database.

3. Select Privileges for this 用户

4. This is it. We have added new 用户 to Existing Database.

Feel free to check the detailed video tutorial below: