title: I can connect to my RDS host server but not my database
body: <p>I've made a MySQL database using AWS RDS.</p>
  <p>Here is my code connecting to the server and printing the databases:</p>
  <pre class="lang-py prettyprint-override"><code>import mysql.connector
  
  mydb = mysql.connector.connect(user='admin', password='********',
                                host='************.eu-west-2.rds.amazonaws.com', port=3306)
  
  mycursor = mydb.cursor()
  
  databases = (&quot;show databases&quot;)
  mycursor.execute(databases)
  for (databases) in mycursor:
       print(databases)
  </code></pre>
  <p>It prints some standard databases that I assume are there by default.</p>
  <p>('information_schema',)
  ('mysql',)
  ('performance_schema',)
  ('sys',)</p>
  <p>If I include my database name in the above code, I get a &quot;database not found&quot; error.</p>
  <p>Which is obvious, because my database is not listed.</p>
  <p>No where can I find someone else with this problem and clearly I've made the database, how else would I have the host URL?</p>
  <p>I tried opening up the security group to all traffic to make sure that that isn't the problem.</p>
  <p><a href="https://i.stack.imgur.com/y9AxX.png" rel="nofollow noreferrer">Database on the AWS website is available and has a connection</a></p>
  <p>You can see that the database is available and that it recognises my connection.</p>