the user specified as a definer ('[email protected]') does not exist
Please help me to solve this issue, i've tried many solutions which has a green check, it still can't solve. The issue occurs after i accidentally changed all mysql user password, then created new user. When login with mysql workbench, the error show.
I tried
mysql_upgrade [return the user specified as a definer ('[email protected]') does not exist]
UPDATE mysql.proc [return proc table does not exist]
GRANT ALL [return the user specified as a definer ('[email protected]') does not exist]
I can't export, import, check tables cause it always says the user specified as a definer ('[email protected]') does not exist