{"id":4503,"date":"2018-01-18T14:27:52","date_gmt":"2018-01-18T13:27:52","guid":{"rendered":"https:\/\/www.utilewebsites.nl\/knowledgebase\/magento-2-the-user-specified-as-a-definer-does-not-exist\/"},"modified":"2023-04-06T07:08:25","modified_gmt":"2023-04-06T06:08:25","slug":"magento-2-the-user-specified-as-a-definer-does-not-exist","status":"publish","type":"wz_knowledgebase","link":"https:\/\/www.utilewebsites.nl\/en\/knowledgebase\/magento-2-the-user-specified-as-a-definer-does-not-exist\/","title":{"rendered":"Magento 2 The user specified as a definer does not exist"},"content":{"rendered":"\nnotification :<\/p>\n<pre>SQLSTATE[HY000]: General error: 1449 The user specified as a definer ('testuser'@'localhost') does not exist, query was: INSERT INTO `catalog_product_entity_media_gallery` (`attribute_id`, `value`, `media_type`) VALUES (?, ?, ?)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-3451\" src=\"https:\/\/www.utilewebsites.nl\/wp-content\/uploads\/2018\/01\/mysql-definer-magento2-1024x491.jpg\" alt=\"\" width=\"604\" height=\"290\" srcset=\"https:\/\/www.utilewebsites.nl\/wp-content\/uploads\/2018\/01\/mysql-definer-magento2-1024x491.jpg 1024w, https:\/\/www.utilewebsites.nl\/wp-content\/uploads\/2018\/01\/mysql-definer-magento2-300x144.jpg 300w, https:\/\/www.utilewebsites.nl\/wp-content\/uploads\/2018\/01\/mysql-definer-magento2-768x368.jpg 768w, https:\/\/www.utilewebsites.nl\/wp-content\/uploads\/2018\/01\/mysql-definer-magento2.jpg 1920w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/p>\n<p>The steps below allow you to customize the definer:<\/p>\n<pre>Go to PHPMyAdmin\nSelect your Database\nSelect your table\nClick on 'Triggers' in the top menu\nClick 'Edit' to modify the trigger\nChange definer from (e.g. [testuser@localhost] to your definer e.g. root@localhost<\/pre>\n<p>Good luck<\/p>\n","protected":false},"excerpt":{"rendered":"<p> notification : SQLSTATE[HY000]: General error: 1449 The user specified as a definer ('testuser'@'localhost') does not exist, query was: INSERT INTO `catalog_product_entity_media_gallery` (`attribute_id`, `value`, `media_type`) VALUES (?, ?, ?) The steps below allow you to customize the definer: Go to PHPMyAdmin Select your Database Select your table Click on 'Triggers' in the top menu Click 'Edit' to modify the trigger Change definer from (e.g. [testuser@localhost] to your definer e.g. root@localhost Good luck<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"wzkb_category":[61],"wzkb_tag":[],"class_list":["post-4503","wz_knowledgebase","type-wz_knowledgebase","status-publish","hentry","wzkb_category-magento-2-0-x"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Magento 2 The user specified as a definer does not exist - Utilewebsites<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.utilewebsites.nl\/en\/knowledgebase\/magento-2-the-user-specified-as-a-definer-does-not-exist\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Magento 2 The user specified as a definer does not exist - Utilewebsites\" \/>\n<meta property=\"og:description\" content=\" notification : SQLSTATE[HY000]: General error: 1449 The user specified as a definer (&#039;testuser&#039;@&#039;localhost&#039;) does not exist, query was: INSERT INTO `catalog_product_entity_media_gallery` (`attribute_id`, `value`, `media_type`) VALUES (?, ?, ?) The steps below allow you to customize the definer: Go to PHPMyAdmin Select your Database Select your table Click on &#039;Triggers&#039; in the top menu Click &#039;Edit&#039; to modify the trigger Change definer from (e.g. [testuser@localhost] to your definer e.g. root@localhost Good luck\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.utilewebsites.nl\/en\/knowledgebase\/magento-2-the-user-specified-as-a-definer-does-not-exist\/\" \/>\n<meta property=\"og:site_name\" content=\"Utilewebsites\" \/>\n<meta property=\"article:modified_time\" content=\"2023-04-06T06:08:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.utilewebsites.nl\/wp-content\/uploads\/2018\/01\/mysql-definer-magento2-1024x491.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.utilewebsites.nl\\\/en\\\/knowledgebase\\\/magento-2-the-user-specified-as-a-definer-does-not-exist\\\/\",\"url\":\"https:\\\/\\\/www.utilewebsites.nl\\\/en\\\/knowledgebase\\\/magento-2-the-user-specified-as-a-definer-does-not-exist\\\/\",\"name\":\"Magento 2 The user specified as a definer does not exist - Utilewebsites\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.utilewebsites.nl\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.utilewebsites.nl\\\/en\\\/knowledgebase\\\/magento-2-the-user-specified-as-a-definer-does-not-exist\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.utilewebsites.nl\\\/en\\\/knowledgebase\\\/magento-2-the-user-specified-as-a-definer-does-not-exist\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.utilewebsites.nl\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/mysql-definer-magento2-1024x491.jpg\",\"datePublished\":\"2018-01-18T13:27:52+00:00\",\"dateModified\":\"2023-04-06T06:08:25+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.utilewebsites.nl\\\/en\\\/knowledgebase\\\/magento-2-the-user-specified-as-a-definer-does-not-exist\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.utilewebsites.nl\\\/en\\\/knowledgebase\\\/magento-2-the-user-specified-as-a-definer-does-not-exist\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.utilewebsites.nl\\\/en\\\/knowledgebase\\\/magento-2-the-user-specified-as-a-definer-does-not-exist\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.utilewebsites.nl\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/mysql-definer-magento2-1024x491.jpg\",\"contentUrl\":\"https:\\\/\\\/www.utilewebsites.nl\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/mysql-definer-magento2-1024x491.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.utilewebsites.nl\\\/en\\\/knowledgebase\\\/magento-2-the-user-specified-as-a-definer-does-not-exist\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.utilewebsites.nl\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Knowledge Base\",\"item\":\"https:\\\/\\\/www.utilewebsites.nl\\\/en\\\/knowledgebase\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Magento 2 The user specified as a definer does not exist\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.utilewebsites.nl\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.utilewebsites.nl\\\/en\\\/\",\"name\":\"Utilewebsites\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.utilewebsites.nl\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.utilewebsites.nl\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.utilewebsites.nl\\\/en\\\/#organization\",\"name\":\"Utilewebsites\",\"url\":\"https:\\\/\\\/www.utilewebsites.nl\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.utilewebsites.nl\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.utilewebsites.nl\\\/wp-content\\\/uploads\\\/2019\\\/08\\\/logo-Utilewebsites-2017.png\",\"contentUrl\":\"https:\\\/\\\/www.utilewebsites.nl\\\/wp-content\\\/uploads\\\/2019\\\/08\\\/logo-Utilewebsites-2017.png\",\"width\":3000,\"height\":593,\"caption\":\"Utilewebsites\"},\"image\":{\"@id\":\"https:\\\/\\\/www.utilewebsites.nl\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Magento 2 The user specified as a definer does not exist - Utilewebsites","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.utilewebsites.nl\/en\/knowledgebase\/magento-2-the-user-specified-as-a-definer-does-not-exist\/","og_locale":"en_US","og_type":"article","og_title":"Magento 2 The user specified as a definer does not exist - Utilewebsites","og_description":" notification : SQLSTATE[HY000]: General error: 1449 The user specified as a definer ('testuser'@'localhost') does not exist, query was: INSERT INTO `catalog_product_entity_media_gallery` (`attribute_id`, `value`, `media_type`) VALUES (?, ?, ?) The steps below allow you to customize the definer: Go to PHPMyAdmin Select your Database Select your table Click on 'Triggers' in the top menu Click 'Edit' to modify the trigger Change definer from (e.g. [testuser@localhost] to your definer e.g. root@localhost Good luck","og_url":"https:\/\/www.utilewebsites.nl\/en\/knowledgebase\/magento-2-the-user-specified-as-a-definer-does-not-exist\/","og_site_name":"Utilewebsites","article_modified_time":"2023-04-06T06:08:25+00:00","og_image":[{"url":"https:\/\/www.utilewebsites.nl\/wp-content\/uploads\/2018\/01\/mysql-definer-magento2-1024x491.jpg","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.utilewebsites.nl\/en\/knowledgebase\/magento-2-the-user-specified-as-a-definer-does-not-exist\/","url":"https:\/\/www.utilewebsites.nl\/en\/knowledgebase\/magento-2-the-user-specified-as-a-definer-does-not-exist\/","name":"Magento 2 The user specified as a definer does not exist - Utilewebsites","isPartOf":{"@id":"https:\/\/www.utilewebsites.nl\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.utilewebsites.nl\/en\/knowledgebase\/magento-2-the-user-specified-as-a-definer-does-not-exist\/#primaryimage"},"image":{"@id":"https:\/\/www.utilewebsites.nl\/en\/knowledgebase\/magento-2-the-user-specified-as-a-definer-does-not-exist\/#primaryimage"},"thumbnailUrl":"https:\/\/www.utilewebsites.nl\/wp-content\/uploads\/2018\/01\/mysql-definer-magento2-1024x491.jpg","datePublished":"2018-01-18T13:27:52+00:00","dateModified":"2023-04-06T06:08:25+00:00","breadcrumb":{"@id":"https:\/\/www.utilewebsites.nl\/en\/knowledgebase\/magento-2-the-user-specified-as-a-definer-does-not-exist\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.utilewebsites.nl\/en\/knowledgebase\/magento-2-the-user-specified-as-a-definer-does-not-exist\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.utilewebsites.nl\/en\/knowledgebase\/magento-2-the-user-specified-as-a-definer-does-not-exist\/#primaryimage","url":"https:\/\/www.utilewebsites.nl\/wp-content\/uploads\/2018\/01\/mysql-definer-magento2-1024x491.jpg","contentUrl":"https:\/\/www.utilewebsites.nl\/wp-content\/uploads\/2018\/01\/mysql-definer-magento2-1024x491.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.utilewebsites.nl\/en\/knowledgebase\/magento-2-the-user-specified-as-a-definer-does-not-exist\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.utilewebsites.nl\/en\/"},{"@type":"ListItem","position":2,"name":"Knowledge Base","item":"https:\/\/www.utilewebsites.nl\/en\/knowledgebase\/"},{"@type":"ListItem","position":3,"name":"Magento 2 The user specified as a definer does not exist"}]},{"@type":"WebSite","@id":"https:\/\/www.utilewebsites.nl\/en\/#website","url":"https:\/\/www.utilewebsites.nl\/en\/","name":"Utilewebsites","description":"","publisher":{"@id":"https:\/\/www.utilewebsites.nl\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.utilewebsites.nl\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.utilewebsites.nl\/en\/#organization","name":"Utilewebsites","url":"https:\/\/www.utilewebsites.nl\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.utilewebsites.nl\/en\/#\/schema\/logo\/image\/","url":"https:\/\/www.utilewebsites.nl\/wp-content\/uploads\/2019\/08\/logo-Utilewebsites-2017.png","contentUrl":"https:\/\/www.utilewebsites.nl\/wp-content\/uploads\/2019\/08\/logo-Utilewebsites-2017.png","width":3000,"height":593,"caption":"Utilewebsites"},"image":{"@id":"https:\/\/www.utilewebsites.nl\/en\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.utilewebsites.nl\/en\/wp-json\/wp\/v2\/wz_knowledgebase\/4503","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.utilewebsites.nl\/en\/wp-json\/wp\/v2\/wz_knowledgebase"}],"about":[{"href":"https:\/\/www.utilewebsites.nl\/en\/wp-json\/wp\/v2\/types\/wz_knowledgebase"}],"author":[{"embeddable":true,"href":"https:\/\/www.utilewebsites.nl\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.utilewebsites.nl\/en\/wp-json\/wp\/v2\/comments?post=4503"}],"version-history":[{"count":2,"href":"https:\/\/www.utilewebsites.nl\/en\/wp-json\/wp\/v2\/wz_knowledgebase\/4503\/revisions"}],"predecessor-version":[{"id":4505,"href":"https:\/\/www.utilewebsites.nl\/en\/wp-json\/wp\/v2\/wz_knowledgebase\/4503\/revisions\/4505"}],"wp:attachment":[{"href":"https:\/\/www.utilewebsites.nl\/en\/wp-json\/wp\/v2\/media?parent=4503"}],"wp:term":[{"taxonomy":"wzkb_category","embeddable":true,"href":"https:\/\/www.utilewebsites.nl\/en\/wp-json\/wp\/v2\/wzkb_category?post=4503"},{"taxonomy":"wzkb_tag","embeddable":true,"href":"https:\/\/www.utilewebsites.nl\/en\/wp-json\/wp\/v2\/wzkb_tag?post=4503"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}