TRIGGER command denied to user

Username (e.g. epiz_XXX) or Website URL

username: epiz_29042748
MySQL Hostname sql107.epizy.com
MySQL Port (optional) 3306

Error Message

This is my query statement
CREATE TRIGGER delete BEFORE DELETE ON products FOR EACH ROW DELETE FROM initial_products WHERE id=old.product_no

**THIS IS THE ERROR:**
`#1142 - TRIGGER command denied to user 'epiz_29042748'@'192.168.0.6' for table 'products'`

please help

innodb isnt supported

1 Like

Its probably disabled for security reasons, but wait for admin and he’ll give you a better response.

1 Like

The error message shows me it’s permission error for user but as we can’t manage privileges for users so it’s probably something wrong on server side.

I tried this command through console of my phpmyadmin and it works fine
when I ran this command I wasn’t able to declare delete as name of trigger.

CREATE TRIGGER `del` BEFORE DELETE ON `products` FOR EACH ROW DELETE FROM initial_products WHERE id=old.product_no

Most advanced MySQL features like views, triggers, functions and procedures are not supported here. Please implement your application logic in PHP code instead of in the database.

These features are only available on premium hosting.

4 Likes

ok. thank you. that is why there is a Premium product. Now I know… that was easy reply.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.