title: Cannot view MySQL data from table
body: <p>I've tried numerous possible things that I've Google but still viewing contents of table is not working. I even try to give root all privileges but still no effect. Just like magicarp's splash.</p>
  
  <p>Error Message:</p>
  
  <blockquote>
    <p>#1356 - View 'dbname.vw_access_rights' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them</p>
  </blockquote>
  
  <p>Tried Query:</p>
  
  <pre><code>CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `test_view` AS select `vw_access_rights`.`Menu_ID` AS `x`,`vw_access_rights`.`Menu_Name` AS `y` from `vw_access_rights`
  </code></pre>