From the course: MySQL Database Administration
Join today to access over 24,500 courses taught by industry experts.
Solution: Managing users and permissions - MySQL Tutorial
From the course: MySQL Database Administration
Solution: Managing users and permissions
- [Narrator] Alright, this is the solution video for your assignment on user management. As a reminder, Joe needs you to help him add two different users to his database. One of those users is going to have DBA level privileges and the other one will have select only privileges. This second user is going to be an analyst. Let's jump into Workbench and walk through the solution. Alright, so here are the two users that we're going to try to add. We have DataGuru who will have DBA level privileges and the password will be ChangeMe. And then we have Analyst who will have select only privileges and the password will also be ChangeMe for that user. So first, we'll go up to our Administration tab and we're going to look for the Users and Privileges tool. We click there and we are first going to come down to Add Account. And so let's put in DataGuru and our password will be ChangeMe and confirm that same password. And then we'll go down to Apply. And so now we've got the new user in here 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.