Exercise: User Management and Access Control
Explore practical exercises to create and manage users in MySQL, assign specific privileges, revoke access, and enforce password expiration policies. This lesson helps you build essential skills in user management and access control for secure database administration.
We'll cover the following...
Now it’s time to get some hands-on practice!
Question 1
For our OnlineStore, create a user named inventory_clerk who can only connect from IP addresses in the 10.10.20.x subnet. Assign the password Inv3ntoryCl3rk!.
If you’re stuck, click the “Show Solution” button.
Question 2
Given the following structure of the Products table:
Field | Type |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Where ProductID is the primary key and CategoryID is the foreign key from the ...