Question: Write and execute a script that creates a user with a username using your firstname initial and lastname ( GSmith ) and password of your
Write and execute a script that creates a user with a username using your firstname initial and lastname GSmith and password of your choosing abc This user should be able to connect to MySQL from any computer.
This user should have SELECT, INSERT, UPDATE, and DELETE privileges for the Customers, Addresses, Orders, and OrderItems tables of the My Guitar Shop database.
However, this user should only have SELECT privileges for the Products and Categories tables. Also, this user should not have the right to grant privileges to other users.
Check the privileges for the user by using the SHOW GRANTS statement. Submit a screenshot.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
