title: MySQL root privilege not restorable
body: <p>I really tried out everything I already found here.
  So I think i forgot my root password,... after getting into rescue mode with 
  --skip-grant-tables I found out, that there is no root user (anymore?).</p>
  
  <p>so,.. yeah, great,.. .how to solve it no privileged user is there anymore?
  I can't create one with "CREATE USER ...' because I'm in skip-grant-tables mode,... </p>
  
  <p>So I decided to insert a user manually. Now I have my root user back, with credentials and so on, but I'm not able to grant access to all tables and permissions.</p>
  
  <p>I tried this (I'm connectet to mysql with my 'newly' created root-account):</p>
  
  <pre><code>mysql&gt; SHOW GRANTS FOR 'root'@'localhost';
  +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  | Grants for root@localhost                                                                                                                                                                                                                                                                                                                     |
  +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  | GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER ON *.* TO 'root'@'localhost' WITH GRANT OPTION |
  +-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  1 row in set (0.00 sec)
  </code></pre>
  
  <p>Okay ... 
  then: </p>
  
  <pre><code>mysql&gt; GRANT ALL ON *.* TO 'root'@'localhost';
  ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
  mysql&gt; 
  </code></pre>
  
  <p>What?</p>
  
  <pre><code>mysql&gt; select Grant_priv, Super_priv from user where User='root';
  +------------+------------+
  | Grant_priv | Super_priv |
  +------------+------------+
  | Y          | Y          |
  +------------+------------+
  1 row in set (0.00 sec)
  
  mysql&gt; 
  </code></pre>
  
  <p>I don't get it....</p>
  
  <p>Yes, I flushed the privilege. I restarted the service multiple times. But still I'm not able to grant access to my root user.</p>
  
  <p>Please help :( </p>