title: MySQL Username not case sensitive
body: <p>sir i have problem on php mysql login</p>
  
  <p>On my db:</p>
  
  <pre><code>username = admin 
  password = addbcea06efdd20f934b35e3b2111e55
  </code></pre>
  
  <p>1st i test This the query on mysql </p>
  
  <pre><code>SELECT COUNT(`user_id`) FROM `users` WHERE `username` = 'admin' AND `password` = 'addbcea06efdd20f934b35e3b2111e55'
  </code></pre>
  
  <p>the 1st result is 1</p>
  
  <p>but when i my second test </p>
  
  <pre><code>SELECT COUNT(`user_id`) FROM `users` WHERE `username` = 'Admin' AND `password` = 'addbcea06efdd20f934b35e3b2111e55'
  </code></pre>
  
  <p>why the result keep 1? This should be 0. I only change the username to capital letter.
  What should i do?</p>