title: rowCount(), Why doesnt it work on create user ? Any options?
body: <p>Creating new user in mysql as :</p>
  
  <pre><code>$query = $dbconnection-&gt;prepare("CREATE USER 'john'@'localhost' IDENTIFIED BY 'mypass'");
  $query-&gt;execute();
  $counts = $query-&gt;rowCount();
  return $counts;
  </code></pre>
  
  <p>Generally in other queries, I use rowCount() to check whether the query got successful or not. if rowCount() >1, query successful. But I realised this doesnt work in creating user.
  <br>
  In this case, user is created, but rowCount() still results the value 0. Is there any way, to check whether this query is successful.</p>
  
  <p>UPDATE in @GHOST comment: 
     This query returns the value 1, to confirm that data is inserted, or a row is affected. </p>
  
  <pre><code>     $query = $this-&gt;link-&gt;prepare("INSERT INTO agent(uname,password,) VALUES(?,?");    
      $values = array($uname,$pw);
      $query-&gt;execute($values);
      $counts=$query-&gt;rowCount();
      return $counts;
  </code></pre>
  
  <p>I am looking for some way, to check in same way for the previous case.</p>