Question
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:
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 interruptedStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started