From the course: MySQL Database Administration
Join today to access over 24,500 courses taught by industry experts.
Challenge: Managing users and permissions - MySQL Tutorial
From the course: MySQL Database Administration
Challenge: Managing users and permissions
- [Instructor] All right, we're ready for your assignment on user management. For this assignment, you'll be working with Joe again. He needs your help creating two new users that can access his database. The first user, he'd like you to name DataGuru, and they should have DBA-level privileges, and they want the password to be "ChangeMe!" with an exclamation point afterwards. The second user will just be called Analyst, and this should be SELECT only privileges, and, again, the password for this user will be "ChangeMe!" to start. Obviously, he wants them to change it after he gives them their logins. And just as a reminder, you want to always restrict access and permissions to just what's needed. This is really important as a DBA for security purposes, so that's why he's asking for different levels for these two users. Hopefully this will be a fairly straightforward one for you. If you're having trouble, I'd recommend go back and watch the previous video where we ran through a very…
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.