MySQL Workbench: Data Modeling & Development

CHAPTER

10

Creating and Managing Users and Roles

sers are distinct from work areas, like databases (also known as a schema). Whether you create users or databases first is an awesome question, and I’m not sure of the right answer. While I’ll argue both cases in the next paragraph, databases should generally precede users beyond the root super user.

There’s value to the argument that you should define databases before you create users, because a user without grants to act in a database can’t do much. Likewise, there’s value to the argument that you ...