title: Authentication issue with C# connection to mysql
body: <p>So I have an application that is trying to use Command.ExecuteScalar, which works perfectly well on a connection with "root" credentials or with my own user credentials, but I have set up another user in workbench called "AgentsHighPriv" and with that it fails.</p>
  
  <p>The connectionstring is the same except for the substitution with the alternative username and password. However this username and password connects in MySql Workbench, what am I overlooking here.  </p>
  
  <p>The specific error message is:</p>
  
  <blockquote>
    <p>{"Authentication to host 'xxxx' for user 'AgentsHighPriv' using method 'mysql_native_password' failed with message: Access denied for user 'AgentsHighPriv'@'%' to database 'rbac'"}</p>
  </blockquote>
  
  <p>Well it seems there is a difference between credentials that I had not grasped. The privileges had some differences; "schema privalges" were the same as for my own user privileges but, the New User did not require admin privileges of any kind, so I did not use the tab and set global privileges. However if on the administrative roles tab I actually select one of the global privalages, - it then authenticates. At least to say it did so when I tested with select, show view, alter, and drop</p>
  
  <p>Yet I have these same privalages set on the Schema Privalages tab!</p>
  
  <p>So this will make it work now but I dont understand the logic - if anybody could explain I would be happy to hear. </p>
  
  <p>Thanks</p>