title: MySql connection using Python in VS2015 Community
body: <p>How do i connect to MySql database using python in Visual studio 2015 community? i have installed the pymssql in my project environment. what else do i need to do? i added the following connection string and its not working when i run my project:</p>
  
  <pre><code>from datetime import datetime
  from flask import render_template
  from SchoolsPortal import app
  import pymssql
  
  connection = pymssql.connect(server='localhost', user='root', password='admin', database='testschool')
  print('Connected')
  
  @app.route('/')
  @app.route('/home')
  def home():
      """Renders the home page."""`enter code here`
      return render_template(
          'index.html',
          title='Home Page',`enter code here`
          year=datetime.now().year,
      )
  </code></pre>