MySQL - Login fails with incorrect match of case for username
<p>I am unable to login to mysql unless I provide exact case match for a user I have in my database.  </p>

<p>After looking into the issue I believe my problem is with the collation but I am not sure.  I tried to alter collation for the mysql.user table, User column to be latin1_swedish_ci but still could not get it to recognize alternate cases for usernames when I try to login.</p>

<p>My new username is admin ( all lowercase)</p>

<p>The command I am running is</p>

<pre><code>mysql -u admiN -p    &lt;------ with username ending in a capital letter
</code></pre>

<p>Prior to running the command I ran the SQL statement below.</p>

<p>Here is the command I ran with apparently no effect (Original Collation was utf8_bin)</p>

<pre><code>ALTER TABLE `user` CHANGE `User` `User` CHAR(16) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '';
</code></pre>

<p>Each time I get the following response.</p>

<blockquote>
  <p>ERROR 1045 (28000): Access denied for user 'admiN'@'localhost' (using
  password: YES)</p>
</blockquote>

<p>Only when I login with all lowercase for the username do I succeed in entering into mysql.</p>

<p>Am I missing something else here to get it working?  How do I change the mysql configuration to accept case insensitive usernames?</p>