From the course: MySQL Database Administration
Join today to access over 24,800 courses taught by industry experts.
Managing users and permissions - MySQL Tutorial
From the course: MySQL Database Administration
Managing users and permissions
- [Instructor] All right, we are ready to talk about user management. Workbench makes it easy for us to add users and to manage their privileges, using the UI tools. Users will be granted varying levels of permissions. At one end of the spectrum, you could create a user that can only SELECT, so we'd call that a read-only user. And then at the other end of the spectrum, you have the DBA role, which carries all privileges for managing, creating, deleting, et cetera. As a general rule of thumb, when you're setting up a database and partitioning out permissions, you'll want to restrict access to just the types of activities that a given person would need. So if you have an analyst who's never going to be manipulating tables, they could be fine just having read-only access. But then your engineers, your database administrators, they're likely going to have more serious permissions where they're able to do more things in the database. So to preserve the integrity of the database and…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.