Question: write and execute a script that creates a user with a username using your firstname initial and lastname and password of your choosing. This user

write and execute a script that creates a user with a username using your firstname initial and lastname and password of your choosing. 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 Order_Items 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.

This is being used in MySQL workbench with my_guitar_shop created as the database. Thank you.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Create a new user with the specified username and password CREATE USER first initiallas... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

THIRD AVENUE SOFTWARE HEALTH-CARE APP PROJECT This case is new for the ninth edition of Information Technology Project Management . The case provides an opportunity to apply agile and Scrum...

Hi there , I need help. for my work i need a relevant and well written introduction as well as conclusion to the following below. My work is complete i just need a introduction and conclusion please...

Prepare a company analysis (strengths and weaknesses) Instructions - Prepare the SW portion of a SWOT analysis as a report. Use your textbook and the instruction below. Prioritizing the Results: The...

Frontier Park was started on April 1 by C. J. Mendez. The following selected events and transactions occurred during April. Apr. 1 Mendez invested $40,000 cash in the business. 4 Purchased land...

7 Explain how to overcome the problem of empty communities, silent communities and critical communities.

A jury has three members. Each of these members makes the correct decision with probability p, independent of the other jury members. The jurys decision is based on the majority rule. (i) What is the...

If Matlin is covered by the policy but is also disqualified by his misrepresentation on the application for coverage, might the insurer still be liable for bad faith denial of coverage? Explain....

What are the major threats and the controls that can mitigate those threats in the human resources management (HRM)/payroll cycle?

A botanist conducts study about the average number of blooms on a well-tended marigold plant. 73 seedlings are cultivated to maturity and the number of blooms recorded. The results are given in the...

You have taken out a loan for a new car. Select the appropriate variables and calculate how much you would pay in interest on the loan. Principal amount =$10,000 Interest rate =5% Time =5 years...

(b) (i) A circuit has a voltage v(t) = vocos (wt) applied to it and draws a current: i(t) = iocos (wt +) where is the constant phase difference between the voltage and current waveforms and all other...

The partnership of Waterway, Wildhorse, and Sheffield engaged you to adjust its accounting records and convert them uniformly to the accrual basis in anticipation of admitting Kerns as a new partner....

[The following information applles to the questions displayed below.] Diana and Ryan Workman were married on January 1 of last yeat, Ryan has an eight-year-old son, Jorge, from his previous marriage....

Write Section 1 of the DAA. Provide context for the Caffeine, Exercise, and Heart Rate Dataset. Include a definition of the specified variables, including factors, levels of each factor, and the...

INDIVIDUAL TAX RETURN PROBLEM 2Required: Use the following information to complete Johnelle and Latoya Henry's 2016federal income tax return. If information is missing, use reasonable assumptions to...

The ledger of Claudell Company includes the following unadjusted normal balances: Prepaid Rent $2,100, Services Revenue $66,600, and Wages Expense $6,100. Adjusting entries are required for (a)...

Sportique Boutique reported the following financial data for 2012 and 2011. Instructions(a) Calculate the current ratio for Sportique Boutique for 2012 and 2011.(b) Suppose that at the end of 2012,...

Explain how after identifying and performing the preliminary classification of an organizations information assets, the analysis phase examines the threats facing the organization. Emphasize how each...

I. Classify the details that data stored in a vulnerability database should contain to be effective when an issue occurs: A unique vulnerability ID number for reporting and tracking remediation...

Distinguish that a basic tenet of security architectures is layered implementation of security. Thus, an organization must establish multiple layers of security controls and safeguards, which can be...

Given the following null and alternative hypotheses and the following sample information a. If = 0.05, state the decision rule for the hypothesis. b. Test the hypothesis and indicate whether the...

Due to the sharp rise in oil prices, the cost of heating a home has risen sharply. In a recent year, the average cost was $1,044, which was an increase of 33% above that in the previous year. In...

As part of a study on student loan debt, a national agency that underwrites student loans is examining the differences in student loan debt for undergraduate students. One question the agency would...