title: using Mysql and SqlAlchemy in Pyramid Framework
body: <p>Pyramid Framework comes with a sample tutorial of sql alchemy that uses sqlite. The problem is that i want to use mysql so i change this </p>
  
  <pre><code>sqlalchemy.url = sqlite:///%(here)s/tutorial.db
  </code></pre>
  
  <p>Into this</p>
  
  <pre><code>sqlalchemy.url = mysql://root:22password@localhost/alchemy
  </code></pre>
  
  <p>when i try to run </p>
  
  <pre><code>../bin/pserve development.ini --reload
  </code></pre>
  
  <p>It gives me the following error</p>
  
  <pre><code> File "build/bdist.linux-i686/egg/sqlalchemy/connectors/mysqldb.py", line 52, in dbapi
  ImportError: No module named MySQLdb
  </code></pre>
  
  <p>I understand that i should include the dependecies of my app in setup.py but i don't know what to include right now some help please my setup.py looks like this</p>
  
  <pre><code>import os
  import sys
  
  from setuptools import setup, find_packages
  
  here = os.path.abspath(os.path.dirname(__file__))
  README = open(os.path.join(here, 'README.txt')).read()
  CHANGES = open(os.path.join(here, 'CHANGES.txt')).read()
  
  requires = [
      'pyramid',
      'SQLAlchemy',
      'transaction',
      'pyramid_tm',
      'pyramid_debugtoolbar',
      'zope.sqlalchemy',
      ]
  
  if sys.version_info[:3] &lt; (2,5,0):
      requires.append('pysqlite')
  
  setup(name='tutorial',
        version='0.0',
        description='tutorial',
        long_description=README + '\n\n' +  CHANGES,
        classifiers=[
          "Programming Language :: Python",
          "Framework :: Pylons",
          "Topic :: Internet :: WWW/HTTP",
          "Topic :: Internet :: WWW/HTTP :: WSGI :: Application",
          ],
        author='',
        author_email='',
        url='',
        keywords='web wsgi bfg pylons pyramid',
        packages=find_packages(),
        include_package_data=True,
        zip_safe=False,
        test_suite='tutorial',
        install_requires = requires,
        entry_points = """\
        [paste.app_factory]
        main = tutorial:main
        [console_scripts]
        populate_tutorial = tutorial.scripts.populate:main
        """,
        )
  </code></pre>