I have a MySQL instance offers services to multi-application, different application has different DBA who responsible to their own application schema.
For example:
Application A has schema DB_A,there are two type of MySQL account for A,one to satisfy the business requirement, and the other one is for administration purpose(performance tuning,DDL,and some other privilege need for administration), apparently ,the former is the subset of the latter. In addition, there is a super DBA (root), who is responsible to create such accounts I mentions above.
As new to MySQL, I would like to ask that how to execute the proper grant statement to satisfy my requirement?