title: AWS RDS using IM policy to be abbe to connect from another user.
body: <p>I created a MysQL RDS instance on AWS. 
  I can connect to MysQL using my own user who was the one that created the instance like that:</p>
  
  <pre><code>mysql -h aws-host -P 3306 -u MyUser -p
  </code></pre>
  
  <p>I need to give access to Mysql to other users who are already register on AWS.</p>
  
  <p>Manual: <a href="https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.IAMDBAuth.DBAccounts.html" rel="nofollow noreferrer">https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.IAMDBAuth.DBAccounts.html</a></p>
  
  <p>The User creation is working but when I log out from my user and try to logging again with the new user it does not work.  </p>
  
  <p>I'm having the problem that the user can not connect to Mysql because of Authentication plugin error.</p>
  
  <p>Command:</p>
  
  <pre><code>mysql -h aws-host -P 3306 -u newUser -p
  </code></pre>
  
  <p>when I type the password I get:</p>
  
  <pre><code>Error: ERROR 2059 (HY000): Authentication plugin 'mysql_clear_password' cannot be loaded: plugin not enabled
  </code></pre>
  
  <p>The password is correct because it's the one I use to loggin on aws with that user and IAM DB Authentication is enable, I thought IM and RDS should share passwords or I'm doing something wrong ??</p>