MySQL Forums
Forum List  »  Newbie

UPDATE command denied to user
Posted by: Malcolm Smith
Date: January 31, 2022 06:08AM

Hi,

I am developing a api in Node.js using sequelize.

When I try execute a specfic update query I get and error:

Error Code: 1142. UPDATE command denied to user 'ncuser_2040'@'xxx-xx-xx-xxx' for table 'shopping_items'

I have checked another update statenent on the same api and it works ok.

This is the statement:

UPDATE my_recipes_db.shopping_items SET picked = true WHERE master_list = true
and ingredientName in (select * FROM (select ingredientName FROM my_recipes_db.shopping_items
WHERE owner_id = ownerId and shopping_list_name = shoppingList) as t);


In my search I found out that some update statements cant be executed with MySQL but this statement works fine in MYSQL Workbench.

I havent had any other denied permissions on this app either.

Any ideas plz?

Malcolm

Options: ReplyQuote


Subject
Written By
Posted
UPDATE command denied to user
January 31, 2022 06:08AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.