Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can someone help me understand why I keep getting this error? I have successfully created the user 'tabfalter' and now I am trying to grant

Can someone help me understand why I keep getting this error?

I have successfully created the user 'tabfalter' and now I am trying to grant permissions to that user, but I keep getting an error message.

MySQL Query:

GRANT SELECT,INSERT,UPDATE,DELETE ON my_guitar_shop.customers TO tabfalter @ my_guitar_shop; GRANT SELECT,INSERT,UPDATE,DELETE ON my_guitar_shop.addresses TO tabfalter @ my_guitar_shop; GRANT SELECT,INSERT,UPDATE,DELETE ON my_guitar_shop.orders TO tabfalter @ my_guitar_shop; GRANT SELECT,INSERT,UPDATE,DELETE ON my_guitar_shop.order_items TO tabfalter @ my_guitar_shop; GRANT SELECT ON my_guitar_shop. Products TO tabfalter @ my_guitar_shop; GRANT SELECT ON my_guitar_shop. Categories TO tabfalter @ my_guitar_shop;

Error Message:

12:49:54 GRANT SELECT,INSERT,UPDATE,DELETE ON my_guitar_shop.customers TO tabfalter @ my_guitar_shop Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'my_guitar_shop' at line 1

Screenshot:image text in transcribed

MySQL Workbench DE Query 1. 2 3 Locirca ... Administration Schemes SCHEMAS Q Filter objects Q my_guitar_shop Tables addresses administrators categories customers order_items orders products Views Stored Procedures 5 Functions > sys Limit to co rows GRANT SELECT, INSERT, UPDATE, DELETE ON ny_guitar_shop.customers to tabfalter wy_guitar_shop GRANT SELECT, INSERT, UPDATE, DELETE ON ny_guitar_shop.addresses to tabfalter a wy_guitar_shop: GRANT SELECT, INSERT, UPDATE, DELETE ON ny_guitar_shop.orders To tabfalter @my_guitar_shop GRANT SELECT, INSERT, UPDATE, DELETE ON ny_guitar_shop.order_itens To tabfalter @my_guitar_shop GRANT SELECT ON ny_guitar_shop. Products To tabtalter a ny_guitar_shop: GRANT SELECT ON ny_guitar_shop. Categories TO tabfalter @my_guitar_shop, 5 Beso ble in Behema gullar shop 100% 07436 : Action Output Time Raspored Duration/ Fetch Time M71 12:45-01 SError Code: 1054. Unknown column Password' in Teld ist 0.00055 sec 72 12:45-21 S 12 row's returned 0.0010 sec 0.00001.. 73 12:47.26 Borowis) affected 0.0032 sec * 74 12:47:20 Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GRANT SELECTINSERT, UPDATE,DELETE ON my gutar_shop.Orders TO "tabat. 0.00049 sec x 75 12:48:23 Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near mguharshop' at line 1 0.00000 sec x 70 * 75 12:48:54 Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'm.gultar_shop' at Ine 1 0.00029 sec Query interrupted

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Big Data, Mining, And Analytics Components Of Strategic Decision Making

Authors: Stephan Kudyba

1st Edition

1466568704, 9781466568709

More Books

Students also viewed these Databases questions

Question

7-2. How does a claim differ from an adjustment? [LO-2]

Answered: 1 week ago