title: MySQL: Grant Privileges followed by Flush Privileges has not effect, no error (logged in as root)
body: <p>I and a teammember are stumped because commands to grant privileges to a remote user are failing, but with no error. The new user was successfully added to mysql.user using CREATE USER, but GRANT PRIVILEGES followed by FLUSH PRIVILEGES isn't affecting the grants table. Both these commands are supposed to say 'Query OK. 0 rows affected,' which they do. But then SHOW GRANTS doesn't show the new privileges, nor can we log in with that username from the specified remote ip. Can anyone explain the following behavior?</p>
  
  <pre><code>mysql&gt; SELECT CURRENT_USER();     ///I'm definitely in as root user
  +----------------+
  | CURRENT_USER() |
  +----------------+
  | root@localhost |
  +----------------+
  1 row in set (0.00 sec)
  
  mysql&gt; GRANT ALL PRIVILEGES ON *.* TO 'myNewUser'@'remoteIP';  //grant to existing user
  Query OK, 0 rows affected (0.00 sec)
  
  mysql&gt; FLUSH PRIVILEGES;
  Query OK, 0 rows affected (0.00 sec)
  
  mysql&gt; SHOW GRANTS;
  
   | Grants for root@localhost                                                                                                                   
  
  | GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD           '*////TakenOut///' WITH GRANT OPTION |
   | GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION                                                                              
  2 rows in set (0.00 sec)
  </code></pre>
  
  <p>I would expect a 3rd row with privileges for 'myNewUser'.</p>