title: MySQL Won't let User Login: Error 1524
body: <pre><code>Server version: 5.7.10 MySQL Community Server (GPL)
  </code></pre>
  
  <p>In MySQL, I have a user mangos. The user worked perfectly when I created it. After rebooting my computer, though, attempting to login to mangos yielded this output:</p>
  
  <pre><code>$ mysql -u mangos -p
  Enter password: 
  ERROR 1524 (HY000): Plugin '*some_random_long_hash_I_cannot_remember' is not loaded
  $ 
  </code></pre>
  
  <p>It kind of reminded me of a password hash, so after investigating mysql.user, I found that mangos had no password!
  I updated the password:</p>
  
  <pre><code>SET PASSWORD FOR 'mangos'@'127.0.0.1' = PASSWORD('mangos');
  FLUSH PRIVILEGES;
  </code></pre>
  
  <p>Now, I get:</p>
  
  <pre><code>ERROR 1524 (HY000): Plugin '*3FBBDB84EA2B2A0EA599948396AD622B7FF68183' is not loaded
  </code></pre>
  
  <p><code>3FBBDB84EA2B2A0EA599948396AD622B7FF68183</code> is the same number shown in the password column of mysql.user for mangos, and is a different number than originally. I still can't log in.</p>
  
  <p><strong>How do I make MySQL recognize a password properly?</strong> Is that even the issue here?</p>
  
  <p><em>Edits:</em></p>
  
  <pre><code>mysql&gt; SELECT * FROM mysql.user WHERE user = 'mangos' \G
  *************************** 1. row ***************************
  Host: localhost
                User: mangos
            Password: *3FBBDB84EA2B2A0EA599948396AD622B7FF68183
         Select_priv: N
         Insert_priv: N
         Update_priv: N
         Delete_priv: N
         Create_priv: N
           Drop_priv: N
         Reload_priv: N
       Shutdown_priv: N
        Process_priv: N
           File_priv: N
          Grant_priv: N
     References_priv: N
          Index_priv: N
          Alter_priv: N
        Show_db_priv: N
          Super_priv: N
  Create_tmp_table_priv: N
        Lock_tables_priv: N
            Execute_priv: N
         Repl_slave_priv: N
        Repl_client_priv: N
        Create_view_priv: N
          Show_view_priv: N
     Create_routine_priv: N
      Alter_routine_priv: N
        Create_user_priv: N
              Event_priv: N
            Trigger_priv: N
  Create_tablespace_priv: N
                ssl_type: 
              ssl_cipher: 
             x509_issuer: 
            x509_subject: 
           max_questions: 0
             max_updates: 0
         max_connections: 0
    max_user_connections: 0
                  plugin: *3FBBDB84EA2B2A0EA599948396AD622B7FF68183
   authentication_string: NULL
        password_expired: N
  </code></pre>