title: How to connect to mysql in pycharm community edition?
body: <p>I have a fresh install of pycharm community edition 2019.2 on mac 10.13.1</p>
  
  <p>I want to connect to the mysql database I have locally.</p>
  
  <p>I wrote a python file that starts</p>
  
  <p><code>import mysql.connector</code></p>
  
  <p>The 'mysql' part is underlined red, so I hover over it and get the message 'no module named mysql - install package mysql'</p>
  
  <p>I click on the link and it says 'packages installed successfully - installed packages : mysql'</p>
  
  <p>But the 'mysql' part of 'mysql.connector' remains red and it still says I haven't installed mysql.</p>
  
  <p>What am I missing? Would hope this would be more intuitive.</p>
  
  <p>Thanks!</p>