SQLException: The user specified as a definer ('root'@'%') does not exist

This is due to the fact the user who originally created the data in the database has been deleted (in this case the user 'root'). If you re-create that user, it should address your error.