title: How to create a database in MySQL then link it to Python
body: <p>I am trying to create a database that I can then read from / write to in Python. I've tried installing the recommended dev installation via this <a href="https://dev.mysql.com/downloads/windows/installer/8.0.html" rel="nofollow noreferrer">https://dev.mysql.com/downloads/windows/installer/8.0.html</a>. I then went into the designer and added a table with some entities. However, the UX in MySQL is really terrible and I can't work out how to actually view the table in the database I've just created and add test values or whatever. I got frustrated and uninstalled MySQL completely because either I downloaded it incorrectly (I selected dev machine but I want to develop and run it on this machine, was that the wrong option?) or it's just terrible to deal with. However, it seems like there are no real alternatives unfortunately and so I would appreciate some help with regards to just setting up a simple database and connecting it to Python so I can perform SQL statements from my Python code. Also, another complication is that my normal Python installation (i.e. the one linked to PATH etc.) is 3.6, but I was forced to install 3.7 when I downloaded MySQL so I'm not really sure how that will work.</p>
  
  <p>Thanks.</p>