Rip-off MySQL 5.6.19 administrative Roles and Global privileges

Role:

1.DBA

2.MaintenanceAdmin

3.ProcessAdmin

4.UserAdmin

5.SecurityAdmin

6.MonitorAdmin

7.DBManager

8.ReplicationAdmin

9.BackupAdmin

10.Custom, this is not really system role bar, custom, can be combined global privileges

Global Privileges:

1.Alter

2.Alter Routine

3.Create

4.Create Routine

5.Create tablespace

6.Create Temporary Tables

7.Create User

8.Create View

9.Delete

10.Drop

11.Event

12.Execute

13.File

14.Grant Option

15.Index

16.Insert

17.Lock Tables

18.Process

19.References

20.Reload

21.Replication Client

22.Replication Slave

23.Select

24.Show Databases

25.Show View

26.Shutdown

27.Super

28.Trigger

29.Update

It's a lot, and there's a role. The default corresponding global privileges

In fact, there is no need to remember (I feel no need to remember), about the global privileges also know a super, because these days have been engaged in this, other role, today for the first time know that MySQL has role.

After you have installed MySQL and Workbench, you can see in Workbench's users and privileges that role and global privileges default correspondence, directly below two images

And the inclusion relationship between roles and so on, I just found out when I checked DBA role.

Roles and Global privileges are all here (I guess), and the reason for this is to install X.