O'Reilly logo

MySQL Workbench: Data Modeling & Development by Michael McLaughlin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

image
CHAPTER
10
Creating and Managing Users and Roles
imagesers 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required