title: The user specified as a definer does not exist
body: <p>I get the following error after importing my database's backup into an already existing website:</p>
  
  <blockquote>
    <p><em>The user specified as a definer ('someuser'@'%') does not exist</em></p>
  </blockquote>
  
  <p>I am already logged into my database, and when I execute</p>
  
  <pre><code>SHOW PRIVILEGES;
  </code></pre>
  
  <p>I can see that I am allowed</p>
  
  <blockquote>
    <p><em>"To give to other users those privileges you posses..."</em></p>
  </blockquote>
  
  <p>Consequently, I execute</p>
  
  <pre><code>CREATE USER 'someuser'@'localhost' IDENTIFIED BY 'password';
  </code></pre>
  
  <p>but I get the following error:</p>
  
  <blockquote>
    <p><em>#1227 - Access denied; you need (at least one of) the CREATE USER privilege(s) for this operation</em></p>
  </blockquote>
  
  <p>I also tried the</p>
  
  <pre><code>GRANT ALL ON *.* TO 'someuser'@'%' IDENTIFIED BY 'password'; FLUSH PRIVILEGES;
  </code></pre>
  
  <p>alternative, but got the following response:</p>
  
  <blockquote>
    <p><em>#1045 - Access denied for user 'anotheruser'@'%' (using password: YES)</em></p>
  </blockquote>
  
  <p>Please someone help me out with this! I've read into another similar posts but those answers didn't work for me since I got the above specified responses.</p>